Caveman's Blog

My commitment to learning.

Linq: Stored procedure limitations

leave a comment »

Following are a couple of Linq-to-SQL limitations that are important when considering using stored procedures in the application

  • Stored procedures that use dynamic SQL to return result sets. When a stored procedure contains conditional logic to build a dynamic SQL statement, LINQ to SQL cannot acquire metadata for the resultset because the query used to generate the resultset is unknown until run time.
  • Stored procedures that produce results based on temporary table.

Written by cavemansblog

April 23, 2011 at 11:43 pm

Posted in Dotnet, Linq

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: