| LINQ & Stored Procedures | LINQ / Entity Framework | C#.NET | C#.NET Discussion ForumC#.NET Discussion Forum

C#.NET LINQ / Entity Framework | LINQ & Stored Procedures

LINQ & Stored Procedures

Posted Date Unknown Charles Sunny 2 Comments

What is LINQ and how it is beneficial than Stored Procedures?

See All Responses Below...

Author

Message Rating

soniaarackal18

Posted on: 23/05/2012

Report Spam

Language Integrated Query(LINQ) is a native data querying platform.Using LINQ, the developer can query data in .NET supported languages. It provides a set of operators for querying any data source like collections of objects, database, XML

files etc.

From performance point of view, there may not be a great difference between LINQ and Stored procedures. If you need to execute a single statement query, it is better to use LINQ, as it reduces the coding effort.

abhilash.pathros

Posted on: 29/05/2012

Report Spam

The concept of LINQ offers a compact, expressive, and intelligible syntax for manipulatingdata. The real value of LINQ comes from its ability to apply the same query to an SQLdatabase, a DataSet, an array ofobjects in memory and to many other types of data as well. LINQ requires the presence of specificlanguage extensions.

LINQ is more advantage than stored procedures.

Debugging- Stored procedure hard to debug but as LINQ is part of .NET, so we can use visual studio's debugger to debug the queries.

Type Safety- LINQ is checked queries errors at compile time. It really good to programmer to encounter error when compiling rather than runt ime exception.

Deployment - With stored procedures, we need to provide an additional script for stored procedures but with LINQ everything gets complied into single DLL hence deployment becomes easy.

Share this page across other social networking sites

Please Login to Post Your Comments

Name (Max. 100 characters)

Select Language

Comments

Design

HTML

Attach File(Max. Size: 2 MB)

A few simple rules when posting your Comments,

Please post only answers relevant to the topic of discussion.
Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site.

Related Threads

Group by in LINQ