private static UserId ContribInsertData() { var id = new UserId("Abc12c"); using (var connection = new System.Data.SQLite.SQLiteConnection(cnStr)) { connection.Open(); connection.Insert(new Poco.Users() { Age = 31, Id = id, Name = "Peter Gill" }); } return id; }
public static void WriteYoutubeCookies(IEnumerable <Models.cookies> cookies, string host_key, string srcCookieFilePath, string destCookieFilePath) { var yc = GetYoutubeCookies(destCookieFilePath, host_key); DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.SqliteDialect(); DapperExtensions.DapperExtensions.DefaultMapper = typeof(cookiesClassMapper <>); using (var cn = new System.Data.SQLite.SQLiteConnection("Data Source=" + destCookieFilePath)) { cn.Open(); yc.ToList().ForEach(c => { cn.Delete(c); }); cookies.ToList().ForEach(c => { cn.Insert(c); }); } }