//Setup the provider
MsAccessProvider provider = new MsAccessProvider();
provider.ConnectionString = "Enter your connection string";
//Manually instantiate a session
DataHelper db = new DataHelper(provider);
//Create the database if it does not exist (uses the database specified in the connection string)
//Create tables if they do not exist for a namespace
//Add columns that do not exist for corresponding classes
db.Setup("AcmeInc.Business.Entities");
//Save a record
Customer customer = new Customer();
customer.Name = "John Smith";
db.Save(customer);
//Load By Primary Key
Customer customer = db.LoadByPrimaryKey<Customer>(1);
//Loading with Parents and Children
Customer customer = db.LoadWithChildren<Customer>(1);
//Loading with a LINQ expression
Customer customer = db.CreateQuery<Customer>().FirstOrDefault(o => o.CustomerId == 1);
List<Customer> customerList = db.CreateQuery<Customer>().Where(o => o.Name == "John Smith").ToList();