tags:

views:

32

answers:

1
Q: 

linq to sql or Entity framework when you are most of the time going to call database using stored procedure?

I'm working on a project where most of the times I'm going to call database with a stored procedure and I'm a little bit confused what should I do. Options are not just restricted to Sql to Linq and EF. If there are any better options please suggest them too.

UPDATE - Reason for using SPs
I've to apply logic in many of the stored procedure. Apart from this, my intention to use SPs for CRUD operation is to improve performance.

Thanks in advance.

+1  A: 

ORM tools wasn't designed to be used only with stored procedures (but they could), it will be very difficult to map data on eneities and perform all operations using EF. You can relay on this guide, but I need some details to suggest something more meaningfull.

Restuta  2010-06-24 07:15:36
What kind of more details you need?
Ismail  2010-06-24 07:40:19
Your typical operations to perform with SP, CRUD or all? Do you have any option do not use SP's or you just forced to perform all operations this way?
Restuta  2010-06-24 09:09:17
I've to apply logic in many of the stored procedure. Apart of this my intention to use SPs for CRUD operation is to improve performance.
Ismail  2010-06-28 05:03:35

related questions

What is the syntax for an inner join in linq to sql?
Best Practices for Managing Linq to SQL Dbml Files?
Best use pattern for a DataContext
Is there a pattern using Linq to dynamically create a filter?
Can you use LINQ tools such as SQLMetal with an access database?
How to Track Queries on a Linq-to-sql DataContext
Linq To SQL: Can I eager load only one field in a joined table?
What causes Visual Studio to fail to load an assembly incorrectly?
NHibernate vs LINQ to SQL
Linq 2 SQL on shared host
Attaching entities to data contexts
XRef Relationships in dbml
Linq to SQL - Underlying Column Length
Learning about LINQ
LINQ to SQL Mapping From Money to Double
LINQ-to-SQL vs stored procedures?
Has anyone had any success in unit testing SQL stored procedures?
Best .NET Solution for Frequently Changed Database
Conditional Linq Queries
Entity Framework vs LINQ to SQL
When should I use Compiled LINQ vs Normal LINQ
LINQ to SQL strings to enums
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
Are Multiple DataContext classes ever appropriate?