which group appropriate for LINQ questions?

[Duncan A. McRae]

I am trying to find a simple answer to, "if I use LINQ against tables,
must I give the webuser datareader/datawriter permissions in SQL
Server?". I see the question asked repeatedly, but instead of
answering that question the responders always seem to launch into
magnificent speaches about the speed and security of stored procedures
and parameterised queries and their mother's apple pie. I'm not
bitter, though.

If you can tell me which group would be best to post this question, I
would appreciate it. If you can answer my question, I would
appreciate that even more!

Thank you;
Duncan

 

[Jeroen Mostert]

I am trying to find a simple answer to, "if I use LINQ against tables,
must I give the webuser datareader/datawriter permissions in SQL
Server?".
Yes.

I see the question asked repeatedly, but instead of
answering that question the responders always seem to launch into
magnificent speaches about the speed and security of stored procedures
and parameterised queries and their mother's apple pie. I'm not
bitter, though.

It's actually pretty simple: LINQ generates ad-hoc queries. This reduces the
question to what you need to do to allow ad-hoc queries, which is a pure DB
question.

If you can tell me which group would be best to post this question, I
would appreciate it. If you can answer my question, I would
appreciate that even more!

Well, I hope that settles that, then.

 

[Duncan A. McRae]

Most appreciated!

 

[Ignacio Machin ( .NET/ C# MVP )]

I am trying to find a simple answer to, "if I use LINQ against tables,
must I give the webuser datareader/datawriter permissions in SQL
Server?". I see the question asked repeatedly, but instead of
answering that question the responders always seem to launch into
magnificent speaches about the speed and security of stored procedures
and parameterised queries and their mother's apple pie. I'm not
bitter, though.

If you can tell me which group would be best to post this question, I
would appreciate it. If you can answer my question, I would
appreciate that even more!

Thank you;
Duncan

In this group you most of the time get any question answered. even if
it's out of topic.
Inyuor case I think that it depends of how the app connect to the SQL
server and how the server is configured. If you use win. auth. so yes
the webuser ( OR the user used to run the app ) needs access to the
SQL server.