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

what about sqlite?  I know you're concerned with scaling up, but you'd also
want a smooth install for your game that doesn't step over anyone else's
copy of sql express

http://code.google.com/p/csharp-sqlite/

-Francisco
http://bit.ly/sqlthis   | Tsql and More...
<http://db.tt/JeXURAx>




On Mon, Jan 16, 2012 at 09:37, jwcolby <jwcolby at colbyconsulting.com> wrote:

> The thing is that I am eventually shooting for a system where the game can
> play over the internet or over a local LAN so it would be inconvenient to
> use a single user database and then have to upgrade to a multi-user
> database.
>
> I am trying to figure out WCF to see if I can build it using a WCF
> service.  Mostly just to try and wrap my mind around using WCF.  I read the
> first parts of a book (WCF Step by Step - John Sharp) but my mind resisted
> the wrap last time.  ;)
>
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 1/16/2012 11:52 AM, David McAfee wrote:
>
>> 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<http://www.microsoft.com/download/en/details.aspx?id=7400>
>>>
>>> HTH!
>>> Dan
>>>
>>> -----Original Message-----
>>> From: dba-vb-bounces@**databaseadvisors.com<dba-vb-bounces at databaseadvisors.com>
>>> [mailto:dba-vb-bounces@**databaseadvisors.com<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://databaseadvisors.com/mailman/listinfo/dba-vb>
>>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>>>
>>> ______________________________**_________________
>>> dba-VB mailing list
>>> dba-VB at databaseadvisors.com
>>> http://databaseadvisors.com/**mailman/listinfo/dba-vb<http://databaseadvisors.com/mailman/listinfo/dba-vb>
>>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>>>
>>>
>>>  ______________________________**_________________
>> dba-VB mailing list
>> dba-VB at databaseadvisors.com
>> http://databaseadvisors.com/**mailman/listinfo/dba-vb<http://databaseadvisors.com/mailman/listinfo/dba-vb>
>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>>
>>
>>
> ______________________________**_________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/dba-vb<http://databaseadvisors.com/mailman/listinfo/dba-vb>
> http://www.databaseadvisors.**com <http://www.databaseadvisors.com>
>
>