Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 247

Object-relational mapping is a programming technique that allows applications to work with the data as objects, but store the data in a database as groups of simpler values.

18 votes

When using an ORM, what are some things to watch out for in your database design

- How can I override the ORM and write my own query? - Can I use stored procs instead? The database should be ORM agnostic since, more than likely, it will outlast the app. …
Eric Humphrey - lotsahelp's user avatar
5 votes

How does NHibernate handle execution plan?

ORMs aren't usually the problem themselves, it's how they're used. SQL Server generates the execution plan. NHibernate can generate a query that causes SQL to generate a bad execution plan. If you use …
Eric Humphrey - lotsahelp's user avatar
1 vote

Why does this Entity Framework query perform so bad in MySQL?

I know LINQ queries are composable, but have you tried playing with the order of LINQ operations to see if it could affect the query generator? This question may be better served over on Stack Overflo …
Eric Humphrey - lotsahelp's user avatar
10 votes

Is the ADO.NET Entity Framework known for generating poorly performing queries?

It depends on what the queries are. ORMs are usually really good at CRUD, as they are usually simple. The more complex the query, the greater the chance of a bad query. You can tweak the generated que …
Eric Humphrey - lotsahelp's user avatar