private void EnsureTable(Type type) { var tableName = ConventionReader.GetTableName(type); if (!_tables.ContainsKey(tableName)) { _tables[tableName] = new ResultSet(); } }
public void EnsureSubQuery(string alias, Type type) { var tableName = _conventionReader.GetTableName(type); if (!HasSubQuery(tableName, alias)) { CreateSubQuery(alias, type); } }
public void Delete <T>(T instance) { var tableName = _conventionReader.GetTableName <T>(); var primaryKeyColumnName = _conventionReader.GetPrimaryKeyColumnName <T>(); var primaryKeyValue = _conventionReader.GetPrimaryKeyValue(instance); var constraintExpression = QueryExpression.Create(new EqualsExpression(primaryKeyColumnName, primaryKeyValue)); var command = _sqlGenerator.CreateDeleteCommand(tableName, constraintExpression); _dbCommandExecutor.ExecuteNonQuery(command, ConnectionString); }
public int Count <T>(QueryExpression queryExpression) { var tableName = _conventionReader.GetTableName <T>(); var command = _sqlGenerator.CreateCountCommand(tableName, queryExpression.Translate(_conventionReader)); return(_dbCommandExecutor.ExecuteScalar <int>(command, ConnectionString)); }
public static AliasedSqlSubQuery Create(string alias, Type type, IConventionReader conventionReader) { var subQuery = new AliasedSqlSubQuery() { Alias = alias, TableName = conventionReader.GetTableName(type), AllSelectableColumnNames = conventionReader.GetSelectableColumNames(type).ToList(), PrimaryKeyColumnName = conventionReader.TryGetPrimaryKeyColumnName(type) }; return(subQuery); }
private IEnumerable <TCommand> CreateInsertCommands <TEntity, TCommand>(IEnumerable <TEntity> entities, Func <string, IDictionary <string, object>, TCommand> f) { var commands = new List <TCommand>(); foreach (var entity in entities) { var columnValues = _conventionReader.GetColumnValuesForInsertOrUpdate(entity); var tableName = _conventionReader.GetTableName <TEntity>(); var command = f(tableName, columnValues); commands.Add(command); } return(commands); }
public string GetTableIdentifier(IConventionReader conventionReader) { return _alias ?? conventionReader.GetTableName(_type); }
public string GetTableIdentifier(IConventionReader conventionReader) { return(_alias ?? conventionReader.GetTableName(_type)); }