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

ASP.NET

 
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 
Hi all, in my database I have 5 tables called Books, Genres, Authors, BookAuthor, and BookGenre. Both BookAuthor and BookGenre are bridge tables are bridge tables so when I create Entities for my tables using Entity Framework entities for the both of them were not created.

Entities for Books, Genres, and Authors tables were created. I also have a stored proc called _RetreiveBookDetails that joins all 5 tables together which returns the author's firstname, author's lastname, book's title, and book's genre if the required parameters are supplied by the user.

During the Entity Creation process I selected all of the tables used in the join and also selected the stored proc. The Complex Type which was automatically created is called RetreiveBookDetails_Result.

I've tested my stored proc in SSMS and I know it works. The problem is I can not get any data when I execute the stored proc using DBContext and supplying my stored proc with the necessary parameters. Below is my code, please take a look to see where I may have made my mistakes, thanks in advance.
C#
public static List<_RetreiveBookDetails_Result> GetBooks(BookAuthorObj ba)
        {
             List<_RetreiveBookDetails_Result>  bookList = new List<_RetreiveBookDetails_Result>();

            using (var baContext = new BookAuthorDBContext())
            {
                bookList = baContext._RetreiveBookDetails(ba.FirstName,ba.LastName,ba.Genre, ba.Title).ToList();              
            }
            return bookList;
        }

QuestionMapping Stored Proc To Entities In Entity Framework 5 Pin
MadDashCoder29-May-15 6:45
MadDashCoder29-May-15 6:45 
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 

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.