ADO.NET Accelerator

    1  DataSet customerDataset = DbManager.Instance.CreateDataSet(0, "DemoDb");

    1     OleDbConnection connection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='C:\Program Files\SqlNetFramework\SqlNetFramework 1.0\Demos\SqlNetFrameworkEvaluationCS\App_Data\DemoDb.mdb';");

    2     OleDbCommand command = new OleDbCommand("SELECT * FROM CUSTOMER ORDER BY CUSTOMERID", connection);

    3 

    4     connection.Open();

    5 

    6     OleDbDataAdapter adapter = new OleDbDataAdapter();

    7     adapter.SelectCommand = command;

    8     DataSet customerDataset = new DataSet();

    9     adapter.Fill(customerDataset);

   10 

   11     connection.Close();

    1     CiOrderedDictionary paramValues = new CiOrderedDictionary();

    2 

    3     paramValues.Add("FirstName", "Matt");

    4     paramValues.Add("CustomerId", 1);

    5 

    6     int affectedRecords = DbManager.Instance.ExecuteNonQuery(3, "DemoDb", paramValues);

    1     OleDbConnection connection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='C:\Program Files\SqlNetFramework\SqlNetFramework 1.0\Demos\SqlNetFrameworkEvaluationCS\App_Data\DemoDb.mdb';");

    2     OleDbCommand command = new OleDbCommand(@"UPDATE CUSTOMER SET FirstName = ? WHERE CustomerId = ?", connection);

    3 

    4     connection.Open();

    5 

    6     OleDbParameter firstNameParameter = new OleDbParameter("FirstName", "Matt");

    7     firstNameParameter.OleDbType = OleDbType.VarChar;

    8     command.Parameters.Add(firstNameParameter);

    9     OleDbParameter customerIdParameter = new OleDbParameter("CustomerId", 1);

   10     customerIdParameter.OleDbType = OleDbType.Integer;

   11     command.Parameters.Add(customerIdParameter);

   12 

   13     int affectedRecords = command.ExecuteNonQuery();

   14 

   15     connection.Close();       

    1     CiOrderedDictionary paramValues = new CiOrderedDictionary();

    2 

    3     paramValues.Add("CustomerId", 1);

    4 

    5     IDataReader ordersByCustomerReader = DbManager.Instance.ExecuteReader(1, "DemoDb", paramValues);

    1     OleDbConnection connection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='C:\Program Files\SqlNetFramework\SqlNetFramework 1.0\Demos\SqlNetFrameworkEvaluationCS\App_Data\DemoDb.mdb';");

    2     OleDbCommand command = new OleDbCommand(@"SELECT * FROM [ORDER] WHERE CustomerId = ?", connection);

    3 

    4     connection.Open();

    5 

    6     OleDbParameter customerIdParameter = new OleDbParameter("CustomerId", 1);

    7     customerIdParameter.OleDbType = OleDbType.Integer;

    8     command.Parameters.Add(customerIdParameter);

    9 

   10     IDataReader ordersByCustomerReader = command.ExecuteReader(CommandBehavior.CloseConnection);     

    1     int customerCount = (int)DbManager.Instance.ExecuteScalar(12, "DemoDb");       

    1     OleDbConnection connection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='C:\Program Files\SqlNetFramework\SqlNetFramework 1.0\Demos\SqlNetFrameworkEvaluationCS\App_Data\DemoDb.mdb';");

    2     OleDbCommand command = new OleDbCommand(@"SELECT COUNT(*) FROM CUSTOMER", connection);

    3 

    4     connection.Open();

    5 

    6     int customerCount = (int)command.ExecuteScalar();

    7 

    8     connection.Close();       

    1     IDbConnection connection = null;

    2     IDbTransaction transaction = null;

    3     DbManager.Instance.CreateTransaction("DemoDb", out connection, out transaction);

    4 

    5     try

    6     {

    7         CiOrderedDictionary paramValues = new CiOrderedDictionary();

    8         paramValues.Add("FirstName", "Tim");

    9         paramValues.Add("LastName", "Smith");

   10         DbManager.Instance.ExecuteNonQuery(4, "DemoDb", paramValues, connection, transaction);

   11 

   12         paramValues.Clear();

   13         paramValues.Add("FirstName", "Scott");

   14         paramValues.Add("LastName", "Dawson");

   15         DbManager.Instance.ExecuteNonQuery(4, "DemoDb", paramValues, connection, transaction);

   16 

   17         transaction.Commit();

   18     }

   19     catch

   20     {

   21         transaction.Rollback();

   22     }

   23     finally

   24     {

   25         connection.Close();

   26     }

    1     OleDbConnection connection = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE='C:\Program Files\SqlNetFramework\SqlNetFramework 1.0\Demos\SqlNetFrameworkEvaluationCS\App_Data\DemoDb.mdb';");

    2     OleDbCommand command = new OleDbCommand(@"INSERT INTO Customer (FirstName, LastName) VALUES (?, ?)", connection);

    3 

    4     OleDbParameter firstNameParameter = new OleDbParameter("FirstName", OleDbType.VarChar);

    5     command.Parameters.Add(firstNameParameter);

    6     OleDbParameter customerLastNameParameter = new OleDbParameter("LastName", OleDbType.VarChar);

    7     command.Parameters.Add(customerLastNameParameter);

    8 

    9     connection.Open();

   10     command.Transaction = connection.BeginTransaction();

   11 

   12     try

   13     {

   14         command.Parameters[0].Value = "Tim";

   15         command.Parameters[1].Value = "Smith";

   16         command.ExecuteNonQuery();

   17 

   18         command.Parameters[0].Value = "Scott";

   19         command.Parameters[1].Value = "Dawson";

   20         command.ExecuteNonQuery();

   21 

   22         command.Transaction.Commit();

   23     }

   24     catch

   25     {

   26         command.Transaction.Rollback();

   27     }

   28     finally

   29     {

   30         connection.Close();

   31     }

    1     CiOrderedDictionary paramValues = new CiOrderedDictionary();

    2 

    3     paramValues.Add("Guid", DBNull.Value);

    4     DbManager.Instance.ExecuteNonQuery(13, "DemoDb", paramValues);       

    5     string guidValue = paramValues["Guid"].ToString();

    1     SqlConnection connection = new SqlConnection(@"Data Source='MyServer';Integrated Security=SSPI;Initial catalog=SqlNetFmkDemoDb");

    2 

    3     SqlCommand command = new SqlCommand(@"CreateGuid", connection);

    4     command.CommandType = CommandType.StoredProcedure;

    5 

    6     SqlParameter guidParameter = new SqlParameter("Guid", DBNull.Value);

    7     guidParameter.SqlDbType = SqlDbType.UniqueIdentifier;

    8     guidParameter.Direction = ParameterDirection.Output;

    9     command.Parameters.Add(guidParameter);

   10 

   11     connection.Open();

   12     command.ExecuteNonQuery();

   13     connection.Close();

   14 

   15     string guidValue = command.Parameters["Guid"].ToString();