Re: [Firebird-net-provider] [Firebid-net-provider] TableMappings

[Carlos G. A. <car...@te...>]

Hello:

> After this I get in result table with 4 columns coUcet,UCET,coPopis,POPIS.
> Is it a bug or I do something wrong?

I have reviewed the documentation of DataAapter,TableMappings and seems 
to be used on table updating only, i will try to review it more later today.

> And one question moore.
> How I can make Command for make more than one datatable?
> Like
> FillTbl.CommandText="SELECT UCET ,POPIS FROM LUCTY; SELECT ABC ,DEF FROM
> LTABLE";

If you are using 1.5 version you will need CVS sources, i have committed 
a fix today for NextResult method.

I have made a little test using this ( i will try to add a nunit test 
case today too ):

string sql = "select * from AREAS; select * from PROJECTS";
FbCommand	command = new FbCommand(sql, connection, transaction);
FbDataAdapter	adapter	= new FbDataAdapter(command);
			
DataSet ds = new DataSet();
			
adapter.Fill(ds);

Console.WriteLine(ds.Tables[0].Rows.Count);
Console.WriteLine(ds.Tables[1].Rows.Count);






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain