Re: [Firebird-net-provider] an item with the same key has already been added

[Douglas T. <dou...@gm...>]

On Tue, Jun 30, 2009 at 8:08 PM,
pab...@te...<pab...@te...> wrote:
> any updates about this. Do you need me to submit a test case?

I can confirm this is a bug in the provider.

On FbDataReader.cs, line ~377:
for (int i = 0; i < this.fields.Count; i++)
{
  columnsIndexes.Add(this.fields[i].Alias.ToUpper(), i);
}

The error shows up when trying to run a sql like:
select table1.field, table2.field

On such cases fields[i].Alias is "field" for both items. This causes
the dictionary columnsIndexes to throw the "duplicate key" error.

Maybe a solution is to concatenate Alias and Relation?
columnsIndexes.Add(this.fields[i].Relation.ToUpper()
+"."+this.fields[i].Alias.ToUpper(), i);

As a side note, ToUpper() can be removed if columnsIndexes is
instantiated using StringComparer.CurrentCultureIgnoreCase.

hth,
-- 
Douglas Tosi
www.sinatica.com