FbCommandBuilder does not create Insert/Delete/Update Commands
--------------------------------------------------------------

                 Key: DNET-105
                 URL: http://tracker.firebirdsql.org/browse/DNET-105
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 2.5.0
         Environment: Windows 32-bit & 64-bit
Firebird SS 2.0.1

            Reporter: Eduardo Gamboa
            Assignee: Carlos Guzman Alvarez


static void Main(string[] args)
{
           FbConnectionStringBuilder fbCsb = new FbConnectionStringBuilder();
            fbCsb.Dialect = 3;
            fbCsb.Charset = "NONE";
            fbCsb.UserID = "SYSDBA";
            fbCsb.Password = "masterkey";
            fbCsb.Database = "EMPLOYEE.FDB";
            FbConnection fbConn = new FbConnection(fbCsb.ConnectionString);
        try
        {
                fbConn.Open();
                DataSet ds = new DataSet();
                FbDataAdapter fbDA = new FbDataAdapter("SELECT * FROM 
CUSTOMER", fbConn);
                FbCommandBuilder fbCb = new FbCommandBuilder(fbDA);
                fbDA.Fill(ds, "CUSTOMER");
//The next three lines will throw Exceptions
                Console.WriteLine(fbDA.InsertCommand.CommandText);
                Console.WriteLine(fbDA.DeleteCommand.CommandText);
                Console.WriteLine(fbDA.UpdateCommand.CommandText);
                fbConn.Close();
        }
        catch (Exception err)
        {
                Console.WriteLine(err.Message);
                Console.ReadKey();
        }
}

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to