Hi all,
Does Ignite.NET supports SqlFieldQuery referencing properties/fields of
custom type?
Queries referencing Dummy object succeed;
"select top(10) Dummy from KPIDetail"
//OK
"select Dummy, count(*) from KPIDetail group by Dummy" //OK
"select Dummy from KPIDetail order by Dummy" //OK
The Question: Is there a way to query fields of Dummy object ? e.g:
"select Dummy.ID from KPIDetail" or "select Dummy from KPIDetail
where Dummy.ID < 10"
The obvious workaround is adding fields of Dummy object as public properties
to KPIDetail object (see KPIDetail.DummyID), but I noticed that it works
only with IBinarySerializer. When reflective serialization is used DummyID
is deserialized as null in following queries:
"select top(10) DummyID from KPIDetail" - returns 10 rows, value in
IQueryCursor is null
"select top(10) DummyID from KPIDetail where DummyID = 10" - nothing
is returned
Here is the code:
[Serializable]
public class KPIDetail
{
[Dapper.Contrib.Extensions.Key]
public int ID { get; set; }
public DateTime? Date { get; set; }
public string Origin { get; set; }
public string Destination { get; set; }
public int WayBillNumber { get; set; }
public DateTime? WayBillDate { get; set; }
public string Shipper { get; set; }
public string Consignee { get; set; }
public float? LoadedDays { get; set; }
public float? EmptyDays { get; set; }
public float? TotalDays { get; set; }
public float? LoadedMiles { get; set; }
public float? EmptyMiles { get; set; }
public float? TotalMiles { get; set; }
public int? VolumeCount { get; set; }
public DummyKPI Dummy { get; set; } = new DummyKPI();
public int DummyID {
get { return Dummy.ID; }
set { Dummy.ID = value;}
}
}
[Serializable]
public class DummyKPI
{
private static int i = 1;
public DummyKPI()
{
ID = i++;
Str = ID.ToString();
}
public int ID { get; set; }
public string Str { get; set; }
}
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/SqlFieldQueries-on-property-of-custom-user-type-tp10719.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
