/// <summary>
/// 根据Id获取单个实体对象
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TEntity Get(dynamic id)
{
return(Run(conn =>
{
return SqlMapperExtensions.Get <TEntity>(conn, id);
}));
}
/// <summary>
/// Tìm đối tượng theo khóa chính đầu tiên
/// </summary>
/// <param name="pk">Giá trị khóa chính</param>
/// <returns>Entity</returns>
public virtual Entity FindByKey(dynamic pk)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
return(SqlMapperExtensions.Get <Entity>(connection, pk));
}
}
public TaskItem GetById(object id)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var res = SqlMapperExtensions.Get <TaskItem>(db, id);
return(res);
}
}
public void Delete(int id)
{
T entity = SqlMapperExtensions.Get <T>(_connection, id);
if (entity != null)
{
SqlMapperExtensions.Delete(_connection, entity);
}
}
public void Delete(int id)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
var res = SqlMapperExtensions.Get <TaskItem>(db, id);
if (res != null)
{
SqlMapperExtensions.Delete(db, res);
}
}
}
public override TEntity Get(dynamic id)
{
if (id == null)
{
throw new ArgumentNullException(nameof(id));
}
ValidateConnection();
var conn = OpenDbConnection();
var value = SqlMapperExtensions.Get <TEntity>(conn, id, DbTransaction);
CloseConnection(conn);
return(value);
}
public T GetById(object id)
{
T entities = SqlMapperExtensions.Get <T>(_connection, id);
return(entities);
}
public TEntity Get(TPrimaryKey key)
{
using (var sqlConnection = new SqlConnection(DbConstant.DatabaseConnection))
return(SqlMapperExtensions.Get <TEntity>(sqlConnection, key));
}
public T Get <T>(dynamic id, IDbTransaction transaction = null, int?commandTimeout = null) where T : class => SqlMapperExtensions.Get <T>(_connection, id, transaction, commandTimeout);
public TEntity Get(dynamic id)
{
return(SqlMapperExtensions.Get <TEntity>(_connection, id, _transaction, _commandTimeout));
}
public TEntity Get(int Id)
{
TEntity result = SqlMapperExtensions.Get <TEntity>(connection.Connect, Id);
return(result);
}