I'm using Dynamic Data and have created a custom List.aspx page. I simply want to populate the grid with a stored procedure. I've seen some posts about doing this with a LinqDataSource but not an EntityDataSource. Does someone have an example or a different
way of doing this? Thanks.
It's a complex stored procedure with multiple temp tables and calculations. The DBA wants all queries in SQL stored procs if possible. Do you have any recomendations?? Thank you.
Thank you very much for the reply. These links are the same ones that I've seen and I've downloaded the code. They explain how to use stored procedures with a LinqDataSource but not an EntityDataSource. It appears there is a difference since the arguments
for the LinqDataSource are not the same. Is there something I'm misisng that could make this work?
I'm sorry for misunderstanding the question. If it's EntityDataSource, the stored procedure can't be called directly. Please check out this post for details:
Member
2 Points
11 Posts
Entity Framework 4.0 Dynamic Data - stored procedure
Aug 26, 2010 06:38 PM|Sandy25|LINK
I'm using Dynamic Data and have created a custom List.aspx page. I simply want to populate the grid with a stored procedure. I've seen some posts about doing this with a LinqDataSource but not an EntityDataSource. Does someone have an example or a different way of doing this? Thanks.
Member
242 Points
480 Posts
Re: Entity Framework 4.0 Dynamic Data - stored procedure
Aug 28, 2010 09:41 PM|klca|LINK
Hola,
Is there any special reason for doing this from a sp at all? Do you want to hide (wrap) that sp?
Carlos Porras (El Salvador)
Member
2 Points
11 Posts
Re: Entity Framework 4.0 Dynamic Data - stored procedure
Aug 29, 2010 04:16 PM|Sandy25|LINK
It's a complex stored procedure with multiple temp tables and calculations. The DBA wants all queries in SQL stored procs if possible. Do you have any recomendations?? Thank you.
All-Star
46442 Points
5765 Posts
Re: Entity Framework 4.0 Dynamic Data - stored procedure
Aug 30, 2010 11:05 PM|Wencui Qian - MSFT|LINK
Please take a look at these two posts:
http://blogs.msdn.com/b/joestagner/archive/2008/09/03/dynamic-data-with-stored-procedures.aspx
http://dotnetslackers.com/XML/re-134238_Dynamic_Data_with_Stored_Procedures.aspx
Thanks.
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework
Member
2 Points
11 Posts
Re: Entity Framework 4.0 Dynamic Data - stored procedure
Sep 01, 2010 08:30 AM|Sandy25|LINK
Thank you very much for the reply. These links are the same ones that I've seen and I've downloaded the code. They explain how to use stored procedures with a LinqDataSource but not an EntityDataSource. It appears there is a difference since the arguments for the LinqDataSource are not the same. Is there something I'm misisng that could make this work?
All-Star
46442 Points
5765 Posts
Re: Entity Framework 4.0 Dynamic Data - stored procedure
Sep 01, 2010 09:56 PM|Wencui Qian - MSFT|LINK
I'm sorry for misunderstanding the question. If it's EntityDataSource, the stored procedure can't be called directly. Please check out this post for details:
http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/93e7f32d-7bd0-45d5-8fc0-4221ef27f15b
Thanks.
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework