Intrebari generale

Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

ignatandrei — Wed, 18 Nov 2009 17:38:33 GMT

crestinul:
ignatandrei:
ce pot sa zic e ca 2100 e by default
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
Dar cum naiba ai facut asa ceva ? L2S sau EF?

Cu linq2sql functia Contains a arrayului ala mare

Ok, poti face asa : daca numarul de parametrii sunt > 2000, inserezi intr-o tabela si chemi o SP in care faci diferenta...

Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

crestinul — Wed, 18 Nov 2009 16:27:21 GMT

ignatandrei:
ce pot sa zic e ca 2100 e by default
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
Dar cum naiba ai facut asa ceva ? L2S sau EF?

Cu linq2sql functia Contains a arrayului ala mare

Re: exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

ignatandrei — Wed, 18 Nov 2009 15:15:48 GMT

ce pot sa zic e ca 2100 e by default
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Poti sa mai combini din parametri (intr-un xml, de ex ) ca sa ai mai putin de 2100
Dar cum naiba ai facut asa ceva ? L2S sau EF?

exp = {"The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100."}

crestinul — Wed, 18 Nov 2009 15:05:25 GMT

Exista vreun workaround la eroarea asta.Idee este ca ,query-ul meu generat de linq2sql are un where cu "In" in care sunt mai mult de 2100 de parametriu ceva de genul:
WHERE [t8].[ElementID] IN (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24, @p25, @p26, @p27, @p28, @p29, @p30, @p31, @p32, @p33, @p34, @p35, @p36, @p37, @p38, @p39, @p40, @p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51, @p52, @p53, @p54,

Multumesc