public bool TransactionOPEntitysCommit(Func <IDbConnection, IDbTransaction, bool> fun)
{
try
{
using (var cn = DbConnectionHelper.CreateConnection())
{
cn.Open();
IDbTransaction transaction = cn.BeginTransaction();
if (fun(cn, transaction))
{
transaction.Commit();
}
cn.Close();
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(false);
}
return(true);
}
public string GetEntityViewJson <TV>(string sql, object param = null)
{
try
{
using (var cn = DbConnectionHelper.CreateConnection())
{
cn.Open();
var itemList = cn.Query <TV>(sql, param).ToList();
cn.Close();
if (itemList != null)
{
return(JsonUtil.toJson(new { Msg = true, Content = JsonUtil.toJson(itemList) }));
}
else
{
return(JsonUtil.toJson(new { Msg = false }));
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(JsonUtil.toJson(new { Msg = false }));
}
}
public void CreateConnectionTest()
{
DbSource dbSource = new DbSource();
dbSource.Provider = "SqlClient Data Provider";
DbConnectionHelper helper = new DbConnectionHelper(dbSource);
DbConnection connection = helper.CreateConnection();
Assert.IsNotNull(connection);
}
public string Execute(string sql, object param = null)
{
try
{
using (var cn = DbConnectionHelper.CreateConnection())
{
cn.Open();
var item = cn.Execute(sql, param);//返回命令影响的行数
cn.Close();
return(JsonUtil.toJson(new { Msg = true, Content = item }));
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(JsonUtil.toJson(new { Msg = false }));
}
}
public string GetNewSerialNumber(string serialtype)
{
try
{
using (var cn = DbConnectionHelper.CreateConnection())
{
lock (_lock)
{
var para = new DynamicParameters();
para.Add("@SerialType", serialtype);
para.Add("@SerialNumber", string.Empty, DbType.String, ParameterDirection.Output);
var res1 = cn.Query("proc_GetSerialNumber", para, null, true, null, CommandType.StoredProcedure); //0
return(para.Get <string>("@SerialNumber"));
}
}
}
catch
{
return(null);
}
}
protected RepositoryOptionsBuilder GetRepositoryOptionsBuilder(ContextProviderType provider)
{
var builder = new RepositoryOptionsBuilder();
switch (provider)
{
case ContextProviderType.InMemory:
{
builder.UseInMemoryDatabase(Guid.NewGuid().ToString());
break;
}
case ContextProviderType.Json:
{
builder.UseJsonDatabase(Path.GetTempPath() + Guid.NewGuid().ToString("N"));
break;
}
case ContextProviderType.Xml:
{
builder.UseXmlDatabase(Path.GetTempPath() + Guid.NewGuid().ToString("N"));
break;
}
case ContextProviderType.AdoNet:
{
builder.UseAdoNet(DbConnectionHelper.CreateConnection(), ensureDatabaseCreated: true);
break;
}
case ContextProviderType.NHibernate:
{
builder.UseNHibernate(cfg =>
{
var currentFile = PathHelper.GetTempFileName();
var connectionString = $"Data Source={currentFile};Persist Security Info=False";
cfg.DataBaseIntegration(x =>
{
x.Dialect <TestFixedMsSqlCe40Dialect>();
x.Driver <SqlServerCeDriver>();
x.ConnectionString = connectionString;
x.LogSqlInConsole = true;
x.LogFormattedSql = true;
});
var mapper = new ModelMapper();
mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes());
var mapping = mapper.CompileMappingForAllExplicitlyAddedEntities();
cfg.AddMapping(mapping);
var exporter = new SchemaExport(cfg);
exporter.Execute(true, true, false);
});
break;
}
case ContextProviderType.EntityFramework:
{
builder.UseEntityFramework <TestEfDbContext>(DbConnectionHelper.CreateConnection());
break;
}
case ContextProviderType.EntityFrameworkCore:
{
builder.UseEntityFrameworkCore <TestEfCoreDbContext>(options =>
{
options
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.ConfigureWarnings(x => x.Ignore(InMemoryEventId.TransactionIgnoredWarning));
});
break;
}
case ContextProviderType.AzureStorageBlob:
{
builder.UseAzureStorageBlob(
nameOrConnectionString: "AzureStorageBlobConnection",
container: Guid.NewGuid().ToString(),
createIfNotExists: true);
break;
}
case ContextProviderType.AzureStorageTable:
{
builder.UseAzureStorageTable(
nameOrConnectionString: "AzureStorageTableConnection",
tableName: "TableName" + Guid.NewGuid().ToString("N").ToUpper(),
createIfNotExists: true);
break;
}
default:
throw new ArgumentOutOfRangeException(nameof(provider));
}
builder.UseLoggerProvider(TestXUnitLoggerProvider);
return(builder);
}
