I've been trying to figure out how I can use LINQ to query a SQL Server database using C# for 2 days now. I've been through about a dozen tutorials but they all seem to lack that key step where you actually connect to a SQL Server database. I've been working in .NET and SQL Server for over 15 years now so it really shouldn't be this hard to figure out.
Now I feel like I'm losing my mind because I just read a tutorial where the guy sets up a database, then sets up his C# project with LINQ and then just starts dragging and dropping tables from the database into the application - somehow the application must have just guessed which database he wanted to use.
Would appreciate any help finding a tutorial that has ALL of the steps for joining C# to SQL Server using LINQ or even not using LINQ. I just need to be able to get database from the database so I can display it on the screen.