CODEWITHSUNDEEP
c#sqllinq
itwb
itwb

Reputation: 437

web interface form for querying database using linq

I've got a database with a stack load of data in it. I'd like to make a web interface which will allow the user to put in an LINQ query, which will return results in a table.

How do I limit it to allow selection only? (I'm thinking the best way is to create another database user with select permissions only)

Anything else I should be aware of, or any other ideas?

Upvotes: 0

Views: 331

Answers (1)

Nix
Nix

Reputation: 58522

Are you just trying to expose your database as a webservice? I would strongly reccomend WCF Data Services.

This basically allows for people to query your data using a rest interface. There is also a client side linq api, that converts link statements to rest. There is plenty of build in security that can facilitate allowing people to only query your data, and not change it.

Upvotes: 1

Related Questions