Cacher is the code snippet organizer for pro developers

Connection.Open();

var cmd = Connection.CreateCommand();
cmd.CommandText = "sp_who2";

var dt = new DataTable();
dt.Load(cmd.ExecuteReader());

Connection.Close();

(from row in dt.AsEnumerable()
 let dbName = (row.Field<string>("DBName") ?? "").Trim()
 let status = (row.Field<string>("Status") ?? "").Trim()
 let hostName = (row.Field<string>("HostName") ?? "").Trim()
 let spid = (row.Field<string>("SPID") ?? "").Trim()
 let lastBatch = (row.Field<string>("LastBatch") ?? "").Trim()

 where status == "SUSPENDED"
 orderby lastBatch
 select row
).Dump();