var fuckQuery =
@$"IF OBJECT_ID('tempdb..#FuckTemp') IS NOT NULL drop table #FuckTemp;
declare @recordsFiltered int;
select * into #FuckTemp
from (
select * from yourTable Where 1 = 1 or YourMather = @YourMather
) as FuckTemp;
set @recordsFiltered = (select count(1) from #FuckTemp);
select * from #FuckTemp as FuckAgain order by 1;
select @recordsFiltered;
select 'FuckAgain';
IF OBJECT_ID('tempdb..#FuckTemp') IS NOT NULL drop table #FuckTemp;
";
dynamic lst1;
dynamic lst2;
dynamic lst3;
using (var cn = FuckDatabase.FuckConnection(forceOpen: true)) {
using (var multi = cn.QueryMultipleAsync(fuckQuery, new { YourMather = "หอย" }).Result) {
lst1 = multi.Read<dynamic>().ToList();
lst2 = multi.Read<dynamic>().ToList();
lst3 = multi.Read<dynamic>().ToList();
}
}
//await so on...