[dba-VB] C# Databases without borders

David McAfee davidmcafee at gmail.com
Tue Jan 11 14:22:33 CST 2011


If the app is a single user app, you can also use C# and SQLCE.

You can pass the datasets to and from the user via a web service.

D



On Tue, Jan 11, 2011 at 12:12 PM, Stuart McLachlan
<stuart at lexacorp.com.pg>wrote:

> Three ways:
>
> Binary array stored in the application as a resource and do that analysis
> yourself on the array
> elements.
>
> SQLite - http://www.sqlite.org/
>
> Access mdb
>
> The  first  way is probably the optimum, but will require a bit more coding
> to do the analysus.
>
> With only 40,000 rows stored as a collection or array, the in-memory
> scanning and
> summation should be near instant ( at least it would be if I did it in
> Powerbasic <g>)
>
> --
> Stuart
>
>
> On 11 Jan 2011 at 10:58, jwcolby wrote:
>
> > I want to build a little application where I have a very simple zip
> > code table of about 40 thousand zip codes, with things like household
> > count, population count, lat and long.  My application would take
> > lists of zip codes and sum the population and household counts, count
> > the zips etc and put a count on the screen in a table format.
> >
> > I already do this using SQL Server to hold the zip code table.  I get
> > the zip lists into csv files, then create a table inside of SQL
> > Server, join on the zip code and sum the population and household
> > counts.
> >
> > Now I want to build an application to do this but SQL Server is way
> > overkill.
> >
> > Can I use a csv or even xml to hold the zip table, create an xml table
> > to hold the zip lists entered by the user and so forth.  IOW I need a
> > low impact alternative to SQL Server.  Even express is just way
> > overkill for this.
> >
> > Somewhere in the back of my mind I am thinking that ADO.net knows how
> > to load tables, create relationships between tables, enforce the join
> > etc.  IOW do the store entirely in XML and just use ADO to do the
> > rest.
> >
> > Is this possible?  Would the speed be acceptable for a join between
> > tblZipMaster and tblZipUserXyz on Zip count(zip) sum(household) etc.
> > directly in memory. -- John W. Colby www.ColbyConsulting.com
> > _______________________________________________ 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
>
>



More information about the dba-VB mailing list