Linq To Sql suggestion wrong

I have the following Linq To Sql select statement:

from
s in dataContext.SalesTable
where
s.Sales1 != null && s.Sales1 != string.Empty
select
s.Sales1

R# is suggesting that I replace the null and empty test for s.Sales1 with
!string.IsNullOrEmpty(s.Sales1), but the compiler is complaining that the
string.IsNullOrEmpty() method 'has no supported translation to SQL'.

Is this because R# can't differentiate between flavors of Linq?


1 comment
Comment actions Permalink

Please could you create minimal working sample which demonstrates this
problem, and send it to us for analysis?

--
Eugene Pasynkov
Developer
JetBrains, Inc
http://www.jetbrains.com
"Develop with pleasure!"
"Richard Haber" <richard.haber@gmail.com> wrote in message
news:g2cf5u$a9m$1@is.intellij.net...
>I have the following Linq To Sql select statement:
>

from
s in dataContext.SalesTable
where
s.Sales1 != null && s.Sales1 != string.Empty
select
s.Sales1

>

R

  1. is suggesting that I replace the null and empty test for s.Sales1 with

!string.IsNullOrEmpty(s.Sales1), but the compiler is complaining that the
string.IsNullOrEmpty() method 'has no supported translation to SQL'.

>

Is this because R# can't differentiate between flavors of Linq?



0

Please sign in to leave a comment.