Creating an SQL Compact file: Template or script?

Posted by David Veeneman on Stack Overflow See other posts from Stack Overflow or by David Veeneman
Published on 2010-03-21T15:27:38Z Indexed on 2010/03/21 15:31 UTC
Read the original article Hit count: 325

Filed under:

sqlce

|

sqlcompact

I am writing an application that writes to SQL Compact files that have a specific schema, and I am now implementing the New File use case. The simplest approach seems to be to use a Template pattern: first, create a template file that lives in the application directory. Then, when the user selects New File, the template is copied to the name and destination specified by the user in a New File dialog.

The alternative is a scripted approach: Use the same New File dialog, but dispense with the template file. Instead, create an empty SQL Compact file using the name/destination specified by the user, and then execute a T-SQL script on it from managed code.

At this point, I am leaning toward the Template approach, because it is simpler. Is there any reason I should not use that approach? Thanks for your help.

© Stack Overflow or respective owner

Related posts about sqlce

Importing Excel to SQLCE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table in excel format (2007 but I can save as anything below that, naturally), and I have an SQL Compact Edition 3.5 SP1 Database table with corresponding columns. I simply want to populate the SQLCE table with the data from the excel file. The data consists of strings and integers only. I… >>> More
Creating and Indexing Email Database using SqlCe

as seen on Stack Overflow - Search for 'Stack Overflow'
I am creating a simple email client program. I am using MS SqlCe as a storage of emails. The database schema for storing the message is as follows: StorageId int IDENTITY NOT NULL PRIMARY KEY, FolderName nvarchar(255) NOT NULL, MessageId nvarchar(3999) NOT NULL, MessageDate datetime NOT NULL, StorageData… >>> More
sdf file (sqlce) not copying to emulator

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with copying sdf file to WM emulator. My solution structure MyApp.DataLayer - there is sdf file MyApp.WMUI - this is windows mobile winform app sdf file has set build action: content copy to output directory: copy always But if I deploy app to emulator, that sdf file doesn't… >>> More
SqlCe Connection count

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to determine the number of connections say a windows application has open with SqlCe? >>> More
How to check if sqlCE is installed on Windows CE

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I check if sqlCE is installed on Windows CE (in C#)? >>> More

Related posts about sqlcompact

No SQLCompact Edition Support IN VS 2013

as seen on Programmers - Search for 'Programmers'
Firstly apologies if this is a poor question - I am an engineer not a programmer. I have spent time moving from Visual Basic to C#. I have started C#/SQL tutorials. I have noticed VS 2013 has stopped supporting the compact edition database normally used for standalone desktop apps. Somebody has kindly… >>> More
Get id when inserting new row using TableAdapter.Update on a file based database

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database table with one field, called ID, being an auto increment integer. Using a TableAdapter I can read and modify existing rows as well as create new ones. However if I try to modify a newly inserted row I get an DBConcurrencyException: OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft… >>> More
Using Entity Framework with an SQL Compact Private Installation

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of SQL Compact with my application, so that my installer can install SQL Compact without giving the user a second installation to do. It also avoids versioning hassles down the road. My development… >>> More
Linq to SQL and SQL Server Compact Error: "There was an error parsing the query."

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a SQL server compact database (MyDatabase.sdf), and populated it with some data. I then ran SQLMetal.exe and generated a linq to sql class (MyDatabase.mdf) Now I'm trying to select all records from a table with a relatively straightforward select, and I get the error: "There was an… >>> More
Open Connection to SQL Compact File, with other Extension than .sdf

as seen on Stack Overflow - Search for 'Stack Overflow'
I just can't open this connection, if the Extension is different than .sdf. It's there a workaround (Please do not suggest, changing the extension of the File temporarily) ? Thnk u very much. Javier >>> More