patgenie
Code like:
string lookup = "Man";
IQueryable[] result = {(
from m in ActiveMortgagesCap
join b in Borrowers on m.BorrowerId equals b.BorrowerId
where b.BorrowerName.Contains(lookup) || m.ProjectDescription.Contains(lookup) || Convert.ToString(m.MortgageId).Contains(lookup)
orderby m.MortgageId
select new
{
m.MortgageId,
m.ProjectDescription,
b.BorrowerName,
m.PrincipalOutstanding,
m.CurBalance
})};
result.Dump("Search on " + lookup);
This works fine in LinqPad but fails on the logic " || Convert.ToString(m.MortgageId).Contains(lookup)" when you run it in VS2012.
Is there a workaround for this?
m.MortgageId is an indexed integer column in a SQL2012 database.