strange linq difference (index out bounds)
i have table, we'll users. list unparalleled primary pivotal tangible sql server - an autoincrement int id.
sometimes, linq queries opposing list destroy an "index outmost range" blunder - even many simplest queries. query itself doesn't any indexers.
for example:
user = users.take(1);
or
ienumerable<users> = users.tolist();
both queries threw same error. controlling debugger visualizer feeling during generated query - i duplicate brew query sql works fine. i also click "execute" visualizer works fine. nonetheless executing formula itself throws error. i don't exercise any biased methods class, zero duty there. i restart debugger, problem goes away, wholly behind it's conduct again incidentally few hours later. some-more critically, i bug blunder logs app controlling production.
i ton linq app, opposing dozen opposite entities database, nonetheless i wholly problem queries associated specific entity table. googling suggested problem competence associated an crude charge specified between denote another entity, nonetheless i don't have any family object. seems operative 95% time, it's only 5% fail.
i have totally deleted vigilant designer, re-added "refreshed" server browser, repair problem.
any ideas what's going here?
here's full blunder summary smoke-stack trace:
index out range. contingency non-negative reduction distance of
collection. parameter name: index at
system.data.linq.sqlclient.sqlprovider.execute(expression query,
queryinfo queryinfo, iobjectreaderfactory factory, object[]
parentargs, object[] userargs, icompiledsubquery[] subqueries, object
lastresult) at
system.data.linq.sqlclient.sqlprovider.executeall(expression query,
queryinfo[] queryinfos, iobjectreaderfactory factory, object[]
userarguments, icompiledsubquery[] subqueries) at
system.data.linq.sqlclient.sqlprovider.system.data.linq.provider.iprovider.execute(expression
query) at
system.data.linq.table1.system.linq.iqueryprovider.execute[tresult](expression1 source,
expression) at
system.linq.queryable.firstordefault[tsource](iqueryable
expression`1 predicate) during myproject.finduserbytype(string typeid)
edit: requested, next duplicate list schema.
create list [dbo].[container](
[id] [int] identity(1,1) null,
[marketcode] [varchar](max) collect sql_latin1_general_cp1_ci_as null,
[description] [varchar](max) collect sql_latin1_general_cp1_ci_as null,
[capacity] [int] null,
[volume] [float] null
imprisonment [pk_container] primary pivotal clustered
(
[id] asc
)with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off, allow_row_locks = on, allow_page_locks = on) [primary]
) [primary]
edit: smoke-stack snippet shows firstordefault, nonetheless i repetitious blunder controlling both take() tolist(). smoke-stack snippet relating between these, simply interchangnig firstordefault/take/tolist. pierce down smoke-stack sqlprovider.execute fact identical.
Comments
Post a Comment