Member is not a table column.

[linq2db]

Member is not a table column.

[igor-tkachev]

Can I get a sample of your data model?

[suigintou]

internal class DatabasePicture
{
    public ModerationStatus Status { get; set; }
}

public enum ModerationStatus
{
    Pending = 0,
    Accepted = 1,
    Declined = 2
}

[igor-tkachev]

And query if possible.

[suigintou]

new DataContext()
    .GetTable<DatabasePicture>()
    .Where(_ => _.Status == ModerationStatus.Accepted)
    .Count();

СУБД: MSSQL2012

[igor-tkachev]

I have added a test to reproduce the problem - 3c17331
It works fine.

[suigintou]

Извиняюсь, проблема действительно не в enum'ах. Я не знаю почему, но у меня выпадает ошибка "Member is not a table column." на любом свойстве, используемом в запросе, если оно явно не помечено атрибутом Column.

[igor-tkachev]

It is by design. If you decorate your class with [Table] attribute, you should decorate all your columns with [Column] attribute. As an option you can use flag IsColumnAttributeRequired=false.

[suigintou]

Понятно. Просто в BLToolkit было другое поведение.