public DapperContext(DapperRuntime runtime, ILoggerFactory loggerFactory)
{
_loggerFactory = loggerFactory;
this.Runtime = runtime;
_logger = loggerFactory.CreateLogger <DapperContext>();
_connections = new ConcurrentDictionary <string, DbConnection>();
}
public CrudSqlSegments(Type entityType, DapperRuntime runtime)
{
Guard.ArgumentNotNull(entityType, nameof(entityType));
var metadata = runtime.GetMetadata(entityType);
this._insertSql = new Lazy <string>(() => GenerateInsertSql(entityType, runtime, metadata));
this._updateSql = new Lazy <string>(() => GenerateUpdateSql(entityType, runtime, metadata));
this._deleteSql = new Lazy <string>(() => GenerateDeleteSql(entityType, runtime, metadata));
this._selectSql = new Lazy <string>(() => GenerateSelectSql(entityType, runtime, metadata));
}
private static string GenerateSelectSql(Type entityType, DapperRuntime runtime, DapperMetadata metadata)
{
string columnsSetSeg =
metadata.Fields.Where(f => !f.Ignore).OrderBy(x => x.Field.Name).Select(k => runtime.DelimitIdentifier(entityType, k.Name)).ToArrayString(", ");
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("SELECT ");
sqlBuilder.Append(columnsSetSeg);
sqlBuilder.Append($" FROM ");
sqlBuilder.Append($"{runtime.DelimitIdentifier(entityType, metadata.TableName)}");
return(sqlBuilder.ToString());
}
private static string GenerateDeleteSql(Type entityType, DapperRuntime runtime, DapperMetadata metadata)
{
string whereSeg = KeyDelimitSegment(entityType, runtime, metadata);
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("DELETE FROM ");
sqlBuilder.Append($"{runtime.DelimitIdentifier(entityType, metadata.TableName)} ");
if (!string.IsNullOrWhiteSpace(whereSeg))
{
sqlBuilder.Append($" WHERE ");
sqlBuilder.Append(whereSeg);
}
return(sqlBuilder.ToString());
}
private static string GenerateInsertSql(Type entityType, DapperRuntime runtime, DapperMetadata metadata)
{
var fields = metadata.Fields.Where(f => f.Ignore == false && f.AutoGeneration == false).OrderBy(x => x.Field.Name).ToArray();
string columns = fields.Select(k => runtime.DelimitIdentifier(entityType, k.Name)).ToArrayString(", ");
string parameters = fields.Select(k => $"{runtime.DelimitParameter(entityType, k.Field.Name)}").ToArrayString(", ");
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("INSERT INTO ");
sqlBuilder.Append($"{runtime.DelimitIdentifier(entityType, metadata.TableName)} ");
sqlBuilder.Append($"({columns}) ");
sqlBuilder.Append(" VALUES ");
sqlBuilder.Append($"({parameters})");
return(sqlBuilder.ToString());
}
private static string GenerateUpdateSql(Type entityType, DapperRuntime runtime, DapperMetadata metadata)
{
var fields = metadata.Fields.Where(f => !f.IsKey && !f.AutoGeneration && !f.Ignore).OrderBy(x => x.Field.Name).ToArray();
string columnsSetSeg = fields.Select(k => $"{runtime.DelimitIdentifier(entityType, k.Name)} = {runtime.DelimitParameter(entityType,k.Field.Name)}").ToArrayString(", ");
string whereSeg = KeyDelimitSegment(entityType, runtime, metadata);
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("UPDATE ");
sqlBuilder.Append($"{runtime.DelimitIdentifier(entityType, metadata.TableName)} ");
sqlBuilder.Append($"SET ");
sqlBuilder.Append(columnsSetSeg);
if (!string.IsNullOrWhiteSpace(whereSeg))
{
sqlBuilder.Append($" WHERE ");
sqlBuilder.Append(whereSeg);
}
return(sqlBuilder.ToString());
}
private static string KeyDelimitSegment(Type entityType, DapperRuntime runtime, DapperMetadata metadata)
{
return(metadata.Fields.Where(f => f.IsKey).Select(k => $"{runtime.DelimitIdentifier(entityType, k.Name)} = {runtime.DelimitParameter(entityType, k.Field.Name)}").ToArrayString(" AND "));
}
public DapperSqlGenerator(DapperRuntime runtime)
{
Guard.ArgumentNotNull(runtime, nameof(runtime));
_runtime = runtime;
}