How Do I: LINQ to SQL: Using Stored Procedures

Hi,

Couple questions:

It seems like you can make powerful queries without using stored procedures, at what point do you decided to use stored procedures?

Does using LINQ break the MVC model? It seems like you are mixing parts of the controller with the model.

Thanks

I use stored procedures mainly because we have them created already. I would imagine only using stored procedures if they are available and are at your disposal. Why reinvent the wheel when they are already there for you.

Myself on the otherhand, likes to reinvent the wheels.

thanks....

The major reason for using stored procedures is that they execute quicker that the equivalent in-line query. This is because SQL Server has the opportunity to work out the best execution plan ahead of the time when the stored procedure will be called by the application.

Many thanks for the great videos

Great video! Thank you!

Thanks! Jërëjëf!

hi,

6:45 : The return values is a collection of Produt objects...

so instead of using

foreach(var p in q) which works anyway

you can use

foreach(product p in q)...  

thanx for the videos and source codes, nice place to start from!