public void ConnectionScope() { DagentDatabase db = new DagentDatabase("connectionStringName"); using (IConnectionScope scope = db.ConnectionScope()) { List <Customer> customers = db.Query <Customer>("Customers").List(); List <CustomerCategory> customerCategories = db.Query <CustomerCategory>("CustomerCategory").List(); } }
public void DagentTestForIterator() { IDagentDatabase database = new DagentDatabase("SQLite"); var customers = database.Query <Customer>("select * from customers").EnumerateList(); using (var scope = database.ConnectionScope()) { foreach (var customer in customers) { customer.CustomerPurchases = database.Query <CustomerPurchase>("select * from customerPurchases where customerId = @customerId", new { customerId = customer.customerId }).List(); } } ValidList(customers); }