static void Insert(System.Data.OleDb.OleDbConnection cn, System.Data.IDbTransaction tr = null)
{
var sql = @"INSERT INTO Item(ItemName) VALUES(@ItemName)";
var count = cn.Execute(sql, new { ItemName = DateTime.Now.Millisecond.ToString() }, transaction: tr);
Console.WriteLine(count.ToString());
}
static void Update(System.Data.OleDb.OleDbConnection cn, System.Data.IDbTransaction tr = null)
{
var sql = @"UPDATE Item SET ItemName = 'シナノゴールド' WHERE ID = @Id";
var count = cn.Execute(sql, new { Id = 1 }, transaction: tr);
Console.WriteLine(count.ToString());
}
static void GetIdentityWithDapper(System.Data.OleDb.OleDbConnection cn)
{
// 2回回しても問題なく動作する
for (int i = 0; i < 2; i++)
{
var sql = "INSERT INTO Item(ItemName) VALUES (@ItemName)";
cn.Execute(sql, new { ItemName = "秋映" });
var id = (int)cn.Query("SELECT @@IDENTITY as ID").First().ID;
Console.WriteLine("@@IDENTITY -> " + id.ToString());
var results = cn.Query <Item>("SELECT * FROM Item WHERE ID = @Id", new { @Id = id });
Console.WriteLine(results.First().ID + ":" + results.First().ItemName);
}
}
//function that uses Dapper to send data to the database
private static bool Send(string query)
{
try
{
IDbConnection connection = new System.Data.OleDb.OleDbConnection(ConfigurationManager.ConnectionStrings[DB_NAME].ConnectionString);
using (connection)
{
connection.Execute(query);
return(true);
}
}
catch
{
return(false);
}
}
