[Firebird-net-provider] more commands

[Pavol S. <pa...@st...>]

can i use 2 fbCommands with one fbConnection and one fbTransaction
or
have i create separate connection or transaction for each fbCommand???

this example throws exception:
FbConnection dbConn = new FbConnection(fConnString);
try {
	dbConn.Open();
			
	FbTransaction dbTran = dbConn.BeginTransaction();
	if (fID < 0) {
		string genQuery = "SELECT GEN_ID(GENARTICLEID, 1) FROM RDB$DATABASE";
		FbCommand dbCmd2 = new FbCommand(genQuery, dbConn, dbTran);
		dbCmd2.ExecuteScalar();
	}
	FbCommand dbCmd = new FbCommand(query, dbConn, dbTran);
		
	dbCmd.Prepare();
	dbCmd.Parameters.Add("xID", fID);
	dbCmd.ExecuteNonQuery();
	dbTran.Commit();
}
finally {
	dbConn.Close();
}







and exception is:
Unhandled Exception: System.InvalidOperationException: Command 
Connection is not
  equal to Transaction Connection.
    at FirebirdSql.Data.Firebird.FbCommand.Prepare()
    at NovyCas.DBArticle.SaveArticle() in 
C:\Projekty\NetStarek\NovyCas\DBArticle
.cs:line 221
    at Tests.TestDBArticleCreateSaveGet() in 
C:\Projekty\NetStarek\Tests\Main.cs:
line 42
    at Tests.Main(String[] args) in 
C:\Projekty\NetStarek\Tests\Main.cs:line 61
Press any key to continue . . .