Pulling Dynamic table name using linq

Question

I have a scenario where I have a class that can be pulling data from many tables. The table select depends on the user interface. I am using LINQ but don't know how to dynamically select a table and its columns in a LINQ code. What if I want to have another join in my LINQ expression pulling data from a different table. Please help new to LINQ.

 

thanks

Saritha

---

saritha k

Answer 1

dynamically select my Table at runtime with Dynamic LINQ

http://stackoverflow.com/questions/5032228/how-can-i-dynamically-select-my-table-at-runtime-with-dynamic-linq

Please check above link to use dynamic table in Linq

Answer 2

Hi,

I think Entity SQL is best option for dynamic query. you can create command object and using the EntityCommandReader you can read the data.

EntityCommand cmd = conn.CreateCommand();

cmd.CommandText = @" SELECT VALUE p 

FROM AdventureWorksEntities.Product AS p

ORDER BY p.ListPrice ";

<p>DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);

while (rdr.Read()) { }

Hope, this will help you out. Feel free to contact in case of query.

---

If this post answers your question, please click Mark As Answer. If this post is helpful please click Mark as Helpful.

Answer 3

Hello,

Check out the links below. It may help you.

http://stackoverflow.com/questions/5032228/how-can-i-dynamically-select-my-table-at-runtime-with-dynamic-linq

http://stackoverflow.com/questions/953911/dynamic-linq-setting-orderby-expression-type-at-runtime

http://stackoverflow.com/questions/3673603/dynamic-table-name-linq-to-sql-dynamic-linq

http://tomasp.net/blog/dynamic-linq-queries.aspx

Answer 4

http://boardreader.com/thread/Pulling_Dynamic_table_name_using_linq_5q8s8__4b8747b7-bc42-4330-9759-64438de8d72f.html

http://forums.silverlight.net/t/170619.aspx

http://stackoverflow.com/questions/5032228/how-can-i-dynamically-select-my-table-at-runtime-with-dynamic-linq