SQL object mapper - delete a record from table

How to delete records from Person table

This sample codes will show how easy using SQL objects.

string connectionString = "...";

// define Person object.
Person person = new Person();

// using SQL-object to delete Person table
SqlDeleteFrom delete = new SqlDeleteFrom(person);
// set connection string
delete.ConnectionString = connectionString;

// set Where conditional to delete a record with PersonId = 3
delete.Where.Compare(person.PersonId, CompareOperator.Equal, 3);

// execute delete Person table
int r = delete.Execute();


For more information click here.