How to use a local database in c#?

Question

I've made a local database for a C# project: This is the local database I mean.

I know basic SQL commands, but haven't worked with databases in C#. What I'd like to know specifically is:

How to read from the database (query)
How to add and update rows

The database only consists of 3 tables, so I don't think anything fancy is needed.

The problem with this question is that it shows little to no effort in research. There is a myriad of ways you can access db data from c#, from the good 'ol open connection-query to ORM tools like EF or Hibernate. You should first figure out which technology you want to use and then come back here if you have trouble implementing it. — AJC
– AJC, Commented Oct 20, 2011 at 15:30

Mike Christensen · Accepted Answer · 2011-10-20 15:40:05Z

8

First, you should learn a bit about various technologies and APIs for connecting with a database.

The more traditional method is ADO.NET, which allows you to define connections and execute SQL queries or stored procedures very easily. I recommend digging up a basic tutorial on ADO.NET using Google, which may differ depending on what type of project you're creating (web app, console, WinForms, etc).

Now days, ORMs are becoming increasingly popular. They allow you to define your object model in code (such as every database table would be a class, and columns would be properties on that class) and bind to an existing database. To add a new row to a table, you'd just create an instance of a class and call a "Save" method when you're done.

The .NET framework has LINQ to SQL and the Entity Framework for this sort of pattern, both of which have plenty of tutorials online. An open source project I really like is Castle Active Record, which is built on top of NHibernate. It makes defining ORMs quite easy.

If you have specific questions about any of the above, don't hesitate to post a new question with more specific inquiries. Good luck!

Update:

I thought I'd also put in one last reference as it seems you might be interested in working with local database stores rather than building a client/server app. SQLite allows you to interact with local stores on the file system through SQL code. There's also a .NET binding maintained by the SQLite guys (which would in theory allow you to work with the other platforms I mentioned): http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

edited Oct 20, 2011 at 15:40

answered Oct 20, 2011 at 15:33

Mike Christensen

91.8k52 gold badges223 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jason Dufair Over a year ago

I second the use of Castle ActiveRecord. Have been using it for a couple of years and it allows me to develop more closely to the business domain.

Birey · Accepted Answer · 2011-10-20 15:30:28Z

2

You can use SQLCE.

This blog will give you a good start.

http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx

answered Oct 20, 2011 at 15:30

Birey

1,81216 silver badges20 bronze badges

Comments

G-Man · Accepted Answer · 2011-10-20 15:31:09Z

0

Here is a small tutorial that should be helpful to you.

You can make use of the SqlDataReader to read data

and the SqlCommand to Insert Update Delete rows from your tables.

http://www.dotnetperls.com/sqlclient

answered Oct 20, 2011 at 15:31

G-Man

7,25118 gold badges75 silver badges101 bronze badges

Comments

Shahid Syed · Accepted Answer · 2022-01-21 14:30:03Z

0

You could use it by adding following to your Startup.cs

services.AddDbContext<DemoDbContext>(options => options.UseSqlite("Filename=data.db"));

edited Jan 21, 2022 at 14:30

Shahid Syed

6394 silver badges16 bronze badges

answered Jan 20, 2022 at 20:52

programmingknight741

1

Collectives™ on Stack Overflow

How to use a local database in c#?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related