linq tablename in variable
-
Hi i am making a function that should return id for a column(the column is unique) , so there would be one key per that column. i want to make a function and do some thing like this with linq. please provide help on how to do so void int GetPrimaryKey(string tablename,string columnName,columnvalue) { mydatacontext d=new mydatacontext(); id=//select key from tablename where columnName=columnvalue// } please provid help... thanx
haseeb
-
Hi i am making a function that should return id for a column(the column is unique) , so there would be one key per that column. i want to make a function and do some thing like this with linq. please provide help on how to do so void int GetPrimaryKey(string tablename,string columnName,columnvalue) { mydatacontext d=new mydatacontext(); id=//select key from tablename where columnName=columnvalue// } please provid help... thanx
haseeb
-
Hi i am making a function that should return id for a column(the column is unique) , so there would be one key per that column. i want to make a function and do some thing like this with linq. please provide help on how to do so void int GetPrimaryKey(string tablename,string columnName,columnvalue) { mydatacontext d=new mydatacontext(); id=//select key from tablename where columnName=columnvalue// } please provid help... thanx
haseeb
-
i would use lambda. like this! id = d.GetTable().Where(row => row.columnName=columnvalue).Select(row => row.ID);
Andreas Johansson
IT Professional at Office IT Partner i Norrbotten Sweden
What we don't know. We learn.
What you don't know. We teachHi , I'm looking for the same solution ; but i can't get it works. Please see my sample scenario below : public void RegularCustomers() { NorthwindDataContext db= new NorthwindDataContext(); string tableName = db.Customers; int age = 25; var LastNames = GetLastName ( tableName , age); } public string GetLastName(string tableName , int age) { NorthwindDataContext db= new NorthwindDataContext(); var names =( from client in db.GetTable(tableName) where client.age >= age select client.LastName ).ToList(); return names; } Please can you provide the solution for above scenario . Regards, Chary
chary
-
Hi , I'm looking for the same solution ; but i can't get it works. Please see my sample scenario below : public void RegularCustomers() { NorthwindDataContext db= new NorthwindDataContext(); string tableName = db.Customers; int age = 25; var LastNames = GetLastName ( tableName , age); } public string GetLastName(string tableName , int age) { NorthwindDataContext db= new NorthwindDataContext(); var names =( from client in db.GetTable(tableName) where client.age >= age select client.LastName ).ToList(); return names; } Please can you provide the solution for above scenario . Regards, Chary
chary
-
Hi! What is not working? What is the error message?
Andreas Johansson
IT Professional at Office IT Partner i Norrbotten Sweden
What we don't know. We learn.
What you don't know. We teachThe above is just a scenario ; what i need is a working code of using table name as variable using linq-sql. Thanks in advance.
-
The above is just a scenario ; what i need is a working code of using table name as variable using linq-sql. Thanks in advance.
-
Hi! Instead of using
string tableName, try usingType tableType.Andreas Johansson
IT Professional at Office IT Partner i Norrbotten Sweden
What we don't know. We learn.
What you don't know. We teachI still don't understand the answers. The question was very clear and simple. We have a SQL select statement in which the table name is variable. For example: "Select Foo From " + strTableName; Where strTableName is a variable holding the table name. now, can anyone give me the linq lingo of this simple statment? and please don't tell me to use TableType, I have no idea what's that got to do with the strTableName. And if you do say, use TableType, please use the same simple example to demonstrate how, given the vaiable strTableName, can we obtain the table type. Thanks,