Linq query or plain SQL? On using tools for what they are made for.

added by notherdev
11/18/2011 8:54:15 AM

1 Kicks, 97 Views

There are some scenarios where using NHibernate.Linq makes no sense. NHibernate's provider is just a tool, with its design, its features and its limitations. It's important to be aware what each tool is the best at and not to look for universal tool.


11/18/2011 8:56:16 AM
I feel many developers make the mistake of ignoring SQL. Like you said, when fetching business objects, work with your ORM; otherwise, you should probably look into SQL. I think mass updates are a situation where it pretty much never makes sense to use your ORM for the task, and an easy dividing line for developers who are unexperienced with data access to go by.