I have this linq query which works perfectly fine but sometimes it throws exception, following is start :
query = table.Include(x=>x.table2)
after applying few conditions in code finally following is the line which throws exception :
var data = await query.Skip(offset).Take(filter.PagingOption.PageSize).AsNoTracking().ToListAsync();
ErrorDetail : System.Data.SqlClient.SqlException (0x80131904): The column 'Id' was specified multiple times for 't'.\r\n
Mostly it is observed that when IIS is restarted error occurs, but once the error is occurred on refresh this works totally fine. Which I guess is random behavior.
Any ideas ?
User contributions licensed under CC BY-SA 3.0