Loading

Convert SQL to LInq

sankeerth m

select *, Column1,Column2,Column3,Column4 from tableA where Column1 is not null and Column1<>' ' and Column1 is not null and Column2<>' ' and Column3 is not null and Column3<>' ' and IsActive = 1

i need to covert into linq can any one help me out.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
if you have more than 4 columns but you want just 4 columns
var res=context.TableA.Where(x => x.Column1!=null && x.column2!= null && x.Column3!=null && x.IsActive == true).select(x=>new {
col1=x.column1,
col2=x.column2,
col3=x.column3,
col4=x.column4,


})
if you have only 4 columns and you want all of them
var res=context.TableA.Where(x => x.Column1!=null && x.column2!= null && x.Column3!=null && x.IsActive == true).ToList();
+2