WEB API 2 IQueryable IN Query

Question

In WEB API 2, how to use IN Query From SQL string:

select * from TABLE where state in (x)

For

// GET: api/TABLE
public IQueryable<TABLE> GetTABLE(string x)
{
    return db.TABLE.Where(c => c.state.Contains(x));
}

+3

Sha-pai li Apr 20 '15 at 6:10

1 answer

Giorgi nakeuri · Answer 1 · 2015-04-20T09:52:28+0000

Something like this should work:

public IQueryable<TABLE> GetTABLE(string x)
{
    var l = new List<string>() {x};

    return db.TABLE.Where(c => l.Contains(c.state));
}