Click here to Skip to main content
15,913,722 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Timer Time question Pin
Luc Pattyn18-Feb-10 15:23
sitebuilderLuc Pattyn18-Feb-10 15:23 
QuestionMessage Removed Pin
18-Feb-10 5:34
professionalN_tro_P18-Feb-10 5:34 
AnswerRe: Installer Prerequisites... Pin
Ennis Ray Lynch, Jr.18-Feb-10 6:33
Ennis Ray Lynch, Jr.18-Feb-10 6:33 
AnswerRe: Installer Prerequisites... Pin
dan!sh 18-Feb-10 6:38
professional dan!sh 18-Feb-10 6:38 
AnswerRe: Installer Prerequisites... Pin
William Winner18-Feb-10 8:35
William Winner18-Feb-10 8:35 
AnswerRe: Installer Prerequisites... Pin
Abhinav S18-Feb-10 9:00
Abhinav S18-Feb-10 9:00 
Questionhow to call stored procedure that return values from multible tables using entity framework ?? Pin
gold_killer17-Feb-10 23:38
gold_killer17-Feb-10 23:38 
AnswerRe: how to call stored procedure that return values from multible tables using entity framework ?? Pin
Hardik P Patel18-Feb-10 21:55
Hardik P Patel18-Feb-10 21:55 
Hi,

To retrieve multiple records using more than one table, you have to create your custom entity on Entity Framework Model. Follow the below steps:

1. Open Entity Framework Model file (*.edmx) in Visual studio
2. Right click on design pane and select "Add" -> "Entity"
3. One blank entity is created. Just add number of properties which you need to retrieve from the database (please check the property of each columns means data type, Nullable and Entity Key option)
4. After creating custom activity, Right click on design pane and select "Add" -> "Function Import".
5. In function import dialog box, select your stored procedure, Function name and select Return type as "Entities" and select custom entity from the drop down box. Click on OK button.
6. Now you have to call that function to retrieve data from the stored procedure. please find code below:

TestDBEntities1 testdb = new TestDBEntities1();<br />
var p = from d in testdb.GetOrderInfo() select d;<br />
MessageBox.Show(p.Count<OrderInformationEntity>().ToString());




Here TestDBEntities1 is my entity framework class and OrderInformationEntity is a custom entity.

You can find primary information of using Entity framework here.

Hardik Patel
Blog: DotNet Code Guru
Regards,
Hardik Patel

QuestionDatagridview sorting and Database. Pin
Johnkokk17-Feb-10 20:26
Johnkokk17-Feb-10 20:26 
AnswerRe: Datagridview sorting and Database. Pin
Ashfield18-Feb-10 3:15
Ashfield18-Feb-10 3:15 
GeneralRe: Datagridview sorting and Database. Pin
Johnkokk18-Feb-10 5:00
Johnkokk18-Feb-10 5:00 
GeneralRe: Datagridview sorting and Database. Pin
Johnkokk19-Feb-10 21:18
Johnkokk19-Feb-10 21:18 
QuestionHello Can any one help me out real quick please [modified] Pin
Bob Beaubien17-Feb-10 9:12
Bob Beaubien17-Feb-10 9:12 
AnswerRe: Hello Can any one help me out real quick please Pin
ricmil4217-Feb-10 10:18
ricmil4217-Feb-10 10:18 
GeneralRe: Hello Can any one help me out real quick please Pin
Bob Beaubien17-Feb-10 10:50
Bob Beaubien17-Feb-10 10:50 
GeneralRe: Hello Can any one help me out real quick please Pin
ricmil4217-Feb-10 10:51
ricmil4217-Feb-10 10:51 
GeneralRe: Hello Can any one help me out real quick please Pin
Bob Beaubien17-Feb-10 10:52
Bob Beaubien17-Feb-10 10:52 
GeneralRe: Hello Can any one help me out real quick please Pin
Andy_L_J17-Feb-10 18:27
Andy_L_J17-Feb-10 18:27 
QuestionExntending windows explorer Pin
seanwright17-Feb-10 8:14
seanwright17-Feb-10 8:14 
AnswerRe: Exntending windows explorer Pin
Ashfield17-Feb-10 22:01
Ashfield17-Feb-10 22:01 
GeneralRe: Exntending windows explorer Pin
seanwright18-Feb-10 0:34
seanwright18-Feb-10 0:34 
AnswerRe: Exntending windows explorer Pin
Dave Kreskowiak18-Feb-10 2:26
mveDave Kreskowiak18-Feb-10 2:26 
QuestionOdbcCommandBuilder DeriveParameters Problem Pin
JimFeng17-Feb-10 5:55
JimFeng17-Feb-10 5:55 
QuestionHelp regarding hosting/Development server? Pin
callousfantom17-Feb-10 0:05
callousfantom17-Feb-10 0:05 
AnswerRe: Help regarding hosting/Development server? Pin
Not Active17-Feb-10 0:26
mentorNot Active17-Feb-10 0:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.