Im trying to add simple row level security and join user table the following way:
var query = db.From<ResearchEntity>().Where(x => x.Id == id); query.Join<AppUserAuth>((x, y) => x.CreatedBy.Id == int.Parse(session.UserAuthId)); var data = await db.LoadSelectAsync(query);
I am getting from MySQL: “Column ‘Id’ in where clause is ambiguous”
I have tried to add table options with alias with no success…
What am I missing?