« Return to Thread: Linq, Nhibernate or subsonic ?

Re: Linq, Nhibernate or subsonic ?

by nicolasdiazaragon :: Rate this Message:

Reply to Author | View in Thread

What do you mean by saying that not yet having linq to sql isn´t a big loss and that it can be replaced by using nhibernate?
Have you tried linq to sql? have you compared it to using hibernate?
Maybe if all you code is meant to be part of some desktop application, then you are fine with hibernate. But if you intend to build real enterprise applications, then you should use linq to sql. Not only does it make code more simple and easy to read, it gets things done faster than hibernate does and you don't have to bother writing boring XML files. And it let´s you use nameless class types while querying the data base. These nameless classes can then be bound to a GUI control or used for further processing. Try doing that with hibernate... you would have to perform very expensive castings  (all your query results are strongly typed in linq to sql, but not in hibernate... everything returned by a hibernate query is just an 'object'...) and there is absolutely no WAY to use nameless types while querying the database with hibernate.
I've been writing java code since I was a 14 year old. I begun coding JEE at the same time I became acquainted with the dot net framework. By the time linq to sql was released (a couple of years later) I was very dissapointed because I realized that the dot net framework had leaped light years ahead of java (my personal favorite until then).
So no linq to sql support is a huge loss to me. If I were to code some enterprise application without linq to sql support, I´d rather work on JEE than on dot net.

reverse blade wrote:
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@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@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>

_______________________________________________
Mono-devel-list mailing list
Mono-devel-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list

 « Return to Thread: Linq, Nhibernate or subsonic ?