I got many different SQL tables with the same design - all have identity and two string fields with the same names. I do not want to write a set of functions to get values from these tables, i want to have one procedure with the table as a parameter. But when i start to retrieve data it says "can not convert type bla-bla-bla". It needs the type to be directly passed and thats what i want to avoid. What to do?
/*
defined tables:
create table tableA
(
id int identity not null,
type_code nvarchar(50) not null,
type_description nvarchar(1000) not null
)
same SQL for tableB and tableC
tableA, tableB, tableC
*/
void getAnyId( Table tbl, string codeFilter)
{
var p=(tableA)tbl; // HERE I GET EXCEPTION !!!
var id = p.Where( r=> r.code == codeFilter);
if( id.Count() != 1 )
return null;
return id.id;
}
Another example:
public Dictionary<string,string> readDataSchemeTypes( tvbaseDataContext dc )
{
Dictionary<string,string> ds = new Dictionary<string,string>();
foreach( var ast in dc.tableA)
ds.Add( ast.type_code, ast.type_description );
return ds;
}
This works but i need a set of functions, one per each table.
public Dictionary<string, string> readAnySchemeTypes<T>(System.Data.Linq.Table<T> table) where T:System.Data.Linq.ITable
{
Dictionary<string, string> ds = new Dictionary<string, string>();
foreach (var ast in table)
ds.Add(ast.type_code, ast.type_description); // type_code and type_description are not defined for type T
return ds;
}
This example doesn't compile.