Access database with C#

Question

I want to make a simple C# console program that gets its informations from a database made by Microsoft Access so, i want to learn how to use Microsoft Access to make a database linked with Visual Studio and how to use C# to get data from it .
What resources do you recommend me Most?

Note : I have zero experience with Microsoft Access.

Answer 1

Bono MS Access should have a tool you can use to build or modify a given SQL query. However, that's probably not what you had in mind.

Ultimately, it depends on how simple or complex your database design is.

Code First EF will allow you to focus on writing code which then is used to infer a table structure to match the data that will be reflected in the code. EF will help with builtin or code generated methods to create, read, update, and delete data in the database.

That said, I do recommend you spend a little time understanding SQL. The SL course here is basic. But it should be good enough to get you thinking about the right way to approach db designs and table definitions.

Answer 2

https://www.guru99.com/c-sharp-access-database.html

Answer 3

Bono Do you have experience with other relational databases like SQL Server Express, MySQL, or PostgreSQL?

Is there a specific reason why you need to use MS Access?

Do you have experience with SQL and stored procedures?

Do you have experience with DB First or Code First EF (Entity Framework) and / or LINQ in C#? If so, do you have a preference?

Or you can use the traditional libraries DAO or ADO.

Hopefully I've presented some triggered some ideas you can continue to research on the internet.

Answer 4

as far as I know this is the most popular and distributed database. start training with it, although if you are facing a specific task, then it is already necessary to start from it. selecting the database type will then be secondary. since each database has its own features pros and cons

Answer 5

Ярослав Вернигора (Yaroslav Vernigora) and David Carroll from your answers i deduced that i should have some experience with SQL right?

And i am wandering if SQL lesson in Sololearn is enough

And i wanted to use MS Access as i thought that i won't need to code for the database.

I am using C# without any Farmeworks or libraries

Answer 6

but to Microsoft access met nowhere else I have ever seen. unless only as a training base or in organizations where they try to create their database without the involvement of a programmer, on their own

Answer 7

My personal experience is that SQL Server, with the Sql SQl Server management studio or MariaDB with HeidiSQL as database manager.
Are easy to learn. Do not feel intimidated by there unlimited features. Just learn what you need to do to get your self going.

SQL express
https://www.microsoft.com/nl-nl/sql-server/sql-server-2017

or MariaDB (read MySql)
https://downloads.mariadb.org/

Access is less and less available since it is no longer part of the MS office.

The 2 database management systems I mentioned above are free.

So with basic knowledge and a bit of youtube, you will be fine.

Also Access does have know limitiations when the database increase in size and multi-user.

Do not be afraid of database coding.
Just keep well defined questions, like this one.