web interface form for querying database using linq

Question

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?

Are you asking how to make it read only?

Nix
– Nix

2011-06-30 02:15:29 +00:00
Commented Jun 30, 2011 at 2:15 — Nix
– Nix, Commented Jun 30, 2011 at 2:15

Nix · Accepted Answer · 2011-06-30 02:16:08Z

1

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.

answered Jun 30, 2011 at 2:16

Nix

58.8k31 gold badges154 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

itwb Over a year ago

I guess my question is more about dynamically compiling queries that a user types into a webpage. WCF Data services is cool, but I want the user to be able to custom query the database.

Nix Over a year ago

They can custom query the database? The client data service API can do about 75% of what LINQ to Entities can do.

Collectives™ on Stack Overflow

web interface form for querying database using linq

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related