+1 for LINQPad and LINQ. If you do try LINQPad (which is free) then I highly recommend purchasing the $20 IntelliSense add-on. Especially if you are just getting starting in LINQ.
In the interests of full-disclosure, Joe (the author of LINQPad) is a friend but I use LINQPad as a general snippet compiler for a bunch of different stuff (including keeping a TV schedule). I have tried to get FluentNHibernate and LINQtoNHibernate working together once before and it was a painful experience. Once I had it working though, it was great. On Wed, Jul 14, 2010 at 9:14 AM, James Chapman-Smith <ja...@enigmativity.com > wrote: > +1 for LINQPad > > > > *From:* ozdotnet-boun...@ozdotnet.com [mailto: > ozdotnet-boun...@ozdotnet.com] *On Behalf Of *Dylan Tusler > *Sent:* Wednesday, 14 July 2010 10:20 > *To:* 'ozDotNet' > > *Subject:* RE: Advice for Data Access - Hibernate/Linq/Fluent/etc > > > > Get a hold of LinqPAD (www.linqpad.net) and you won't look back. > > > > Having spent a lot of yesterday trying to get a .nettiers project > compiling, I'm so thankful for LINQ. > > > > Dylan. > > > > > ------------------------------ > > *From:* ozdotnet-boun...@ozdotnet.com [mailto: > ozdotnet-boun...@ozdotnet.com] *On Behalf Of *ben.robb...@jlta.com.au > *Sent:* Wednesday, 14 July 2010 10:48 AM > *To:* ozdotnet@ozdotnet.com > *Subject:* RE: Advice for Data Access - Hibernate/Linq/Fluent/etc > > Great link Corneliu, do you know if there is an equivalent page for C#? > > > > After a bit of Googling and browsing the closest I got was this: > http://msdn.microsoft.com/en-us/vcsharp/aa336746.aspx > > > > Ben > > > ------------------------------ > > *From:* ozdotnet-boun...@ozdotnet.com [mailto: > ozdotnet-boun...@ozdotnet.com] *On Behalf Of *Corneliu I. Tusnea > *Sent:* Wednesday, 14 July 2010 7:14 AM > *To:* ozDotNet > *Subject:* Re: Advice for Data Access - Hibernate/Linq/Fluent/etc > > I think the simplest/lightest/quickest way to craft an ORM over a DB is > LINQ to SQL. > > You can't make it any simpler that than. I don't understand why MS stopped > developing. > > They try too hard to move in the "we love everyone and every db camp at the > expense of our own SQL". > > > > Have this page open all the time and you'll be flying with the LINQ > syntax. > > http://msdn.microsoft.com/en-us/vbasic/bb688085.aspx > > > > Corneliu. > > > > On Wed, Jul 14, 2010 at 9:05 AM, Peter Arvoll <ozdot...@dotnetpete.com> > wrote: > > Hi Les > > I my opinion LINQ is worth the learning curve because it allows fairly > rapid development of applications compared to an application with > dedicated business objects and associated stored procedures. We code > generate all of our data acces objects and stored procedures but when > there's a change to the database schema it's much quicker to modify > the dbml file (or delete the changed entiries and drop them back on) > than to re generate the data access objects and modify stored procs. I > am talking LINQ to SQL here as it doesn't have the facility to update > the model from a database. > > And LINQ can be used for more than just data access. It's a very neat > way to interaction with collections of objects where previously you > would have had to loop through the collections to do tasks linq had > the foreach syntax. And it's easy to create a subset of an object > collection too. > > LINQ to XML is in my opionion a much easier way (and faster > development wise) to consume an XML file. > > I have not had any commercial experience with NHibernate so I am not > able to compare there. > > Thanks > Peter > > > On Wed, Jul 14, 2010 at 1:18 AM, Les Hughes <l...@datarev.com.au> wrote: > > > > Hi All, > > > > I'm about to start working on a mid-sized data-centric app (accounting > area) > > which is mostly just lots of forms which display data, edit/write data, > and > > then spitting out some pretty reports, etc with the data sitting in SQL > > Server. (Think of old-school MSaccess apps) > > > > Wanting to avoid as much SQL plumbing as I can, I'm looking to use > > nHibernate for a lot of the lifting, but haven't had a chance to look > around > > at perhaps some better packages/practices/etc which exist. > > > > At this stage I have spent near zero time with Linq, and have only heard > of > > a few other packages in passing (Fluent/Active Record/etc), and am > wondering > > what (if anything) I should spend some time looking in to. > > > > My query is: > > > > - Is nHibernate still the way to go? What do the rest of the .NETters use > > for their data access layers? And why? Is Linq worth the learning curve? > > > > Any feedback would be greatly appreciated. > > > > Thanks in advance, > > -- > > Les Hughes > > l...@datarev.com.au > > > > > > This email is intended for the named recipient only. The information it > contains may be confidential or commercially sensitive. If you are not the > intended recipient you must not reproduce or distribute any part of this > email, disclose its contents to any other party, or take any action in > reliance on it. If you have received this email in error, please contact the > sender immediately and delete the message from your computer. > > ------------------------------ > > To find out more about the Sunshine Coast Regional Council, visit your > local office at Caloundra, Maroochydore, Nambour or Tewantin or visit us > online at www.sunshinecoast.qld.gov.au. If correspondence includes > personal information, please refer to Council's Privacy > Policy<http://www.sunshinecoast.qld.gov.au/sitePage.cfm?code=disclaimer> > . > > This email and any attachments are confidential and only for the use of the > addressee. If you have received this email in error you are requested to > notify the sender by return email or contact council on 1300 00 7272 and are > prohibited from forwarding, printing, copying or using it in anyway, in > whole or part. Please note that some council staff utilise Blackberry > devices, which results in information being transmitted overseas prior to > delivery of any communication to the device. In sending an email to Council > you are agreeing that the content of your email may be transmitted overseas. > Any views expressed in this email are the author's, except where the email > makes it clear otherwise. The unauthorised publication of an email and any > attachments generated for the official functions of council is strictly > prohibited. Please note that council is subject to the Right to Information > Act 2009 (Qld) and Information Privacy Act 2009 (Qld). > -- Michael M. Minutillo Indiscriminate Information Sponge Blog: http://wolfbyte-net.blogspot.com
