tags:

views:

146

answers:

1
Q: 

In-Memory SQL-CE

Is there a way to connect to a SQL-CE database as a stream?

Specifically, our ASP.Net application builds small SDF at runtime for off-line needs. When the user is done with his off-line duties, he uploads the SDF and the application imports the new and updated data. No problems there.

Currently, we're saving the uploaded SDF to the web-server's hard-drive and connecting to the file. Can we connect to the uploaded SDF without saving it to the hard-drive? We are using the DbProviderFactory.CreateConnection method, but we're open to suggestions.

+1  A: 

You must open SQL CE from a file location. Maybe you can use a RAM drive or similar?

 2009-09-25 13:22:40

related questions

With System.Data.SQLite how do you specify a database file in the connect string using a relative path
Connections will not close when using Transaction Binding=Explicit Unbind; in connection string
Sql Server 2005 only accessible in ASP.NET 1.1 when I specify protocol and port
What is the connection string for odbc connections?
Accessing SQL on a different port number (classic ASP connection string)
Where does ConfigurationManager ConnectionStrings get its value?
Connection string hell in .NET / LINQ-SQL / ASP.NET
Abstracting data connection layers and presentation layers in an enterprise application
Connect MS Access to SQL Server Compact database using ADO
SQL Reporting Services DataConnection Update
How do I set the login info for SQL Server 2008 in Entity Framework?
Are there any classes (or methods) that can create a formatted connection string, given a provider name and user id, password etc?
C# Retrieving correct DbConnection object by connection string
How can I connect to an Oracle database as SYS using an ADO connection string?
Is there a difference between (local), '.' and localhost?
How do you specify the port number in a oledb connection string to SQL server 2005?
Point ADO.Net DataSet to different databases at runtime?
Connectionstring error after encypted using aspnet_regiis.exe
OLEDBConnection.Open() generates 'Unspecified error'
Prompt for Database Connection String
Runtime Configuration in .Net (specifically the EntLib)
[ADO.NET] What's the deal with |Pipe-delimited| variables in connection strings?
Fast database access test from .Net
SharePoint - Connection String dialog box during FeatureActivated event
What is the best way to store connection string in .NET DLLs?