Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best DB To Use
Message
De
11/02/2010 06:33:16
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Divers
Thread ID:
01448575
Message ID:
01448749
Vues:
68
>I'm working on a small MS Access to C# WinForms conversion project. I have to decide which database to use. The client will most likely want to take the data home, so SQL will not be an easy option.
>
>I could do it in Access, which he knows and I hate, or I could do it in VFP, which I know. It's going to be one of these two, as I'm not
>interested in learning another DB at this point.
>
>I guess I'm just looking for thoughts....

Kevin,
You are closing doors to other DBs and limiting to VFP and Access. Anyway let's think of it:
-It is a C# Winforms project
If it is a .Net project then VFP is not a good choice as data source. Access wins here.

Likely your project would grow soon, I would suggest think the future. If you do that then likely both VFP and Access would be phased out from the start. I would surely look into one that does have Entity Framework providers.

SQL Server, SQLite, Oracle, Firebird, ... are all easy to install and have EF support today (and express/free options). SQL Server CE database is a single file and have a small footprint. SQLite likewise needs to copy a single DLL. VFP and Access, OTOH both need OLEDB (and unlikely ODBC) drivers be installed before you can use from .Net (and even after they are installed they are unlikely to be the choice).

It is your decision anyway:)

PS: If you go to VFP/Access route strictly then choose Access keeping in mind that otherwise you would limit yourself to 32 bits.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform