Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Learning databases and accesing them using C# , advices?
New Posts  All Forums:Forum Nav:

Learning databases and accesing them using C# , advices?

post #1 of 6
Thread Starter 
Hello,so i have been working in C++ 4-5 months and now i"m on C# for about 3-4 and i see i need databases for almost every application i have in mind. I have allready watched 3-4 hours of video tutorials about bases ( a microsoft access course) and now i know how to work with access but now i need something to comunicate with base from C# program. I first got advices for SQL but lots of my friends told me that even today after 4-5 years of programming and making applications they still don"t need SQL.That LINQ is perfectly fine. My friend was explaining to me that LINQ communicates with a collection and collection automaticaly uses SQL to communicate with base. By learning SQL i get some advantages and more abilities but knowing just LINQ is probably enough,at least for now. So could somebody explain me what did he mean by "collection" and should i start learining SQL right away? what have you personally done?
post #2 of 6
learn sql and ignore access
learn mysql or mssqlserver

btw. what they programmin without sql, hello world thumb.gifbiggrin.gif:D
post #3 of 6
Thread Starter 
well then i must have misunderstood something.They are living from programming. Btw what do you mean by ignore access? what should i be making my bases in?
post #4 of 6
Quote:
Originally Posted by athlon 64 View Post

... I first got advices for SQL but lots of my friends told me that even today after 4-5 years of programming and making applications they still don"t need SQL.That LINQ is perfectly fine. My friend was explaining to me that LINQ communicates with a collection and collection automaticaly uses SQL to communicate with base. ...

They're talking about using LINQ to SQL. If you plan on doing anything professionally, learn some SQL.
TheHydra
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 860 @ 3.6 EVGA P55 FTW Sapphire TOXIC 2GB 6950 CORSAIR XMS3 4 x 2GB CMX4GX3M2A1600C7 
Hard DriveOSKeyboardPower
C300 64Gb + 2x F3 HD103SJ 1TB in RAID 0 Win7 x64 Razer BlackWidow Corsair 750HX 
CaseMouseMouse Pad
Lian Li A05NB with 140mm top fan. Razer DeathAdder Razer Kabuto 
  hide details  
Reply
TheHydra
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 860 @ 3.6 EVGA P55 FTW Sapphire TOXIC 2GB 6950 CORSAIR XMS3 4 x 2GB CMX4GX3M2A1600C7 
Hard DriveOSKeyboardPower
C300 64Gb + 2x F3 HD103SJ 1TB in RAID 0 Win7 x64 Razer BlackWidow Corsair 750HX 
CaseMouseMouse Pad
Lian Li A05NB with 140mm top fan. Razer DeathAdder Razer Kabuto 
  hide details  
Reply
post #5 of 6
Thread Starter 
Quote:
Originally Posted by blangblang View Post

They're talking about using LINQ to SQL. If you plan on doing anything professionally, learn some SQL.

yeah,exactly, i just watched 10"th video in pluralsight LINQ course (seems easy) and yeah they are talking about LINQ to SQL, i will learn some SQL but i"ll play with LINQ for now wink.gif
post #6 of 6
I don't think you're going to run into a lot of places that use LINQ to replace actual SQL queries. Especially if you're working on a codebase older than 2-3 years it won't even be an option.

LINQ is neat and can be useful, but learning how to use parameterized queries and learning to write SQL is a much more valuable skill when you have to work with a DB.
Hexafun
(9 items)
 
  
CPUMotherboardGraphicsRAM
i7 8700k ASRock Fatal1ty Z370 Gaming-ITX/ac EVGA GTX 980 CORSAIR Vengeance 3733MHz 
Hard DriveCoolingOSPower
Samsung 960 Pro 2TB Corsair H100i v2 Windows 10 Pro Corsair AX850 Gold 
Case
Fractal Design Nano S 
  hide details  
Reply
Hexafun
(9 items)
 
  
CPUMotherboardGraphicsRAM
i7 8700k ASRock Fatal1ty Z370 Gaming-ITX/ac EVGA GTX 980 CORSAIR Vengeance 3733MHz 
Hard DriveCoolingOSPower
Samsung 960 Pro 2TB Corsair H100i v2 Windows 10 Pro Corsair AX850 Gold 
Case
Fractal Design Nano S 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Application Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › Application Programming › Learning databases and accesing them using C# , advices?