A strange problem!

Question

0.00/5 (No votes)

See more:

Hello everyone;
I have a strange problem and that a project using LINQ TO SQL and SQL Server 2005 Express by VS2008 as my two-layer implementation. In this way the Data Layer with LINQ TO SQL worked. But the problem there is that every 10 times I run the program, the program with an error of about 3 times and 7 times runs without error. For example, some forms running time gives the following error:

The server failed to resume the transaction. Desc:3400000007

Or run the following command:

var q = from p in PData.Customers
select p.Custom_ID;

if (q.Count() != 0)
{
    :.
}

q.Count() command takes this error:

Specified cast is not valid.

Whether the problem is LINQ, which is sometimes a problem or bug is from somewhere else?

Solutions anyone knows this problem?

Thanks.

Posted 29-Jun-10 4:15am

ehsan110121

Add a Solution

Comments

Johnny J. 29-Jun-10 10:58am

Just an idea: could q.Count() be Null?

ehsan110121 30-Jun-10 6:02am

Hello;
No, not null.
Thank you for your attention.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Adrabi Abderrahim · Answer 1 · 2010-06-29T06:17:00

Solution 1

this is all in you ASP.Net page ?

var q = from p in PData.Customers
select p.Custom_ID;

if (q.Count() != 0)
{
    :.
}

maybe this is a memory leak!try to limit source code for centralizing problem & monitor your PC memory.
shutdown Server SQL and restart.
also try to use manually Connection.Open()/Close/()Connection.BeginTransaction/... (for testing)

Posted 29-Jun-10 6:17am

Adrabi Abderrahim

Comments

ehsan110121 30-Jun-10 6:17am

Hello;
My program is a WindowsFormApplication and my PC memory is 2.5G.
Only 30% when this happens.
Thank you for your attention.

Adrabi Abderrahim 30-Jun-10 6:41am

can you please! give us source code for this problem (just simple project with table that causes this problem).
I want test it, for seeing this problem in action ^_^.