Last post Mar 05, 2015 10:45 PM by Edwin Guru Singh
Mar 04, 2015 05:25 PM|jbassett|LINK
Can anyone help me here?
What: I have been building .NET applications that access SQL server since .NET came out, and Classic ASP before that. I have always created SP's On the MSSQL server, then connected either manually or using LINQ from my .NET application to the SP's to do
work (get, put, etc).
Question: I see now we have the option of directly programming TSQL in .NET like in this example:
....Which would be Much faster than having to write an SP, then giving it permission for every thing I want to do.
MAIN QUESTION: Am I loosing any security OR performance if I switched to this method? Please help me with this question of the ages I have been sitting on the fence over for years. Thank you.
Mar 04, 2015 07:33 PM|oned_gk|LINK
AFAIK, no security problem, more efisien and better performance
See below article
Mar 05, 2015 10:36 AM|jbassett|LINK
Ok thanks for answering. I'll mark it as the answer.
Let's say you are the most knowledgeable in the world...
I still would like a bunch of people from everywhere to comment on this just to get a sampling, if possible.
Mar 05, 2015 10:45 PM|Edwin Guru Singh|LINK
Which would be Much faster than having to write an SP, then giving it permission for every thing I want to do.
MAIN QUESTION: Am I loosing any security OR performance if I switched to this method?
Click here to know more about the Table-Valued Parameters in ADO.Net
Click here to know more about the MergeStatement in SQLserver.