Stuart McLachlan
stuart at lexacorp.com.pg
Fri Jan 27 16:17:25 CST 2012
If you use SQLite, when you from single user to mult user, you could use SQLitening which is a client/serwer wrapper to to the SQLLite DLL: http://www.planetsquires.com/sqlite_client_server.htm (it just happens to be developed entirely in PowerBasic <g>) -- Stuart On 27 Jan 2012 at 8:01, Francisco Tapia wrote: > 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> > > > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > -- Stuart McLachlan Ph: +675 340 4392 Mob: +675 7100 2028 Web: http://www.lexacorp.com.pg