How to pass table name dynamically in linq to sql

Question

I need your help to resolve this issue.

How to pass table name dynamically in linq to sql in C#.net?

public IntPol(DataClasses1DataContext DC, decimal value,string tableName)
{
}

tableName will change dynamically.

Look for stackoverflow.com/questions/tagged/dynamic-linq; but I am not sure you can change the table dynamic — Pleun
– Pleun, Commented Dec 8, 2014 at 14:44
You could check out this post for some options: stackoverflow.com/questions/14200778/… — EGP
– EGP, Commented Dec 8, 2014 at 16:06

Randy Minder · Accepted Answer · 2014-12-08 12:43:01Z

0

I don't believe this is going to be possible. At least not using traditional Ling-To-SQL. You could use the L2S Connection object, hard code a T-SQL statement, and pass that to SQL Server. But, in this case, you aren't really using L2S anymore.

answered Dec 8, 2014 at 12:43

Randy Minder

48.8k56 gold badges222 silver badges373 bronze badges

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

Comments

ihor.eth · Accepted Answer · 2017-10-25 18:17:13Z

0

If I understand the question correctly then you could do something like

public IntPol(DataClasses1DataContext DC, decimal value,string tableName)
{
  DC = new DataClasses1DataContext("yourConnString");
  var result = DC.Mapping.GetTables().SingleOrDefault(t => t.TableName.ToString() == tableName);
}

Or you could also do tableObject.GetType().Name but if type is dynamic might have to send Type tableType separately.

edited Oct 25, 2017 at 18:17

answered Oct 25, 2017 at 18:06

ihor.eth

2,4321 gold badge24 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to pass table name dynamically in linq to sql

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related