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