linq2db: postgres Array queries do not seem to be supported!
[Table(Name = "dd")]
public partial class dd
{
[Column(Name = "dd", DataType = DataType.VarChar, Length = 255)]
public System.String[] source { get; set; }
}
using (var con = DB.GetConnection())
{
var sql = con.Entity.dd.Where(c => c.source.Contains("2"));
var data2 = sql.ToList();
}
throw: LinqToDB.Linq.LinqException:“‘c.source.Contains(“2”)’ cannot be converted to SQL.”
About this issue
- Original URL
- State: open
- Created 5 years ago
- Comments: 22 (12 by maintainers)
Can confirm that with efcore involved it doesn’t work. looking into it