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

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



More information about the dba-VB mailing list