ada yang pakai asp.net MVC? kalau ada kira2 kenapa ya store procedur saat di execute sama linq kok kadang2 lambat? cuman setelah di alter sp nya cepat lagi

Linq as in EFCore?

cuman ini muncul kadang2, tapi sp nya kalau saya execute di sql management studio aman2 aja cuman beberapa ms

coba ke appsettings.json, set Logging.LogLevel.Default: "Information"
Logging.LogLevel.Microsoft: "Information"

ya udah coba copas LINQ nya ke sini

mending masukin pastebin wkwkwkw

List<procGetPO_Result> datacount = (from d in db.procGetPO(roleId,startDate,endDate) select d).ToList();

dotnet berapa?

kamu harus tau kamu sedang apply LINQ operator di IEnumerable, IQueryable, atau ICollection

Itu tiga2nya harus realised/collected atau engga om?

ICollection: materialized
IEnumerable: stream, reenumerated every time
IQueryable: expression (AST) builder. cuma build expression tree, lalu converted ke bentuk lain ketika dicompile

ICollection: materialized
IEnumerable: stream, reenumerated every time
IQueryable: expression (AST) builder. cuma build expression tree, lalu converted ke bentuk lain ketika dicompile

common mistake ketika pake LINQ to SQL atau EF itu adalah bikin IQueryable yang di C# dianggap simple operation, tapi either nggak ada padanannya di SQL atau nggak efisien ketika ditranslate ke SQL

jadi instead of doing this:

query = query.OrderBy(item => {
  switch (sortkey) {
    case 0: return item.Name;
    case 1: return item.Price;
    default: return item.Id;
  }
});

do this:

switch (sortkey) {
  case 0:
    query = query.OrderBy(x => x.Name);
    break;
  case 1:
    query = query.OrderBy(x => x.Price);
    break;
  default:
    query = query.OrderBy(x => x.Id);
    break;
}

btw enggak bisa

jadi instead of doing this:

query = query.OrderBy(item => {
  switch (sortkey) {
    case 0: return item.Name;
    case 1: return item.Price;
    default: return item.Id;
  }
});

do this:

switch (sortkey) {
  case 0:
    query = query.OrderBy(x => x.Name);
    break;
  case 1:
    query = query.OrderBy(x => x.Price);
    break;
  default:
    query = query.OrderBy(x => x.Id);
    break;
}

jadi instead of doing this:

query = query.OrderBy(item => {
  switch (sortkey) {
    case 0: return item.Name;
    case 1: return item.Price;
    default: return item.Id;
  }
});

do this:

switch (sortkey) {
  case 0:
    query = query.OrderBy(x => x.Name);
    break;
  case 1:
    query = query.OrderBy(x => x.Price);
    break;
  default:
    query = query.OrderBy(x => x.Id);
    break;
}

jadi instead of doing this:

query = query.OrderBy(item => {
  switch (sortkey) {
    case 0: return item.Name;
    case 1: return item.Price;
    default: return item.Id;
  }
});

do this:

switch (sortkey) {
  case 0:
    query = query.OrderBy(x => x.Name);
    break;
  case 1:
    query = query.OrderBy(x => x.Price);
    break;
  default:
    query = query.OrderBy(x => x.Id);
    break;
}

Iya ngga bisa krn itu di c# baru si. Sedangkan km pake .net framework 4.5 bisa aja c# nya masi jadul juga

di dalam IEnumerable dan ICollection memang kedua hal ini sama aja. tapi di IQueryable hasilnya beda jauh

untuk nambah asc/descnya dimana pak?

switch (sortkey) {
  case nameof(Foo.Name):
    if (sortasc) {
      query = query.OrderBy(x => x.Name);
    } else {
      query = query.OrderByDescending(x => x.Name);
    }
    break;
  ....
}

panjang jadi code nya ya pak

panjang jadi code nya ya pak

lagian harusnya kamu pakai Expression<Func<ModelName, string>> bukan Func<ModelName, string>

ini kalau pake IQueryAble pak

aman kalo gitu

aman berarti tetap pakai Func<ModelName, string> kan pak?