public static void InsertEntityBySP <T>(string email) where T : class { using (var db = new ewkDB()) { db.ExecuteProc("insert_account", DataParameter.VarChar("email", email)); } }
public void InsertAccountBySP([Values(ProviderName.PostgreSQL)] string configString) { int id_count = 0; string template_email = "test_{0}[email protected]"; using (var db = new ewkDB(configString)) { for (int i = id_count; i < 200000; ++i) { db.ExecuteProc("insert_account", DataParameter.VarChar("email", string.Format(template_email, i))); } } }
void TestLinqToDbWithAccount() { using (var db = new ewkDB()) { //var id = db.InsertWithIdentity<Account>(new Account() { EMail = "*****@*****.**", FirstSignedDate = DateTime.Now }); //Console.WriteLine("id = {0}", id); db.ExecuteProc("test_insert", DataParameter.VarChar("email", "*****@*****.**")); List <account> list;// = TestLinq2Db.All(); var query = from p in db.accounts //where p.ProductID > 25 select p; list = query.ToList(); foreach (account p in list) { Console.WriteLine(p.email); } } }