Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best DB To Use
Message
From
10/02/2010 15:00:43
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
ASP.NET
Category:
Databases
Title:
Miscellaneous
Thread ID:
01448575
Message ID:
01448641
Views:
77
>>>>>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.
>>>>
>>>>SQL is as easy an option as Access.
>>>
>>>How do you figure? SQL has to be installed. I can just copy the VFP tables to the Data folder and access it using .Net's oleDb driver.
>>
>>Or you could put it all on sticky notes and paste it on the monitor <bg>
>>
>>SQL Express takes a few minutes to install and is a real database. Attaching and detaching databases is really quite simple. Give it a try. If you're moving from Access to C# I don't see where VFP should even play a role.
>
>I see any form of SQL as more overhead than necessary. Getting a DB on this guy's PC is as easy a copy & paste with VFP. No setup wizard. No multiple forms of connection strings with a VFP DB in a folder called 'Data' under the app folder. With SQL. Seems a whole lot more simple to me.

Kevin there are some issues with VFP and dot net to learn to get around. I use VFP extensively in a windows application but really wish it wasn't. I works great and the speed is great too but the development side for some things is a pita. I mentioned it before but take a look at VistaDB as it is a dot net integrated database. It isn't free though so the best free option is SQL CE.
Timothy Bryan
Previous
Reply
Map
View

Click here to load this message in the networking platform