No announcements
Found 3915667 threads
-
0 Votesreturning multiple resultset from a stored procedure
You cannot express a multiple result sets from a stored procedure in the metadata files and so the EntityClient does not support this directly.Answered | 2 Replies | 6585 Views | Created by zeeshan hirani - Wednesday, September 2, 2009 3:20 PM | Last reply by Jeff Derstadt - MSFT - Wednesday, September 16, 2009 4:29 PM
-
0 Votes
Stored procedure that doesn't always return a resultset
What stored procedure needs to return must be consistent ...Answered | 3 Replies | 4859 Views | Created by JendaPerl - Thursday, December 2, 2010 2:17 PM | Last reply by JendaPerl - Monday, December 6, 2010 9:25 PM -
0 Votes
EF EDMX and Stored Procedures
bad news for those of us that deal with (a lot of) stored procedures.Answered | 2 Replies | 4013 Views | Created by Dean Blakely - Thursday, August 5, 2010 11:26 PM | Last reply by Michael Sun [MSFT] - Wednesday, August 11, 2010 9:56 AM -
0 Votes
Insert a value into the resultset returned by a stored procedure
In that case, Chirag also mentioned that you can use union in your stored precedure.Answered | 4 Replies | 5496 Views | Created by Jack_Oh - Friday, February 5, 2010 7:20 PM | Last reply by Rajesh Jonnalagadda - Monday, February 8, 2010 1:49 PM -
0 Votes
Stored Procedure in EF
custom entity.Answered | 2 Replies | 5691 Views | Created by maridob - Friday, September 17, 2010 9:37 PM | Last reply by Michael Sun [MSFT] - Wednesday, September 22, 2010 5:44 AM -
0 Votes
How I can put Where clause to resultset of stored procedure
You can modify your stored procedure to add a filter parameter which can be passed while calling the SP.Answered | 12 Replies | 10745 Views | Created by Swapnil Mahajam - Thursday, November 11, 2010 10:25 AM | Last reply by Kalman Toth - Friday, November 12, 2010 4:14 PM -
0 Votes
EF and Store Procedure returning multiple result sets of complex types
get a stored procedure to return multiple resluts sets and translate > them into entiity objects.Answered | 4 Replies | 4904 Views | Created by Iceonovich - Thursday, November 10, 2011 8:11 PM | Last reply by Iceonovich - Monday, November 14, 2011 9:30 PM -
1 Votes
passing ResultSet from exec in stored procedure as the final result
In addition to Stan's, there're some other ways to hold the resultset of a stored procedure.Answered | 2 Replies | 595 Views | Created by Flapz - Monday, April 27, 2015 4:28 PM | Last reply by Eric__Zhang - Tuesday, April 28, 2015 7:03 AM -
1 Votes
EF 4.0's support for output parameters in stored procedures
To be able to use stored procedures in EF the SP's must follow specific rules.Answered | 7 Replies | 6965 Views | Created by RahulMisra2000 - Monday, February 7, 2011 5:50 PM | Last reply by RahulMisra2000 - Tuesday, March 1, 2011 5:55 PM -
0 Votes
How to retrieve large string from stored procedure?
I think there is an example in the link that uses stored procedure with output parameter and gives VB/C# sample to retrieve it - Was that not helpful?Answered | 5 Replies | 8029 Views | Created by Cheng Yik, Tay - Friday, May 4, 2007 9:21 AM | Last reply by Raj Kasi - MSFT - Thursday, May 24, 2007 3:09 AM -
0 Votes
Problems with EF 3.5 and Stored Procedures
I did that and it worked, so I punted on EF.Answered | 3 Replies | 684 Views | Created by Darren Mar-Elia - Tuesday, September 22, 2015 1:39 AM | Last reply by DA924 - Wednesday, September 23, 2015 2:55 PM -
0 Votes
Can you return multiple resultsets in a stored procedure using Entity Framework
If I have procedure that returns multiple select statements, I'm not sure how to handle it when I import it into the model.Answered | 3 Replies | 7640 Views | Created by Chockalingam S - Wednesday, July 27, 2011 6:58 PM | Last reply by dat1 - Wednesday, March 7, 2012 4:52 PM -
0 Votes
How to retrieve Dynamic Resultset from Stored Procedure using EF
<http://blogs.msdn.com/b/alexj/archive/2009/11/07/tip-41-how-to-execute-t-sql-directly-against-the-database.aspx> You can use EF connection, ...Answered | 1 Replies | 13151 Views | Created by Udhayasankari Velumani - Friday, June 8, 2012 8:57 AM | Last reply by darnold924 - Friday, June 8, 2012 3:19 PM -
0 Votes
EF query generation vs writing your own stored procedures
You'd better know how EF work in order to use them to their fullest.Answered | 1 Replies | 5428 Views | Created by danparker276 - Wednesday, June 15, 2016 5:37 AM | Last reply by Zhanglong Wu - Thursday, June 16, 2016 1:34 AM -
1 Votes
Newbie Question: How do I read data into multiple objects from a single stored procedure using EF4
It is kind of possible to read multiple objects from a single procedure.Answered | 5 Replies | 7059 Views | Created by imsam67 - Saturday, April 9, 2011 12:55 AM | Last reply by zeeshan hirani - Friday, April 29, 2011 6:40 PM -
0 Votes
how to combine multiple stored procedure which return dynamic columns
You have procedures that produce dynamic pivot, but they are only for client consumption.Answered | 7 Replies | 2733 Views | Created by swat3003 - Thursday, December 20, 2012 6:42 AM | Last reply by Erland Sommarskog - Thursday, December 20, 2012 1:09 PM -
0 Votes
EF 4 Stored Procedure Mixed In With LINQ
A stored procedure can not be joined in a TSQL query, so EF would not be able to translate a L2E query like that into TSQL.Answered | 1 Replies | 4219 Views | Created by bmains - Wednesday, November 17, 2010 3:58 PM | Last reply by KristoferA - Thursday, November 18, 2010 4:03 AM -
3 Votes
How to call Stored Procedure from Entity Framework?
The way how you call stored procedure from EF will be still the same.Answered | 5 Replies | 34187 Views | Created by h_maksuda - Friday, May 27, 2011 7:39 PM | Last reply by Dibu.net - Friday, August 30, 2013 5:50 AM -
0 Votes
Dynamic select in stored procedure
So why do you want to do this in a stored procedure?Answered | 3 Replies | 2735 Views | Created by Doraemon_3 - Thursday, February 2, 2012 7:15 AM | Last reply by Erland Sommarskog - Thursday, February 2, 2012 9:30 AM -
0 Votes
How to pass Table or resultset into procedure
IS NULL) AND (Temp_Table.Services = Master_Table.Services OR Temp_Table.Services IS NULL AND Master_Table.Services IS NULL); 2) ...Answered | 4 Replies | 5443 Views | Created by chr123 - Friday, July 15, 2011 12:46 AM | Last reply by chr123 - Monday, July 18, 2011 4:52 PM - Items 1 to 20 of 3915667 Next ›
No announcements
