New Posts New Posts RSS Feed: How to compare byte data
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

How to compare byte data
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
vinothvdp View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Sep-2007
Location: India
Posts: 27 		Post Options Post Options   Quote vinothvdp Quote  Post ReplyReply Direct Link To This Post Topic: How to compare byte data
    Posted: 21-Jun-2011 at 7:09am
Hi,

How to use where condition on byte data field, i have varbinary(50) database field,
how can use filter for this field?

Thanks in Advance.
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 735 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 21-Jun-2011 at 12:45pm
Hi vinothvdp,
It appears, that binary data field could not compared directly in Linq to Sql.
 
You might want to take a look at
 
Regards,
   Silvio.
Back to Top
vinothvdp View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Sep-2007
Location: India
Posts: 27 		Post Options Post Options   Quote vinothvdp Quote  Post ReplyReply Direct Link To This Post Posted: 28-Jun-2011 at 7:24am
HI,

Thanks for your quick replay.

Now i have issue,i need to pass byte[] data(scanned image) to procedure parameter, how can i pass this?

my procedure has varbinary(max) parameter how do i pass this value to sp?

My Procedure Is 

ALTER PROCEDURE [dbo].[imagematch](@match varbinary(max))
AS
BEGIN
select * from dbo.image  where cast(image1 as nvarchar(max))=cast(@match  as nvarchar(max))
END


Please help me out this...

Thanks in advance.
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 735 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 01-Jul-2011 at 9:56am
What exactly is the issue you're coming across?
 
You should be able to call
EntityManager.MyStoredProc(myByteArrayParameter).Execute()
 
You might want to take a look at the DevForce Resource Center section about StoredProc Queries. (there's also a sample/walkthrough here)
 
Silvio.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down