public virtual async Task<GetTDataDTO> GetData(string batchId)
{
//batchId example: 0x30c4b63ee3050080
var result = new GetTDataDTO();
Oid batchOid = new Oid(batchId);
var sqlSelect=
@"
SELECT *
FROM data_table fls WITH (NOLOCK)
WHERE batchId = @batchId
";
var parameters = new DynamicParameters();
parameters.Add("batchId", batchOid);
using (var conn = new SqlConnection(ConnectingString))
{
var result = await conn.QueryAsync<GetTDataDTO>(sqlSelect.ToString(), parameters);
}
return result;
}
public virtual async Task<GetTDataDTO> GetData(string batchId)
{
//batchId example: 0x30c4b63ee3050080
var result = new GetTDataDTO();
Oid batchOid = new Oid(batchId);
var sqlSelect=
@"
SELECT *
FROM data_table fls WITH (NOLOCK)
WHERE batchId = @batchId
";
var parameters = new DynamicParameters();
parameters.Add("batchId", batchOid);
using (var conn = new SqlConnection(ConnectingString))
{
var result = await conn.QueryAsync<GetTDataDTO>(sqlSelect.ToString(), parameters);
}
return result;
}