CODEWITHSUNDEEP
c#linqgenerics
JoaxAzevedo
JoaxAzevedo

Reputation: 123

LINQ query with a generic table

I'm tryng to have only one select in my method. That method will select a table based in a defined string and execute a select.

private static void Load()
{
    DataClassesDataContext contexto = new DataClassesDataContext();
    IQueryable newTable = null;

    string tabela = "A";

    switch (tabela)
    {

        case "A":
            newTable = contexto.GetTable<Table2>();
            break;
        case "B":
            newTable = contexto.GetTable<Table1>();
            break;
        default:
            break;
    }

    var genericQuery = from a in newTable
                       select a;
}

What can I do to have genericQuery with the right table values?

Upvotes: 0

Views: 1146

Answers (1)

Judah Gabriel Himango
Judah Gabriel Himango

Reputation: 60001

This won't work unless you genericize the Load method:

private static void Load<T>()
{
   ...
   var genericQuery = contexto.GetTable<T>();
   ...
}

Upvotes: 1

Related Questions