MYSQL or MSQL with C#?
MYSQL or MSQL with C#?
I want to learn a database language best suitable with C# I have been considering either MYSQL or MSQL any suggestions? any help would be much appreciated
-
- Registered User
- Posts: 20576
- Joined: 19 Sep 2003, 02:00
- Location: Bloodbank
-
- Registered User
- Posts: 14338
- Joined: 04 Sep 2004, 02:00
- Processor: i386DX Sooper
- Motherboard: A blue one
- Graphics card: A red one
- Memory: Hard drive
- Location: On a Möbius strip
- Contact:
Re: MYSQL or MSQL with C#?
MySQL works great with C# for simple databases.
If I weren't insane: I couldn't be so brilliant! - The Joker
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
Re: MYSQL or MSQL with C#?
That's kind of like asking "should I get Coke, Coke Light or Coke Zero with my order of Steers?". From a programming perspective, they're pretty much similar; the differences are generally more important to sysadmins and dbadmins than developers.Craig944 wrote:I want to learn a database language best suitable with C# I have been considering either MYSQL or MSQL any suggestions? any help would be much appreciated
Having said that, C# and MSSQL play very nicely with each other, and I believe that the Express edition of MSSQL is free. It has severe limitations on it that make it unsuitable for production purposes, but for learning purposes it's fine.
Kia kaha, Kia māia, Kia manawanui.
Re: MYSQL or MSQL with C#?
Yeah, pretty much. The MSSQL Express Edition has a nice user-friendly GUI to help do things like drop/create databases, tables and the like. And I'll take a can of Tab thanks.Ron2K wrote: That's kind of like asking "should I get Coke, Coke Light or Coke Zero with my order of Steers?". From a programming perspective, they're pretty much similar; the differences are generally more important to sysadmins and dbadmins than developers.
In general, .NET and MSSQL "just work" as all the defaults are for MSSQL. That said, it's really, really, really easy to change to access another type database like MySLQ.Ron2K wrote: Having said that, C# and MSSQL play very nicely with each other, and I believe that the Express edition of MSSQL is free. ... for learning purposes it's fine.
+1 about the learning, see above for why,
Important Thread:
- Hey everybody, I have returned (2013) and I am not Dead.
- Explaining RAM - SDRAM, DDRx and GDDR
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: MYSQL or MSQL with C#?
Ditto the general consensus so far
C# is a MS language so why not learn MSSQL and keep it all in the family - it's a no-brainer
MSSQL has cool features like CLR and other application integration (get visual studio!) that makes for some potent abilities.
Of course you get none of this with the free version, but it's a great place to start learning the basics.
SQL being so standardised means that after learning T-SQL you'll be able to pick up another flavour fairly easily. Altho if you are used to the ease-of-use of Microsoft's offerings you will find MySQL to be uninspiring as a DBMS and to call it's DB engine primitive is being charitable.
And now that Oracle owns MySQL expect it go downhill fast as they encourage it's user base to switch to Oracle, or pay a truly exorbitant price for "MySQL Enterprise"... those two words are mutually exclusive in my book
C# is a MS language so why not learn MSSQL and keep it all in the family - it's a no-brainer
MSSQL has cool features like CLR and other application integration (get visual studio!) that makes for some potent abilities.
Of course you get none of this with the free version, but it's a great place to start learning the basics.
SQL being so standardised means that after learning T-SQL you'll be able to pick up another flavour fairly easily. Altho if you are used to the ease-of-use of Microsoft's offerings you will find MySQL to be uninspiring as a DBMS and to call it's DB engine primitive is being charitable.
And now that Oracle owns MySQL expect it go downhill fast as they encourage it's user base to switch to Oracle, or pay a truly exorbitant price for "MySQL Enterprise"... those two words are mutually exclusive in my book