Database Specific SQL

Topics: Development Team Discussion, User Discussion
Oct 24, 2014 at 8:37 PM
Having read through the latest documentation regarding the Data Application Block, I noticed that it seemed to avoid a large discussion around how to handle database specific SQL.

They seemed to imply that one could write LINQ and have the client handle this, but then at the same time said it was not practical in many cases.

For example, I am working with a couple databases and both use different sql to select that identity of the last row inserted.

e.g. select scope_identity()
e.g. select last_identity()
etc.

Just wondering what others have done to solve this problem.