CRUD using AseDataAdapter for SyBase

1. Copy the code from Good practice of CRUD by creating SqlDataAdapter when you cannot use Entity Framework episode 1.

 

2. Add reference to SyBase.Data.AseClient.

 

3. Rename SqlDataAdapter to AseDataAdapter.

 

4. Rename SqlCommand to AseCommand.

 

5. Rename SqlConnection to AseConnection.

 

6. Rename SqlDbType to AseDbType.

 

7. Rename AseParameter to AseParameter.

 

The code will end like below.

 

public static AseDataAdapter CreateCustomerAdapter(AseConnection connection)

{

  AseDataAdapter adapter = new AseDataAdapter();

 

  // Create the SelectCommand.

  AseCommand command = new AseCommand(“SELECT * FROM Customers” +

      “WHERE Country = @Country AND City = @City”, connection);

 

  // Add the parameters for the SelectCommand.

  command.Parameters.Add(“@Country”, AseDbType.NVarChar, 15);

  command.Parameters.Add(“@City”, AseDbType.NVarChar, 15);

 

  adapter.SelectCommand = command;

 

  // Create the InsertCommand.

  command = new AseCommand(

    “INSERT INTO Customers (CustomerID, CompanyName) “ +

    “VALUES (@CustomerID, @CompanyName)”, connection);

 

  // Add the parameters for the InsertCommand.

  command.Parameters.Add(“@CustomerID”, AseDbType.NChar, 5, “CustomerID”);

  command.Parameters.Add(“@CompanyName”, AseDbType.NVarChar, 40, “CompanyName”);

 

  adapter.InsertCommand = command;

 

  // Create the UpdateCommand.

  command = new AseCommand(

    “UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName “ +

    “WHERE CustomerID = @oldCustomerID”, connection);

 

  // Add the parameters for the UpdateCommand.

  command.Parameters.Add(“@CustomerID”, AseDbType.NChar, 5, “CustomerID”);

  command.Parameters.Add(“@CompanyName”, AseDbType.NVarChar, 40, “CompanyName”);

  AseParameter parameter = command.Parameters.Add(

    “@oldCustomerID”, AseDbType.NChar, 5, “CustomerID”);

 

  parameter.SourceVersion = DataRowVersion.Original;

  adapter.UpdateCommand = command;

 

  // Create the DeleteCommand.

  command = new AseCommand(

    “DELETE FROM Customers WHERE CustomerID = @CustomerID”, connection);

   

  // Add the parameters for the DeleteCommand.

  parameter = command.Parameters.Add(

    “@CustomerID”, AseDbType.NChar, 5, “CustomerID”);

  parameter.SourceVersion = DataRowVersion.Original;

 

  adapter.DeleteCommand = command;

 

  return adapter;

}