How do I Query Dynamically

Question

How can I query on a table given as parameter? I just want to check if a record exists. Example: String query = 'Select * from ' + tableName + 't where t.ID='' + fieldvalue + '''; Regards

Gohil Jayendrasinh · Answer

Hi http://www.hanselman.com/blog/TheWeeklySourceCode48DynamicQueryableMakesCustomLINQExpressionsEasier.aspx

Ajay Patel · Answer

String query = "Select * from " + tableName + "t where t.ID='" + fieldvalue + "'"; IEnumerable Customer > results = db.ExecuteQuery Customer >( query ); Class is your entity Class for returned result store

Glenn Sanchez · Answer

Hi Senthilkumar, Sorry for not being clear here. My exact concern is how/what type of class should I use for casting result for dynamic query with LINQ. This is what I mean: String query = "Select * from " + tableName + "t (nolock) where t.ID='" + fieldvalue + "'"; var res = context.ExecuteQuery ClassName >(query).ToList(); What should I use as class.

Senthilkumar · Answer

Hi, You can query like this. Are you going to use the table is not constant? then string query = "SELECT * FROM " + tableName + " where ID='" + fieldvalue + "'"; You know the table name string query = "SELECT * FROM tableName WHERE ID='" + fieldvalue + "'"; If your id column is integer column then string query = "SELECT * FROM " + tableName + " WHERE ID=" + fieldvalue;

How do I Query Dynamically

Answers (4)