代码拉取完成,页面将自动刷新
DbContext for Dapper.
See here.
DapperDbContext
.Use connectionString name in App.Config
or Web.config
as constructor parameters.
If your project type is .NET Core
,you should add json setting for connectionStrings
and DbConnectionFactories
,format reference here.
public class IRepository:DbContext
{
public IRepository():base("db")
{
}
}
Or override OnConfiguration
method, invoke Use
method.
public class IRepository : DbContext
{
public IRepository()
{
}
protected override void OnConfiguration(DbConnectionFactory factory)
{
base.OnConfiguration(factory);
string providerName= "MySql.Data.MySqlClient";
string connectionString= "Data Source=127.0.0.1;Initial Catalog=user;User Id=root;Password=root;Charset=utf8;";
factory.Use(providerName, connectionString);
}
}
public class TestRepository : IRepository
{
public bool Connected()
{
try
{
object obj = ExecuteScalar("SELECT CONVERT(varchar(50), GETDATE(), 25);", null, null, CommandType.Text);
if (obj == null)
{
return false;
}
string dt = obj.ToString();
DateTime _dt;
return DateTime.TryParse(dt, out _dt);
}
catch (Exception ex)
{
throw ex;
}
}
}
Execute Sql with transaction.
public class TestRepository : IRepository
{
public bool ExecuteWithTran()
{
string sql = null;
object param = null;
// begin tran
BeginTransaction();
// execute sql
Execute(sql, param);
// commit tran
Commit();
// or
// callback tran
//Callback();
}
}
Licensed under the MIT License.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
1. 开源生态
2. 协作、人、软件
3. 评估模型