ADO.NET DataAdapter

SqlDataAdapter da = new SqlDataAdapter("pr_SELECT_Record", Environment.GetEnvironmentVariable("SqlDbConnectionString"));
DataSet ds = new DataSet();
da.Fill(ds);

DataTable dtData = ds.Tables[0];

EnumerableRowCollection<DataRow> query = from row in dtData.AsEnumerable()
where row.Field<bool>("IsDelete") == false
select row;

SqlDataAdapter da = new SqlDataAdapter("pr_SELECT_Record", Environment.GetEnvironmentVariable("SqlDbConnectionString"));
DataSet ds = new DataSet();
da.Fill(ds);

DataView dvData = ds.Tables[0].DefaultView;

dvData.RowFilter = "Col01 <> ''";

foreach (DataRowView drRow in dvData)
{
      drRow["Col01"].ToString();
}