public bool isLocked(BreakDownLogLock breakdownlock,string depotno)
{
int lockid = goContext
.goBreakDownLogLock
.Where(u => u.LogYear == breakdownlock.LogYear && u.LogMonth == breakdownlock.LogMonth
&& u.DepotNo in ( depotno)) // Not working Please help how to use IN clause
if (lockid > 0)
{
var breaklog = Context.goBreakDownLogLock.Find((lockid));
if (breaklog != null)
{
breaklog.isBreakLocked = true;
}
}
else
{
goContext.goBreakDownLogLock.Add(breakdownlock);
}
long cnt = goContext.SaveChanges();
return cnt;
}
As this is C# code you are rather testing if an enumeration contains a given value ie something such as:
int[] depotno = new int[]{1,2,3,4,5,6,7,8,9};
and in your LINQ query something such as ... && depotno.Contains(u.DepotNo) // will be translated on the SQL side to <column for u.DepotNo> IN (<list of array values>)
Member
313 Points
1071 Posts
How to use IN clause in Linq
Nov 19, 2019 10:05 AM|polachan|LINK
I want to use IN clause with LINQ please help
string depotno = '1,2,3,4,5,6,7,8,9'
public bool isLocked(BreakDownLogLock breakdownlock,string depotno) { int lockid = goContext .goBreakDownLogLock .Where(u => u.LogYear == breakdownlock.LogYear && u.LogMonth == breakdownlock.LogMonth && u.DepotNo in ( depotno)) // Not working Please help how to use IN clause if (lockid > 0) { var breaklog = Context.goBreakDownLogLock.Find((lockid)); if (breaklog != null) { breaklog.isBreakLocked = true; } } else { goContext.goBreakDownLogLock.Add(breakdownlock); } long cnt = goContext.SaveChanges(); return cnt; }All-Star
46260 Points
16899 Posts
Re: How to use IN clause in Linq
Nov 19, 2019 10:15 AM|PatriceSc|LINK
Hi,
As this is C# code you are rather testing if an enumeration contains a given value ie something such as:
int[] depotno = new int[]{1,2,3,4,5,6,7,8,9};
and in your LINQ query something such as ... && depotno.Contains(u.DepotNo) // will be translated on the SQL side to <column for u.DepotNo> IN (<list of array values>)
All-Star
54204 Points
13635 Posts
Re: How to use IN clause in Linq
Nov 19, 2019 05:55 PM|bruce (sqlwork.com)|LINK
var list = depotno.Split(','); int lockid = goContext .goBreakDownLogLock .Where(u => u.LogYear == breakdownlock.LogYear && u.LogMonth == breakdownlock.LogMonth && u.DepotNo in (list))