private void Button6_Click(object sender, EventArgs e)
{
string sql = "INSERT INTO BD_TABLELOG(tablename,createtime) Values (@name, to_date(@time,'yyyy-MM-dd HH:mm:ss'))";
using (var connection = new UniConnection("provider=Oracle;User Id=smart;Password=smart;Server=121.40.101.29;Direct=True;Port=1521;Sid=orcl;"))
// using (var connection = new UniConnection("provider=SQL Server;Data Source=121.40.101.29;Initial Catalog=scm_main;Password=sa123;User ID=sa;"))
{
var affectedRows = connection.Execute(sql, new { name = "Mark", time = "2019-01-01 12:35:00" });
// var tableLog = new TableLog();
// tableLog.tableName = "aaa";
// tableLog.createTime=DateTime.Now;
//
//
// var identity = connection.Insert(sql);
// Only for see the Insert.
// var customer = connection.Query<Customer>("Select * FROM CUSTOMERS WHERE CustomerName = 'Mark'").ToList();
//
// FiddleHelper.WriteTable(customer);
}
}
