DevForce Community Forum : How to compare byte data http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : How to compare byte data Thu, 15 Oct 2026 15:35:37 -700 Fri, 01 Jul 2011 09:56:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2785 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ How to compare byte data : What exactlyis the issue you're... http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11159#11159 Author: sbelini
Subject: 2785
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.
]]> Fri, 01 Jul 2011 09:56:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11159#11159 How to compare byte data : HI,Thanks for your quick replay.Now... http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11135#11135 Author: vinothvdp
Subject: 2785
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.


]]> Tue, 28 Jun 2011 07:24:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11135#11135 How to compare byte data : Hi vinothvdp,It appears, that... http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11059#11059 Author: sbelini
Subject: 2785
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
http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/f90dec50-acc7-4157-8927-acb246ec3572
http://data.uservoice.com/forums/72025-ado-net-entity-framework-ef-feature-suggestions/suggestions/1050327-linq-support-for-comparison-of-varbinary-columns?ref=title
 
Regards,
   Silvio.
]]> Tue, 21 Jun 2011 12:45:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11059#11059 How to compare byte data : Hi,How to use where condition... http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11054#11054 Author: vinothvdp
Subject: 2785
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.


]]> Tue, 21 Jun 2011 07:09:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2785&PID=11054#11054