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