All Questions
11 questions
0
votes
1
answer
61
views
Web API 2 method developed using ADO.NET is not performing well, takes 53 seconds
I am creating API for Android app using Asp.Net Web API2. There is a method which fetches members data from the table. I am sorting and listing members based on arrangements(int) and name(string). The ...
- 99
0
votes
2
answers
785
views
Migrating stored procedure from LINQ to SQL to Entity Framework 6
I have migrated the my project from Linq-to-SQL to Entity Framework 6. After resolving so many problems, I finally came to one I am not sure what to do with it. After conversion about one third of my ...
- 25.2k
0
votes
1
answer
1k
views
Stored procedures and functions is not updating for Entity Model
I work with database first Entity Framework & LINQ in Visual Studio 2013.
When i write stored procedures and change them, i used to update Entity Data Model from database by choosing stored ...
- 401
0
votes
1
answer
1k
views
Master-detail foreign key insert
Have two tables.
Customer Contact
_______________________________________
CustomerId *--> CustomerId
CustomerName ContactId
... ContactFirstName
...
- 151
3
votes
6
answers
2k
views
Is it a good approach to query the database only through stored procedures?
When I am developing an ASP.NET website I do really like to use Entity Framework with both database-first or code-first models (+ asp.net mvc controllers scaffolding).
For an application requiring to ...
- 171
0
votes
1
answer
673
views
Using LINQ queries vs Stored Procedures [duplicate]
In our new project we are hoping to use entity framework 4.0. I would like to know what would be the best method from below options for accessing the database when using entity framework. development ...
- 12.7k
1
vote
1
answer
240
views
Bug or feature: stored procedure that returns multiple rows with same primary key value
During developing an application with LINQ to SQL, I found that when a stored procedure returns multiple distinct rows with same primary key then LINQ will make the complete list object same. For ...
0
votes
2
answers
660
views
Benefits of using .NET ORM tools like Entity Framework, LinqToSql over stored procedure
I would like to know the benefits of using .NET ORM tools like Entity Framework, LinqToSql over stored procedure approach for scalable website.
- 133
1
vote
3
answers
315
views
ASP.NET 3.5 with Entity Framework already in use. Best way to call a sproc?
I have a small application that uses Entity Framework to expose information to an oData service. I need to allow my web server to call a SQL sproc for auditing purposes.
What technology should I use ...
- 61.5k
4
votes
2
answers
5k
views
Entity Framework & Stored Procedures
I noticed in the Entity Framework designer that you can map stored procedures for Insert, Update, and Delete operations. Is there any way to do this for Select operations as well, or is there a new ...
- 33.1k
17
votes
3
answers
27k
views
Linq To Sql vs Entity Framework Performance
I have been searching for recent performance benchmarks that compare L2S and EF and couldnt find any that tested calling stored procedures using the released version of EF. So, I ran some of my own ...
- 5,439