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

I second Dan's comment, if you are using it only to store data for a single
user.



On Mon, Jan 16, 2012 at 8:36 AM, Dan Waters <df.waters at comcast.net> wrote:

> 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
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>