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?
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
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?
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
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
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
My System
(16 items)
 
  
CPUMotherboardGraphicsRAM
amd phenom x6 1055t (3.8ghz OC) - 1.5v asrock 890gx extreme 3 Gigabyte gtx660ti OC Kingston HyperX 4x4gb 
Hard DriveHard DriveOptical DriveCooling
Kingston hyperx 120gb Western digital caviar green 2TB somewhere in the basement Zalman 
OSMonitorKeyboardPower
Windows 8 Enterprise 64-bit Dell u2412m primary , u2311h secondary ducky dk 9008 shine 2 corsair tx650w 
CaseMouseMouse PadAudio
Fractal design define r4 (titanium grey) Hp razer gholiatus fragged AKG k512 mk2 
  hide details  
Reply
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.
Bladed Fury V2
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 @ 3.8GHz ASUS P6X58D-E EVGA/MSI GTX 470 SLI @870 Core/1900 Mem 18GB Mushkin/Corsair 
Hard DriveOSKeyboardPower
Samsung SSD 830 512GB Windows 8 Enterprise x64 Corsair K90 Corsair AX850 
Case
ATCS 840 
  hide details  
Reply
Bladed Fury V2
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 930 @ 3.8GHz ASUS P6X58D-E EVGA/MSI GTX 470 SLI @870 Core/1900 Mem 18GB Mushkin/Corsair 
Hard DriveOSKeyboardPower
Samsung SSD 830 512GB Windows 8 Enterprise x64 Corsair K90 Corsair AX850 
Case
ATCS 840 
  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?