Click here to Skip to main content
15,917,005 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionA bit lost here... Pin
Kornfeld Eliyahu Peter2-Jun-15 1:22
professionalKornfeld Eliyahu Peter2-Jun-15 1:22 
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 
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 

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.