/// <summary>
/// Get entity using Id
/// </summary>
/// <param name="id">the unique Id to search for entity</param>
/// <returns>entity corrspond to input Id</returns>
public T Get(Guid id)
{
var cmdText = string.Format(_getSqlCommand, _tableName);
var parameters = new Dictionary <string, object>()
{
{ "@Id", id }
};
var dataTable = _sqlHelper.ExcuteQuery(cmdText, parameters);
if (dataTable == null || dataTable.Rows == null || dataTable.Rows.Count == 0)
{
return(null);
}
return(Parse <T>(dataTable.Rows[0]));
}
