tag:blogger.com,1999:blog-11847577.post6836543899535720142..comments2024-02-12T13:07:53.582+00:00Comments on Native Mobile: Detecting the installed SQL Compact OLE DB providersJoão Paulo Figueirahttp://www.blogger.com/profile/01808451986712386444noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-11847577.post-48445522822463330002008-12-30T10:14:00.001+00:002008-12-30T10:14:00.001+00:00That should say "streaming blobs" not "streaming b...That should say "streaming blobs" not "streaming blogs"Unknownhttps://www.blogger.com/profile/05473808927844570766noreply@blogger.comtag:blogger.com,1999:blog-11847577.post-52596189114924639902008-12-30T10:14:00.000+00:002008-12-30T10:14:00.000+00:00Hi,I was wondering if you could expand a bit about...Hi,<BR/><BR/>I was wondering if you could expand a bit about different native vs managed SQL Server engines. <BR/>There is currently a bug in the managed ADO.NET provider for SQL CE that prevents streaming blogs out of a database. There is some information about it <BR/><BR/>here:<BR/><BR/>http://stackoverflow.com/questions/399719/hacky-sql-compact-workaround<BR/><BR/>and<BR/><BR/>here:<BR/><BR/>http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/3cce86b2-9866-4f91-b8c8-57b7e7af0b98/<BR/><BR/>There is a hacky workaround I have that uses reflection to update private fields.<BR/><BR/>This, of course, isn't something I want to ship, because I don't want Windows Update to break my app on my customer's machines.<BR/><BR/>I was thinking I could use the native interfaces to access the database and stream the data that I need. It's important, for perf reasons, that I stream blobs out of the database rather than buffer them.<BR/><BR/><BR/>In reading your blog post, which talks about the native stack using a different engine from the managed stack, I was thinking this might not be possible.<BR/><BR/>SQL CE does not allow two processes to access the same DB concurrently. Do you know if 2 different engines in the same process will behave the same as 2 seperate processes? If they do, then I can't use the native workaround I was thinking of.<BR/><BR/>Thanks.Unknownhttps://www.blogger.com/profile/05473808927844570766noreply@blogger.com