Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-25 Thread Ilya Kasnacheev
Hello! Why not: SELECT t.*, t._val from materials t INNER JOIN ... Regards, -- Ilya Kasnacheev чт, 21 янв. 2021 г. в 19:19, siva : > Hi, > > It's working fine in "select _val from mytesttable" query but in case of > sub > query or joins it's failing with an error like column not found > >

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-21 Thread siva
Hi, It's working fine in "select _val from mytesttable" query but in case of sub query or joins it's failing with an error like column not found It's failing access column with and without table Aliases. for example Query::> SELECT t.* from (select _val FROM materials ) as t INNER JOIN

Re: SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-21 Thread Alex Plehanov
Hello, Try this: "select _val from mytesttable" чт, 21 янв. 2021 г. в 17:38, siva : > Hi, > I am using .net Ignite v2.9.1 and > > Since SqlQuery deprecated in documentation suggesting please use > SqlFieldsQuery. > > what is the way to get result as Type using sqlfieldsquery? > > for example

SqlQuery Deprecated Since 2.8, please use SqlFieldsQuery instead....How to get result as passing model Type with SqlFieldsQuery?

2021-01-21 Thread siva
Hi, I am using .net Ignite v2.9.1 and Since SqlQuery deprecated in documentation suggesting please use SqlFieldsQuery. what is the way to get result as Type using sqlfieldsquery? for example query select * from mytesttable Thanks. -- Sent from: