File retrieve from Database using C# Linq.

Question

0.00/5 (No votes)

See more:

I want to retrieve Image file from database with linq

C#

var pict = db.FUNC_GET_PERSON_IMAGE_BY_ID(Convert.ToInt32(id));

C#

var _PersonImages =db.PERSON_IMAGEs.Where(item=>item.PERSONIMAGE==(Convert.ToInt32(id)))

but error occurred timeout expired?

Posted 31-Dec-12 6:29am

Yaseer Arafat

Add a Solution

Comments

rahkan 31-Dec-12 13:04pm

have you stepped through the code with the debugger? It should tell you what the error is when you use the debugger. One thing you might try, though, is to set a variable using the Convert.ToInt32(id) and use that variable in the linq statement. I can't remember right off hand if linq knows how to handles the Convert.ToInt32 or not

Yaseer Arafat 31-Dec-12 13:19pm

I have user Convert.ToInt32(id) in several times .It only get trouble with byte[] type file

CHill60 31-Dec-12 13:53pm

Can you amend your question to post the connection string you're using ... the image is probably quite large so you may need to increase the timeout on the connection

Yaseer Arafat 1-Jan-13 12:39pm

Yes.These image are screenshot of Active window

2 solutions

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)

**Zoltán Zörgő** · Answer 1 · 2012-12-31T08:00:00

Solution 1

Here is an article and sample code about using the Binary Class[^]: http://erikej.blogspot.hu/2009/11/how-to-save-and-retrieve-images-using.html[^].

Posted 31-Dec-12 8:00am

Zoltán Zörgő

Manas Bhardwaj · Answer 2 · 2012-12-31T08:10:00

Solution 2

Linq has (likely) nothing to do with the timeout error you are getting.

Please do a google search[^] to look how to increase the timeout (if required).

Posted 31-Dec-12 8:10am

Manas Bhardwaj