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);
}
}
}
