本文整理汇总了C#中AbstractConnection.GetConnection方法的典型用法代码示例。如果您正苦于以下问题：C# AbstractConnection.GetConnection方法的具体用法？C# AbstractConnection.GetConnection怎么用？C# AbstractConnection.GetConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类AbstractConnection的用法示例。
在下文中一共展示了AbstractConnection.GetConnection方法的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Exists
public bool Exists(AbstractConnection connection, Entity entity) {
using (var cn = connection.GetConnection()) {
cn.Open();
var table = cn.Query<string>(SQL, new { name = entity.OutputName() }).DefaultIfEmpty(string.Empty).FirstOrDefault();
return !string.IsNullOrEmpty(table);
}
}示例2: Read
public Fields Read(AbstractConnection connection, string process, string prefix, string name, string schema, bool isMaster = false) {
var fields = new Fields();
using (var cn = connection.GetConnection()) {
cn.Open();
var sql = PrepareSql();
connection.Logger.EntityDebug(name, sql);
var results = cn.Query(sql, new { name, schema });
foreach (var result in results) {
var columnName = result.COLUMN_NAME;
var type = GetSystemType(result.DATA_TYPE);
var length = result.CHARACTER_MAXIMUM_LENGTH == "0" || result.CHARACTER_MAXIMUM_LENGTH == "-1" ? "64" : result.CHARACTER_MAXIMUM_LENGTH;
var fieldType = (bool)result.IS_PRIMARY_KEY ? (isMaster ? FieldType.MasterKey : FieldType.PrimaryKey) : FieldType.NonKey;
var field = new Field(type, length, fieldType, true, string.Empty) {
Name = columnName,
Entity = name,
Process = process,
Index = Convert.ToInt16(result.ORDINAL_POSITION - 1),
Schema = schema,
Input = true,
Precision = result.NUMERIC_PRECISION,
Scale = result.NUMERIC_SCALE,
Alias = prefix + columnName
};
fields.Add(field);
}
}
return fields;
}示例3: Execute
private static void Execute(AbstractConnection connection, string sqlFormat, params object[] values) {
var sql = values.Length > 0 ? string.Format(sqlFormat, values) : sqlFormat;
using (var cn = connection.GetConnection()) {
cn.Open();
var cmd = cn.CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}示例4: Count
public int Count(AbstractConnection connection, Entity entity, bool useAlias) {
if (_connectionChecker == null || _connectionChecker.Check(connection)) {
if (_entityExists.Exists(connection, entity)) {
using (var cn = connection.GetConnection()) {
cn.Open();
var sql = string.Format("SELECT COUNT(*) FROM [{0}].[{1}] WITH (NOLOCK);", entity.Schema, entity.OutputName());
var cmd = cn.CreateCommand();
cmd.CommandText = sql;
return (int)cmd.ExecuteScalar();
}
}
}
return 0;
}示例5: Create
public override void Create(AbstractConnection connection, Process process, Entity entity) {
if (EntityExists != null && EntityExists.Exists(connection, entity)) {
process.Logger.EntityWarn(entity.Name,"Trying to create entity that already exists! {0}", entity.Name);
return;
}
var keyType = entity.IsMaster() ? FieldType.MasterKey : FieldType.PrimaryKey;
var writer = process.StarEnabled && keyType == FieldType.MasterKey ?
new FieldSqlWriter(entity.Fields, entity.CalculatedFields, process.CalculatedFields, GetRelationshipFields(process.Relationships, entity)) :
new FieldSqlWriter(entity.Fields, entity.CalculatedFields);
var primaryKey = writer.FieldType(keyType).Alias(connection.L, connection.R).Asc().Values();
var defs = new List<string>();
defs.AddRange(writer
.Reload()
.AddBatchId(entity.Index)
.AddDeleted(entity)
.AddSurrogateKey(entity.Index)
.Output()
.Alias(connection.L, connection.R)
.DataType(new SqlServerDataTypeService())
.AppendIf(" NOT NULL", keyType)
.Values());
var rowVersion = entity.Fields.WithSimpleType("rowversion").WithoutInput().WithoutOutput();
if (rowVersion.Any()) {
var alias = rowVersion.First().Alias;
defs.Add(connection.Enclose(alias) + " [ROWVERSION] NOT NULL");
}
var createSql = connection.TableQueryWriter.CreateTable(entity.OutputName(), defs);
_logger.EntityDebug(entity.Name, createSql);
var indexSql = connection.TableQueryWriter.AddUniqueClusteredIndex(entity.OutputName());
_logger.EntityDebug(entity.Name, indexSql);
var keySql = connection.TableQueryWriter.AddPrimaryKey(entity.OutputName(), primaryKey);
_logger.EntityDebug(entity.Name, keySql);
using (var cn = connection.GetConnection()) {
cn.Open();
cn.Execute(createSql);
cn.Execute(indexSql);
cn.Execute(keySql);
_logger.EntityInfo(entity.Name, "Initialized {0} in {1} on {2}.", entity.OutputName(), connection.Database, connection.Server);
}
}示例6: RecordsExist
public bool RecordsExist(AbstractConnection connection, Entity entity) {
if (EntityExists.Exists(connection, entity)) {
using (var cn = connection.GetConnection()) {
cn.Open();
var sql = [email protected]"SELECT TOP(1) [{entity.PrimaryKey.First().Alias}] FROM [{entity.OutputName()}];";
var cmd = cn.CreateCommand();
cmd.CommandText = sql;
using (var reader = cmd.ExecuteReader()) {
return reader.Read();
}
}
}
return false;
}示例7: RecordsExist
public bool RecordsExist(AbstractConnection connection, Entity entity) {
if (!EntityExists.Exists(connection, entity))
return false;
using (var cn = connection.GetConnection()) {
cn.Open();
var exists = cn.Query<bool>(string.Format(@"
SELECT EXISTS(
SELECT ""{0}""
FROM ""{1}""
LIMIT 1
);
", entity.PrimaryKey.First().Alias, entity.OutputName())).DefaultIfEmpty(false).First();
return exists;
}
}示例8: RecordsExist
public bool RecordsExist(AbstractConnection connection, Entity entity) {
if (!EntityExists.Exists(connection, entity))
return false;
using (var cn = connection.GetConnection()) {
cn.Open();
var records = cn.Query<string>(string.Format(@"
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT `{0}`
FROM `{1}`
LIMIT 1;
COMMIT;
", entity.PrimaryKey.First().Alias, entity.OutputName()));
return records != null && records.Any();
}
}示例9: Exists
public bool Exists(AbstractConnection connection, Entity entity) {
using (var cn = connection.GetConnection()) {
cn.Open();
return cn.Query<bool>(SQL, new { name = entity.OutputName() }).DefaultIfEmpty(false).FirstOrDefault();
}
}