salesforce-dapper

A sample library to CRUD Salesforce data. Using Salesforce REST API.

Setup

import this project

Initial

static void Main(string[] args)
{
    var tokenUrl = "https://test.salesforce.com/services/oauth2/token";
    var clientId = "{YOUR CLIENT ID}";
    var clientScrect = "{YOUR CLIENT SCRECT}";
    var username = "{YOUR USERNAME}";
    var password = "{YOUR PASSWROD}";
    //login sfdc
    var dapper = new SforceDapper.SforceDapper(tokenUrl, clientId, clientScrect, username, password);
    
}

Query

class Account {
	public string Id { get; set; }
	public string Name { get; set; }
}

class Program
    {
        static void Main(string[] args)
        {
			... Initial
            //query sfdc data
            string soql = "select Id, Name from Account limit 10";
            List<Account> accounts = dapper.Query<Account>(soql).records.ToList();
        }
    }
}

Create

var newAccount = new { Name = "test account" };
var result = dapper.Create("Account", newAccount);

Update

var updateAccount = new { Name = "updated account name" };
var result = dapper.Update("{ ACCOUNT ID }", "Account", updateAccount);

Delete

var result = dapper.Delete("{ ACCOUNT ID }", "Account");