Database Question
-
I'm looking to develop an application that will require a small database table structure (not more then 4-5 tables). I wanted to make the database internal to the application so that there wouldn't have to be a link out to a web server/SQL server anywhere, but with just receiving a new datafile to replace the old one, it would be able to pick it up. Is there any code/project type in Visual Studio that would allow me to create such a database that could be deployed with the application and be able to be queried with a SQL/Oracle type interface/query? I am open to writing the application in either Visual Basic or Visual C++.
-
I'm looking to develop an application that will require a small database table structure (not more then 4-5 tables). I wanted to make the database internal to the application so that there wouldn't have to be a link out to a web server/SQL server anywhere, but with just receiving a new datafile to replace the old one, it would be able to pick it up. Is there any code/project type in Visual Studio that would allow me to create such a database that could be deployed with the application and be able to be queried with a SQL/Oracle type interface/query? I am open to writing the application in either Visual Basic or Visual C++.
Sounds like SQL Server Compact Edition is the tool for you: http://www.microsoft.com/sql/editions/compact/default.mspx[^]
"It was the day before today.... I remember it like it was yesterday." -Moleman
-
Sounds like SQL Server Compact Edition is the tool for you: http://www.microsoft.com/sql/editions/compact/default.mspx[^]
"It was the day before today.... I remember it like it was yesterday." -Moleman