Ways of accessing MySQL from C#/WPF

Question

Hi,

I'm new at WPF and C# and I'd like to know the best way of accessing MySQL.

Googling a little bit I've seen there's a Linq provider for MySQL. Is that the best way? http://code2code.net/DB_Linq/

I've never used Linq before so I'll start today unless somebody knows a better way of doing that.

Thanks in advance

Answer 1

Why not use NHibernate?

/Broken record.

Answer 2

It depends! If I were coaching someone who was just starting out, I wouldn't start them out on LINQ. You said you were just starting with C#, but maybe you have some depth in other environments, particularly with databases and maybe you are familiar with ORM. IF that is true, then by all means dive head first into LINQ. If not, then I'd suggest using ADO.NET for your database access in your first projects - it is simpler to start with and is somewhat foundational for other alternatives.

Answer 3

You should use the official MySQL ADO.NET provider. Version 6.0 introduces basic support for Entity Framework