[Mono-dev] Linq, Nhibernate or subsonic ?

[Onur Gumus]

Before comparing the technical merits you should consider that "Linq to SQL"
is not supported by mono at the moment.(Which is not a big loss for me
anyway). Linq is the general name given to linq bindings and currently we
have : Linq to Objects, Linq to Sql, Linq to XML, Linq to JSON, Linq to
NHibernate, Linq to DB4O, etc ... bindings  are available if I recall
correctly.

For subsonic and NHibernate , I never used subsonic on mono but I've read it
was working on mono. On the other hand, I used NHibernate extensively on
mono/linux/postgresql and I am quite happy with it.

Finally, Nhibernate does support stored procs but triggers and views are not
supported by any of these frameworks directly. NHibernate offers
interceptors for intercepting your db transactions before it hits to db's so
in a way it emulates triggers that way. Still however you can use triggers
independently. Not sure how others handle it. Finally it took 1 full month
for me to feel myself comfortable with NHibernate due to it's high
complexity (or may be I am not smart enough), but it was well worth.



just my 2 cents

Onur

2008/2/24 Sharique uddin Ahmed Farooqui <safknw at gmail.com>:

> Hi,
>
> I'm planning to build an ERP for my organisation. We will use mono as
> primary development platform. I'm a bit confused abt what should for DAL. I
> know little abt linq .
> What I have decided for DAL is
> 1. auto generated code must be extend able either in same class or as a
> separate class.
> 2. It must expose all databse views, triggers, stored procedures in DAL.
>
>
> Pls help me find out the right thing.
>
> Thanks.
> --
> Sharique uddin Ahmed Farooqui
> (C++/C# Developer, IT Consultant)
> A revolution is about to begin.
> A world is about to change.
> And you and I are "the initiator".
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20080224/d61592e7/attachment.html