Vladislav Panteleev wrote: > reader1 = getReader(select .. from mytable left join table1 on .. where .. > group by) > while (reader1.Read()) > { > //do somth > reader2 = getReader(select .. from mytable left join table2 on .. where .. > group by) > while (reader2.Read()) > { > //do somth > reader3 = getReader(select .. from mytable left join table3 on .. where > .. group by) > while (reader3.Read()) > { > //do somth > > //////The exception rises here > reader4 = getReader(select .. from mytable left join table4 on .. > where .. group by) > ////// > > while (reader4.Read()) > { > //do somth > } > } > } > } > > I've been triing to use view in select queries, result hadn't changed, I've > been run all of this queries in ibexpert and all of them passed.
Looks to me like you're getting a deadlock. This is not really specific to the .NET provider, but four nested queries like that seems like rather a lot. Can you not implement the four loops separately so that you don't need four simultaneous connections to the database? (which would especially kill you if you're running against firebird classic server!) Dean. ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider