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)

Most upvoted comments

Can confirm that with efcore involved it doesn’t work. looking into it