LINQ Select specific columns

Question

Hello, I am new to LINQ.  I have a question.  I have a SQL table with columns named A_1, B_1, C_1, A_2, B_2, C_2, A_3, B_3, C_3.  I would like to write a linq query in C# to get data out of the specific columns based on parameter (in this case it is "1", "2" or "3").  For example, if input parameter is 1, it will get data from A_1, B_1, C_1; if input parameter is 3, it will get data from A_3, B_3, C_3.  How can I do it? 
Thanks a lot.
Nick

Answer 1

With dynamic LINQ to SQL you could have a Select call where you pass a string in that you construct at run-time, see http://weblogs.asp.net/rajbk/archive/2007/09/18/dynamic-string-based-queries-in-linq.aspx :
string param = "1";
var query = dataContext.TableName.Select(string.Format("new(A_{0},B_{0},C_{0})", param))

---

MVP XML My blog

Answer 2

This is exactly what I was looking for.  Thank you so much, Martin.