On Tue, Apr 6, 2010 at 2:32 PM, comicrage <[email protected]> wrote: > Hi, > > I am learning LINQ and was wondering the preference or difference > between calling LINQ default queries with C# versus LINQ calls to > stored procedures. Is there a big advantage of one over the other? > Also, security in terms of SQL Injections. ------------------
In my experience I take all the COMPLEX queries and create a view for each one. I then will use Linq against the view instead of the base tables. This is NECESSARY if your have a multi db centric design for your data storage where your view can see dbName.dbo.tableName but an entity object is only within a db. If you have the rights to run profiler you should SEE just what LINQ is doing. You will see that your params are safe. Last point is that the amount of overhead you have to do with SPs in the EF I do not use them. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell -- To unsubscribe, reply using "remove me" as the subject.
