Click here to Skip to main content
15,887,485 members
Home / Discussions / ASP.NET
   

ASP.NET

 
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 
QuestionMessage Closed Pin
21-May-15 5:16
Stephen Holdorf21-May-15 5:16 
AnswerRe: MS SqlDbType to C# type converter Pin
Richard MacCutchan21-May-15 5:39
mveRichard MacCutchan21-May-15 5:39 
AnswerRe: MS SqlDbType to C# type converter Pin
jkirkerx21-May-15 13:29
professionaljkirkerx21-May-15 13:29 
GeneralRe: MS SqlDbType to C# type converter Pin
Stephen Holdorf27-May-15 8:56
Stephen Holdorf27-May-15 8:56 
GeneralRe: MS SqlDbType to C# type converter Pin
jkirkerx27-May-15 9:20
professionaljkirkerx27-May-15 9:20 
Questionhow to develop price comparison website in asp.net? Pin
only4ram20-May-15 0:03
only4ram20-May-15 0:03 
GeneralRe: how to develop price comparison website in asp.net? Pin
Richard MacCutchan20-May-15 0:11
mveRichard MacCutchan20-May-15 0:11 
QuestionSelf Hosted SignalR Issues Pin
bennettdan18-May-15 17:17
bennettdan18-May-15 17: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.