Yes, sorry: version 5.3.5, Adapter, using C# 4.6.2.
There are just few records in the tables.
A breakpoint does not help, since the program enter this line and stops there:
var results = _db.Adapter.FetchQuery<UserX>(sql);
Entering into this function I see:
/// <summary>Creates a new Dynamic Query engine object and passes in the defined catalog/schema overwrite hashtables.</summary>
protected override DynamicQueryEngineBase CreateDynamicQueryEngine()
{
return this.PostProcessNewDynamicQueryEngine(new DynamicQueryEngine());
}
And inside this:
/// <summary>Sets the per instance compatibility level on the dqe instance specified.</summary>
/// <param name="dqe">The dqe.</param>
protected override void SetPerInstanceCompatibilityLevel(DynamicQueryEngineBase dqe)
{
if(_compatibilityLevel.HasValue)
{
((DynamicQueryEngine)dqe).CompatibilityLevel = _compatibilityLevel.Value;
}
}
where _compatibilityLevel.HasValue is false. This last method exits and everything stop responding.
However... UPDATE!
I've been unlucky in selecting the table to use for my expertiments.
My table is "User" and it does not work. But if I do the same with other tables... it works
I mean:
var sql = "SELECT * FROM Culture";
var results = _db.Adapter.FetchQuery<CultureX>(sql);
with
public class CultureX
{
public string Name { get; set; }
public short Code { get; set; }
}
WORKS.
While
var sql = "SELECT * FROM User";
var results = _db.Adapter.FetchQuery<UserX>(sql);
with
public class UserX
{
public Guid Id { get; set; }
public string Username { get; set; }
public string Password { get; set; }
}
DOES NOT WORK.
Can "User" be a sort of reserved word which cause problems?