Access Database C#
I want to have some tips. I have worked on SQL databases in c# but i am developing a new small level application that only has to store some contact numbers so i planed for access because SQL will be overkill so i have never been to access database. How to Add access database file --> there is no file to add when I add new item to solution Consumption is same with a bit changes as that of SQL? like
"SELECT * FROM USERS WHERE uName=@username"
Why Don't you try using SQL lite or SQL CE? These use a file-base approach to store your data (ie they put a file in your app_data folder, as I think you want with access).
While I completely agree with Jaime on SQL Lite and SQL Compact Edition and back him up thoroughly, to answer your question, there will not be an Access Database to be added to the project from Visual Studio. However you can simply create an Access Database from Microsoft Access and manipulate it from C#. If you have previous experience in SQL Server, this would be very easy. Most of the objects and methods that you used from System.Data.SqlClient would be replaced by System.Data.OleDb. And yes you can use SQL syntax to interact with the database. As for the connection string to use, refer to Connection Strings for Access 2007