[dba-VB] C# - using SQL Server Express

Take a look at SQL Compact.  It's a MS product, and designed to be embedded
into the assembly of a C#/VB.Net app.  

It's the equivalent of using local tables in an Access front end.

If you need your gamers to be able to use a common database, then SQL
Compact won't work for that, but you could still use SQL Compact for local
data and Express for common data.

http://www.microsoft.com/download/en/details.aspx?id=7400

HTH!
Dan

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, January 16, 2012 10:14 AM
To: VBA
Subject: [dba-VB] C# - using SQL Server Express

I have been working on a small game, for which I need a database.  It will
be a single or multi-player game which means I need to be able to create a
database and install SQL Server Express (for the standalone game) or connect
to an database (for the multi-player game).  While I am reasonably
conversant in databases, I have never had a C# program install SQL Server
Express.

Once Express is installed, should I ship an empty database?  Should I
generate scripts to create the tables and autofill the lookup tables?

So much to know, so little time.
--
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com