public string SqlString()
{
string sql = string.Empty;
SqlEntity entity = GetSqlEntity();
switch (this._type)
{
case SqlType.Query:
sql = _adapter.Query(entity);
break;
case SqlType.Insert:
sql = _adapter.Insert(_userKey, entity);
break;
case SqlType.Update:
sql = _adapter.Update(entity);
break;
case SqlType.Delete:
sql = _adapter.Delete(entity);
break;
default:
break;
}
return(sql);
}
/// <summary>
/// Queries the specified connection.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="connection">The connection.</param>
/// <param name="sql">The SQL.</param>
/// <param name="param">The parameter.</param>
/// <param name="transaction">The transaction.</param>
/// <param name="buffered">if set to <c>true</c> [buffered].</param>
/// <param name="commandTimeout">The command timeout.</param>
/// <param name="commandType">Type of the command.</param>
/// <returns></returns>
/// <exception cref="System.ArgumentNullException">connection;connection cannot be null</exception>
/// <exception cref="System.ApplicationException">ConnectionState must be Open, current state: + connection.State</exception>
public static IEnumerable <T> Query <T>(this IDbConnection connection, string sql, object param = null, IDbTransaction transaction = null, bool buffered = true, int?commandTimeout = null, CommandType?commandType = null)
{
// Argument Validation
if (connection == null)
{
throw new ArgumentNullException("connection", "connection cannot be null");
}
InitializeCacheSweeper();
// Execute
ISqlAdapter adapter = GetFormatter(connection);
var results = adapter.Query <T>(connection, sql, param, transaction, buffered, commandTimeout, commandType);
return(results);
}
public void Run(ISqlAdapter sqlAdapter)
{
var a = sqlAdapter.Query <UserCenter.DataModel.DB_User>();
var aa = a.ToList();
}