Click here to Skip to main content
15,921,959 members
Home / Discussions / ASP.NET
   

ASP.NET

 
SuggestionRe: A bit lost here... Pin
Richard Deeming2-Jun-15 5:54
mveRichard Deeming2-Jun-15 5:54 
GeneralRe: A bit lost here... Pin
Kornfeld Eliyahu Peter2-Jun-15 20:28
professionalKornfeld Eliyahu Peter2-Jun-15 20:28 
QuestionRegarding one to one Video calling with Chat Pin
Usefuldesk2-Jun-15 1:22
Usefuldesk2-Jun-15 1:22 
SuggestionRe: Regarding one to one Video calling with Chat Pin
Richard MacCutchan2-Jun-15 2:29
mveRichard MacCutchan2-Jun-15 2:29 
QuestionAdd windows form module in Web application Pin
Aniiil1-Jun-15 22:33
Aniiil1-Jun-15 22:33 
Answer[repost] Pin
F-ES Sitecore2-Jun-15 0:43
professionalF-ES Sitecore2-Jun-15 0:43 
GeneralRe: [repost] Pin
Aniiil2-Jun-15 0:58
Aniiil2-Jun-15 0:58 
QuestionDesign view for MVC its now 2015 Pin
Member 117338681-Jun-15 10:26
Member 117338681-Jun-15 10:26 
AnswerRe: Design view for MVC its now 2015 Pin
F-ES Sitecore1-Jun-15 22:28
professionalF-ES Sitecore1-Jun-15 22:28 
GeneralRe: Design view for MVC its now 2015 Pin
Member 117338682-Jun-15 12:08
Member 117338682-Jun-15 12:08 
GeneralRe: Design view for MVC its now 2015 Pin
F-ES Sitecore2-Jun-15 12:23
professionalF-ES Sitecore2-Jun-15 12:23 
GeneralRe: Design view for MVC its now 2015 Pin
Member 117338682-Jun-15 13:26
Member 117338682-Jun-15 13:26 
Questionedit respective record after login Pin
Mahima Singh1-Jun-15 1:14
professionalMahima Singh1-Jun-15 1:14 
AnswerRe: edit respective record after login Pin
Afzaal Ahmad Zeeshan1-Jun-15 6:08
professionalAfzaal Ahmad Zeeshan1-Jun-15 6:08 
QuestionUsing Stored Proc IN EF Pin
MadDashCoder31-May-15 12:34
MadDashCoder31-May-15 12:34 
QuestionMapping Stored Proc To Entities In Entity Framework 5 Pin
MadDashCoder29-May-15 6:45
MadDashCoder29-May-15 6:45 
Hi all, I have a database with four tables and they have the following schemas
  dbo.Authors                  dbo.BookAuthor              dbo.Books
|------------------------| |------------------| |-------------------------|
|AuthorID not null int PK| |ID not null int PK| | BooKID not null int PK  |
|                        | |                  | |                         |
|FirstName nvarchar(30)  | | BookID int  FK   | | Title nvarchar(150)     |
|                        | |                  | |                         |
|LastName nvarchar(30)   | | AuthorID int FK  | | Genre nvarchar(50)      |
|                        | |                  | |                         |
|Contact nvarchar(50)    | |------------------| |-------------------------|
|------------------------|  

  dbo.BookGenre
|------------------| 
|ID not null int PK| 
|                  | 
|BookID int  FK    | 
|                  | 
|GenreID int FK    | 
|------------------| 

If I join all of my tables together in a stored proc called sp_GetBookDetails which returns data from the columns Title, Genre, FirstName, and LastName, how do I map this stored proc to Entities?

The problem I ran into was that when I tried to map my stored proc to Entities in the Add Function Import popup, I can only choose a single table instead of all four tables that were involved in my joins.

How do I make use of my stored proc in this situation? Thanks in advance for your reply.

modified 29-May-15 15:05pm.

AnswerRe: Mapping Stored Proc To Entities In Entity Framework 5 Pin
jkirkerx29-May-15 7:32
professionaljkirkerx29-May-15 7:32 
QuestionConvert to Yes/No and Empty is Null Pin
byka29-May-15 4:13
byka29-May-15 4:13 
AnswerRe: Convert to Yes/No and Empty is Null Pin
jkirkerx29-May-15 7:24
professionaljkirkerx29-May-15 7:24 
AnswerRe: Convert to Yes/No and Empty is Null Pin
Afzaal Ahmad Zeeshan1-Jun-15 6:05
professionalAfzaal Ahmad Zeeshan1-Jun-15 6:05 
GeneralRe: Convert to Yes/No and Empty is Null Pin
byka2-Jun-15 4:33
byka2-Jun-15 4:33 
QuestionMemory issues with 32-bit app Pin
Bala.ram26-May-15 19:52
Bala.ram26-May-15 19:52 
AnswerRe: Memory issues with 32-bit app Pin
jkirkerx27-May-15 8:44
professionaljkirkerx27-May-15 8:44 
GeneralRe: Memory issues with 32-bit app Pin
Bala.ram1-Jun-15 20:26
Bala.ram1-Jun-15 20:26 
GeneralRe: Memory issues with 32-bit app Pin
jkirkerx2-Jun-15 6:17
professionaljkirkerx2-Jun-15 6:17 

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.