ComponentOne DataServices Edition
ADO.NET provider for Salesforce / Querying Data
In This Topic
Querying Data
In This Topic

The ADO.NET Provider for Salesforce implements two classes you can use to perform CRUD (Create, Read, Update, and Delete) operations: DbDataReader and C1SalesforceDataAdapter classes. The tabs below describe the classes and code implementations.

Querying With DbDataReader

The DbDataReader class can be used to fetch data in subset increments as required. It can retrieve data quicker than the C1SalesforceDataAdapter as it retrieves data in pages. When you read data from the DbDataReader, it requests the succeeding page from the data source to load the result, which makes the data retrieval faster.

The following code examples demonstrate create, read, update, and delete operations from the data source using the DbDataReader.

 

Create Data

The example adds new records by executing the Insert command.

C#
Copy Code 
static void InsertDataReader()
{
    Console.WriteLine("Insert operation started !!!");
    using (C1SalesforceConnection conn = new C1SalesforceConnection(GCSalesforceServerConnectionString))
    {
        conn.Open();
        string insertSql = @"Insert into [Order] (AccountId, Status, BillingState,BillingStreet,BillingCity,BillingPostalCode,BillingCountry,EffectiveDate) 
                        Values ('0012w00000Ak4iLAAR', 'Draft','Delhi','Delhi','NCR','110009','India','23-JAN-1992')";

        //Create Insert command;
        C1SalesforceCommand command = new C1SalesforceCommand(conn, insertSql);

        // Execute Insert command
        int i = command.ExecuteNonQuery();
        if (i != -1)
        {
            Console.WriteLine("Insert operation successful !!! \n \n");
        }
    }
}

Read Data

This example retrieves data by executing the Select command.

C#
Copy Code 
static void ReadDataReader()
{
    Console.WriteLine("Read operation started !!!");
    using (C1SalesforceConnection con = new C1SalesforceConnection(GCSalesforceServerConnectionString))
    {
        con.Open();

        //Create Read command
        var cmd = con.CreateCommand();
        cmd.CommandText = "Select  *  FROM [Order] limit 10 ";

        //Execute Read command and display fetched data
        var rdr = cmd.ExecuteReader();
        while (rdr.Read())
        {
            Console.WriteLine(String.Format("\t{0} --> \t\t{1} --> \t\t{2}", rdr["Id"], rdr["AccountId"], rdr["BillingCity"]));
        }
        Console.WriteLine("Read operation successful !!! \n \n");
    }
}

Update Data

This example modifies data by executing the Update command.

C#
Copy Code 
static void UpdateDataReader()
{
    Console.WriteLine("Update operation started !!!");
    using (C1SalesforceConnection conn = new C1SalesforceConnection(GCSalesforceServerConnectionString))
    {
        conn.Open();

        //Create Update command
        C1SalesforceCommand command = new C1SalesforceCommand(conn, "UPDATE [Order] SET BillingCity=@BillingCity where AccountId=@AccountId");
        command.Parameters.AddWithValue("@AccountId", "0012w00000Ak4iLAAR");
        command.Parameters.AddWithValue("@BillingCity", "Delhi");

        //Execute Update command
        int i = command.ExecuteNonQuery();
        if (i != -1)
        {
            Console.WriteLine("Update operation successful !!! \n \n");
        }
    }
}

Delete Data

This example removes data by executing the Delete command.

C#
Copy Code 
static void DeleteDataReader()
{
    Console.WriteLine("Delete operation started!!!");
    using (C1SalesforceConnection conn = new C1SalesforceConnection(GCSalesforceServerConnectionString))
    {
        conn.Open();

        //Create Delete command
        C1SalesforceCommand command = new C1SalesforceCommand(conn, "Delete from [Order] where AccountId = @AccountId ");
        command.Parameters.AddWithValue("@AccountId", "0012w00000Ak4iLAAR");

        //Execute Delete command
        int i = command.ExecuteNonQuery();
        if (i != -1)
        {
            Console.WriteLine("Delete operation successful !!! \n \n");
        }
    }
}