Subsonic – Simple Query

subsonic

I have a table has 2 columns

Val1 int

Val2 int

My query very simple.

I want to get collection of record have condition (val1=Val2) ,

equivalent to (Select * from table where Val1=Val2)

I try

IDataReader rdr = new Query("Table").WHERE("Val1=Val2").ExecuteReader();
tableColl.LoadAndCloseReader(rdr);
rdr.Close();

and

  ..WHERE (" 'Val1=Val2' ")
  ..WHERE (Table.Columns.Val1,IsEqualTo,Table.Columns.Val2) //This not reguler I know
  ..WHERE ("Val"+'='+"Val2") 
  .....

any help be more apricated.

Thanks.

Best Answer

Unfortunately you'll need to do this as an inline query as far as I know:

TableCollection tableCollection = new InlineQuery()  
  .ExecuteAsCollection<TableCollection>(
    "SELECT * FROM " + Table.Schema.TableName " WHERE " + Table.Columns.Val1 + " = " + Table.Columns.Val2);
Related Topic