I was playing with the FileStream goodness in MSSQL 2008 and then I
got hit with a 2005 project. So, can anyone recommend a good strategy
for doing CRUD on images? I have several hundred thousand images to
keep and maintaining a link to a physical file is not sufficient in my
project's case.

Thanks.

SnapDive (SnapDive (AT) community (DOT) nospam) writes:
I have a very basic example that I got from SQL Server Magazine on
my web site: http://www.sommarskog.se/blobload.txt.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

That looks pretty cool. My problem is that is does not use LINQtoSQL
or Entity Framework to SQL like the rest of the codebase. I'm
websearching around for alternatives, so far coming up dry.

Thanks Erland!




On Mon, 24 Aug 2009 21:31:26 +0000 (UTC), Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Does this help you?
http://www.simple-talk.com/sql/sql-t...er-filestream/

"SnapDive" wrote:

SnapDive (SnapDive (AT) community (DOT) nospam) writes:
I don't work with either, so I cannot really give any suggestions. But both
LINQ and EF has restrictions with what you can use in SQL Server. For
instance, I learnt last night that you cannot use table-valued parameters
with LINQ or EF.

I would really expect them to deal with varbinary(MAX), though.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Sorry, that doesn't help. I need to use LINQ-to-SQL or Entity
Framework and MSSQL 2005, not 2008. 2008 would be easy.

Thanks.


On Mon, 24 Aug 2009 19:39:01 -0700, Jacob Sebastian <Jacob
Sebastian (AT) discussions (DOT) microsoft.com> wrote: