How to connect C# to SQL (the easy way)
Why Stack Overflow recommends it
Stack Overflow users link it as a beginner-friendly walkthrough for connecting C# to SQL with Dapper, mainly when learners are following it and hit setup questions.
Recommended by 2 people across 2 different months, 2019 to 2021.
What it is
A feature-length tutorial by Tim Corey that builds a small WinForms app in C# and uses the Dapper micro-ORM to read and write SQL Server data. It covers connection strings, a helper class, stored procedures, and binding results to UI controls, after a short comparison of ADO.NET, Entity Framework and Dapper.
What people said
Recommends MariuszKK · 2019-06 · Stack Overflow · on “'Must declare the scalar variable "@categoryid". When im trying insert data from procedure to database with dapper”
I've modeled myself on Tim Corey, I think that for a good technician, consistent with good practices, I'm quite a beginner :) Below link: [this video]
Recommends Henry Puspurs · 2020-08 · Stack Overflow · on “App.Config in a class library for data access from WPF and ASP.NET?”
I'm trying to use SQL for the first time to store data in one of my projects, I'm using this [this video] tutorial as it makes the most sense to me, and to be honest I like the guys videos, and hate clicking on hundreds of bad videos before finding one I can learn from. Anyway I'm making an app where I need to access and save to a SQL database I have made in MSSMS, I have a class library for logic, a data class library for data access, and a WPF interface (I also plan to add an ASP interface with less edit features, but adding Web API, its all for learning) In the video to connect dapper the guy sets up a helper to get the connection string, but that is looking up an App.Config through configurat
Cites John Beasley · 2021-07 · Stack Overflow · on “System.ArgumentException: 'The specified invariant name 'System.Data.SqlClient'”
@mason - Many of the tutorials from IAmTimCorey seem a little dated. This video: [this video] was from 2017. Would you say it's still relevant?