Connecting to a database using a WPF application

Question

I've started getting into WPF not so long ago.
As I'm in the stage of learning MVVM, I'm using THIS tutorial.

Following that tutorial I now have a basic project that involves products.
The next thing I want to do, is learn how to connect to a database and store/retrieve information from it.

My question is, what are the available ways to connect to a database? what is the best, efficient way to do it?

Also, can WPF applications connect to an hosted mysql database (the ones used for websites)?

I'm using VS2012 if that makes any difference.

Excuse my newbie-ness! I'm still just a beginner! Thank you in advance!

Yes they can, just like any other .NET application: Connecting to MySQL Database using C# and .NET - there's plenty of tutorials online, did you check any? — k.m
– k.m, Commented Jan 1, 2013 at 15:25
Consider using the EntityFramework, it should work with MySql as well, although i never tried that for myself. Search for EntityFramework and MySql. — Jobo
– Jobo, Commented Jan 1, 2013 at 15:33
I agree with the previous comments, use Entity Framework for simplicity's sake. I want to add that I recommend you take a "code first" approach, because it is easier to start with, and because that's the direction the future releases of EF are headed. I'm using it and it's great. — Hannish
– Hannish, Commented Jan 1, 2013 at 17:51
-1 What does DB have to do with WPF? Your question needs to be more specific. — Dave Hillier
– Dave Hillier, Commented Jan 1, 2013 at 18:16
Hmm basically, I need to know how to retrieve/store information in a database from my application. I don't know of any other usage so I thought it was clear enough... editing — Asaf
– Asaf, Commented Jan 1, 2013 at 18:46

NoName · Accepted Answer · 2014-04-24 20:28:09Z

2

Setting up Entity Framework takes too long + Compatibility issues, thus not efficient. Use this:

 SqlConnection connection = new SqlConnection
 {
      ConnectionString = ConfigurationManager.ConnectionStrings["Connection_String_Name"].ConnectionString
 };

 connection.Open();

 SqlCommand cmd = new SqlCommand("Query_For_What_You_Wanna_Do");
 cmd.ExecuteNonQuery();

 connection.Close();

answered Apr 24, 2014 at 20:28

NoName

10.4k6 gold badges40 silver badges59 bronze badges

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

Comments

Jobo · Accepted Answer · 2013-01-01 19:13:56Z

1

Check this: EF code first with oracle, mysql, etc.

At the end, there is download link for a sample.

As for WPF, i would recommend to read some tutorials if you´re not familiar with it. Searching for WPF and EF together will lead to a lot of more or less helpful tutorials and blogs, etc. But i would recommend playing around with the Entityframework and the code-first approach first.

answered Jan 1, 2013 at 19:13

Jobo

1,0847 silver badges14 bronze badges

1 Comment

Asaf Over a year ago

Yep, that's what I WAS doing until now... I think it's about time to get my hands dirty and have some fun with it... EF it is then!

Collectives™ on Stack Overflow

Connecting to a database using a WPF application

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related