1. Nuget安装Dapper
2. 使用
static void Main(string[] args)
{
using (OracleConnection connection = new OracleConnection(Helper.OracleHelper.ConnectionString_Default))
{
var m = connection.Query<UserInfo>("select * from usertable").ToList();
var x = connection.Query<UserInfo>("select * from usertable where id=:id", new { id = 2 }).ToList();
Console.WriteLine(x.Count);
foreach (UserInfo user in x)
{
Console.WriteLine(user.name);
}
UserInfo user1 = new UserInfo() { id=3,name="zl"};
var y = connection.Execute("insert into usertable (id,name) values(:id,:name)", user1);
Console.WriteLine(y);
OracleTransaction transaction = connection.BeginTransaction();
try
{
//执行代码...
//执行代码...
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
}
Console.WriteLine("");
}
var a = ConfigurationManager.ConnectionStrings["DemoConnString"];
DataTable dt = Helper.OracleHelper.ExecuteDataTable("Select * From Dual");
Console.WriteLine("");
}