Connecting C# To MySQL Using Blazor (Full CRUD Actions) 

Between RU-vid and my IAmTimCorey courses I’ve seen this process so many times... but Every time I learn a little more about constructors, classes, dapper, sql dev, using statements, mapping, etc... the understanding that this guy gives us is invaluable. This is something like khan academy for C# ... Believe it or not but you are watching one of the best parts of the internet. thank you man 🙏🏻

dude i searched the internet for so long and finally i got to the right place. Man, if any out there is watching this, dude you are at the right place. Mr. tim corey keep up the good work.

It's my favorite kind of tutorial: focused, not overbearing and contains new information. I like dapper and blazor server 😊

This was brilliant! I've looked at so many videos trying to figure out how to do this but yours was concise, accurate and well presented. You made it look simple to use blazor with a database which is not always the case with other RU-vid tutorials. Thanks!

Big thank you from me. I needed exactly this for my project and you uploaded this video on the exact same day. I was really frustrated, that I wasn't able to find something good and then you uploaded your video.

Thanks for the video, I had looked at other tutorials but none of them worked, until I found your channel.

This is the first of your vids I've watched and I got say we'll done! Like Einstein said: If you can't explain it simply, you don't understand it well enough. I've been struggling with this topic for a few days and your tutorial has cleared up everything for me!

Keep up the good work you're amazing! I can't seem to get my head around C# until I discovered your channel!

been looking for a while on a lot of places and this one was the most helpful and straight video i found. Thanks!

I switched from .NET to Node a few months back and fell in love with VueJs/Node/TS... But there's no way I'm not taking full advantage of this tutorial to Make myself more valuable to employers. My eyes just lit up when I saw this. Thank you Tim!

Wonderful video from which I learned so much. Thank you Tim Corey for your effort!

I just figured out how many lines of code I have needlessly written in recent months while working with MySql myself... On the other side you just saved me from wasting even more time and space in the future. I need to do some refactoring this week. Thanks.

Awesome tutorial, very simple & sweet language Successfully created demo by watching this video without any error or bug Thank you so much

Thanks for all your video Tim, and also thank you for your clear diction. English is not my birth language therefore I can perfectly understand you.

Simply Amazing !!!! I use the same steps to connect my application to the Oracle database. Hats off !!!

well thought through and well explained. i like it a lot and learn to see things come together at the same time. thanks for this talk.

Superb as always Tim :)

Wow, great tutorial. I have been working/learning EF core for the past couple months. After a series of complex error messages and struggling to do even basic things, I've decided to move to Dapper finally. I should have listened to you earlier lol

Hey Tim. I actually learned to code using your WinForms videos. I took that knowledge and learned Node & Vue and I'm launching a product in the coming weeks which is over 2,000+ hours of code deep but I consider C# and .NET to be imperative to my general 'computer science' understanding. This video has been on my 'todo' list for nostalgia's sake although I don't get to play with C# much these days, I needed a day off from my project and thought this tutorial would help me unwind. I managed to modify the code a bit and connect to my production server/database and I added appsettings.json to .gitignore. Now I have a great template for Blazor/MySQL which can be a lot of fun in the future. Blazor actually feels like a mix of React & Vue which is pretty cool because I like both. I've noticed a trend that a lot of .NET developers eventually gravitate to Angular. I'm sure as people get more comfortable with Blazor that will change but I've always wondered why .NET devs tend to gravitate to Angular. I've seen it more than a handful of times. Is it that Angular has more of an 'Enterprise' feel than it's counterparts? Just wondering your take on that.

Awesome video Tim, as always. Would love to see you take this topic a little further by using some forms for data input and data grids for displaying the data back please. Keep up the great work!

Exactly what I needed. Thank You very much!

Thank you for sharing the knowledge and doing it so well.

First: scheduled to watch tomorrow early morning. NZ thx in advance Tim.

Thanks, just what I needed.

Really helpful video. Thanks!

I love you tim.. You help a lot.

Many thanks sir!

I felt the temptation, but you went for that Interface, nice.

I had trouble with the DELETE - permission problem. In MySQL workbench, used Edit / Preferences / SQLEditor - bottom of page uncheck 'Safe Updates (rejects UPDATES....)'. Then worked OK. You did mention in the video there could have been a problem at this point. As always, great video. Best regards. Jan.

This is awesome. Thanks. :) I love the tooling MS giving us. It has everything included and core apps can be run on Linux machines, but the MS SQL Server is the only limiting factor. You can't really use it outside of Azure and it's too expensive for personal projects. The free tier isn't enough for real-world personal projects that would be alive over 12 months. MS SQL is really good and would love to use it. Especially loved how you used database projects with TimCoRetailManager. I've searched, but couldn't find any way to use that for MySQL/Postgres. The only add-on I did find was dbForge Fusion for MySQL, but it costs like a $300. Can't really afford that for personal projects.

Thank you Tim

Very useful thank you 🙏

thank you, Tim

Thanks bro i have learned alot.

Yes this is what I'm looking for

I loved your tutorial.

Thank you IAmTimCorey! I was wondering. Can we execute a store procedure rather than write down our query? For example: Datable g = access.getPeople();

Thank you, very helpful video, 29:36 - you can wait for it like this List rows = (await connection.QueryAsync(sql,parameters)).ToList();

0:29 "My goal isn't to entertain you. My goal is to turn you into a world-class developer" - Well, imo you manage to do both at the same time. You educate us in an entertaining way and explain very clear. Really good job. Could you also make a video how to access multiple SQL 'types' such as TSql, MySql, Sqlite in the same project without using an external framework (e.g. because you aren't allowed to), but with the default classes instead? You know, SqlConnection, MySqlConnection, DbConnction, SqlCommand, MySqlCommand, DbCommand, etc... Or if that's too much, a simple video about the Managed Extensibility Framework would help as well. I'm really stuck with that.

Thanks for your video. Dapper seems much more easy to learn and implement than EF. Please can you also do a video showing how to display data in datagrid and how to generate Reports.

Thanks a lot buddy :)

Startup.cs Can not add services.AddSingletonDataAccess(); Or 'DataAccess' could not be found ? My Project Blazor Server .Net Core 3.1.402 Or I should Add Project Reference ?

timy u c sharp legend lol thanks alot

You’d mentioned adding the models to the library would it be better to do that as well as have classes with methods in library for the save/load ie _data.people.savedata(person) or _data.people.update(person) ? With the sql and connection string all in the library?

Hi Tim, thx for the video. Two questions, why not use ToListAsync() in LoadData ? It's because the overhead that come with async/await?

When we publish a project with a data library what folders do we need to include on the server in order to execute the application? The publish process produces one release folder for the Data library and one for the blazor project, how does the blazor project access the data library? If you have any tutorials on migrating this to a linux vm please let me know, great video thank you for your thorough explanations.

In the other video you did "Blazor Server Side ..." you used services.AddTransient(); instead singleton like in this vid. I know the difference, but wonder what reason there might be to use one other another. P.S i use cosmos if this might change anything. And thank you very much for your vids.

Hi Tim cory! i want you to talk about cross cutting and Aspect oriented prgramming with c#, how to handle it, best practices, thanks

Thanks Tim for this video. I was building a project with EfCore with clean architecture, but wanted to refacter EfCore use with interfaces... looks like I can now use Dapper for reads and EfCore for writes if I get this right.

Great videos and very practical. Would you have an example using Blazor+Dapper+Oracle?

50:00 when ever I create an update statement I always type "Update set where" and then go back and edit what ever I need for that to work. That way I never miss the 'where' and overwrite the whole table since if I was to try and run it with "update person set firstname='bob' where" the query will fail since there is not value set after where. I little tip I got from a colleague at my first developer job. Kind stuck with me and since I've taught others to do the same. I normally don't use delete that much in my day to day work but you could use that tip for delete queries aswell "delete from where" and continue from there.

Thanks Tim, even though its a demo but I still think SaveData method could be improved even more, like execute extension method from dapper returns int which is rows affected for the execution, so that I think instead of Void or Task which they are fire and forget you could use int or bool var rowsAffected = connection.Execute(..); return rowsAffected > 0; by any chance it will be great to see a video from you about CQRS as well.

Hi tim, i got a problem when add DateTime type into this tutorial project. the Date just showing default value (01/01/0001) to web page not from Database value. How to retrive date value from database (Mysql) into blazor web page?

Excellent as always Tim. I watched the Blazor Server with SQL access tutorial as well the other day. I noticed that on that one you created an entity(or model?) for the data access library together with the sqldataaccess class. Considering that both are Blazor Server project. Which one do you think is better in terms of design? Also, when I run my app that connects to MSSQL DB it takes a long time to connect and show the list of users, I changed the access from transient to singleton hoping it would help but it didn't do much. Is this to be expected because MSSQL is not started and is being started by visual studio whenever it tries to run? If so then I think this shouldn't be a problem on a web app uploaded on cloud servers since SQL Server should always be up, am I correct in this assumption? Sorry for the long questions.

YOU SAVE LIFES

is there a good way to implement dependency injection in backend, I was halfway implementing Dependency injection in a web api controller before realizing I've never actually used dependency injection where there wasn't razor components... how does one do that? googling didn't do much for me

Hi Tim, Thanks for you Videos. Awesome Do you have video about Authorized?

Hi Tim, great content, off course! In Blazor we don't use controller or "code behind" like razor pages?

Design question: In a live scenario, would you strip all of that specific data logic(i.e. People Model, query, params, call to dataAccessor) out of the blazor page and into, for example another class Library or seperate folder within the Web project?

Thank you so much Mr. Corey! But I’ve got an issue. I am using .NET 6.0 (Long-term support) and I figured how to deal with Program.cs instead of missing Startup.cs but CRUD buttons are not working in a situation similar to the one you had and developer’s panel tells me that connection should be opened and valid. Thus I added connection.Open(); to methods in your library and now it works but still it gives me errors sometimes telling that another read operation is in progress or something like this. So I want to ask you if you didn’t forgot to add connection.Open(); line in your SaveData and LoadData methods of DataAccess library or maybe I am doing something wrong? Without this line it just doesn’t work at all.

@Tim when u will going to put up some cloud videos(aws or azure) ..is it on ur list in this year?

Thanks Tim for the tutorial? How about using MySQL with EntityFramework? Can you also do a video on tht?

how can use in WPF this? tks.

Hi, Tim. Apologies for this not being related to the video, but what are your thoughts on doing a video about reflection? I think I get the general idea but the finer details and necessity of it somewhat escapes me. Apologies if you've already made something on the topic, I didn't find anything.

tnx alot for your work i am learning alot from you i want to ask you some questions. betwwen sql server and oracle sql itch one is more secured and stronger and please can you make videos about azure key vault or how to build security around dotnet application(web desk) and will you cover MAUI when it will be available and is it cross platdorm (compile it once and run the app on linx mac and windows or it will be like wpf and winform only for windows) and will you make mobile app dev in the future?

Hi Tim!! Is there a course on your website for MySQL and C#? More specifically MVC?

Very informative. How about a tutorial on Sybase Central SQL Anywhere ? Have you tried to connect with Blazor? Thank you

in the new vs2022 version is no startup.cs. where do i need to add the services? in program.cs it won' work

A way to improve on this is to use stored procedures so you can have only certain stored procedures for different database users. But to do that with the minimum user permissions (GRANT EXECUTE ON PROCEDURE dbName.spName TO 'databaseUser'@'address';) you have to use MySqlConnector, a community MySql connector that fixes known issues in the official MySql.Data. I've been using this for my projects after I addapted the data access class from the TimCo Retail Manager and it's been working great. Also a question for Tim, I'm trying to change the database used in asp.net web apps for authentication to MySql from MSSql. I thought this might be "easy", as in change the connection string, import the necessary libraries for using MySql with entity framework, a few config changes and then let entity framework be in charge of building, modifying and queering the information as the loggin/authorization endpoints made by default that use the entity framework connection are probably more secure than what I'd be able to make. As of right now I've managed to avoid it crashing on startup of the web app but when I call the Api it fails to create the database on the first insertion (like it does when you don't have a database instantiated in MSSql). Any ideas for using entity framework with MySql? I've thought of manually creating carbon copies of the tables in the users database in MySql but don't know if there are any stored procedures/views that entity framework creates when using MSSql that it also uses.

Suppose I have published a blazor server app to a server pc with IIS and let's suppose that this app uses two databases as you say one for the registration and the log in which will be the one created by entity and one for our data access which I will have created using an SQL server database project in Visual Studio. The question is this. Will I have to install sql server express to the server pc for this to work? If yes is there another database type I could use so I can avoid this additional installation? Thank you.

Nice demo. Although, all the cool kids are using MariaDB. :) Would it make more sense to handle the connection string in your injection so you don't have to deal with that in the UI code?

hello, is it possible to pull mobile data with this method? Is the mobile data extraction method different? I'm trying to make a mobile application, I'm new. Thank you from now

I recently discovered your channel and really appreciate your work! But i had a few question relating to this section: 43:33 Why doesn't it work in blazor web assembly version? Is it because it compiles to web assembly and web assembly just can't? Also, is there any way to do it another way then? I understand that, even if it would work it woult be very bad practice (even if it WOULD work) to call the database client side, don't get me wrong.

Does this approach works with Blazor Web Assembly app and a MySQL database locally hosted on xampp ?

Hello Sir, thank you for this video! I am currently in the process of learning how to develop Blazor server applications and I have been able to make some progress by implementing basic CRUD operations. However, I am concerned about the security implications of passing IDs to another page without using local storage. Is there a recommended method for achieving this? , do you have any instructional videos on this topic that you can recommend?

yo, please...how i connect with blazor webassembly ?

Hey Tim, I've recently started working on a project that uses blazor. So far I'm having difficulties connecting the WebApp to a local sql db. Documentation and tutorials, even this video have not enabled me to figure it out. I was wondering if you had some advice? Kind regards. Extra Info: Using .NET 6 & VS 2022 Blazor WASM + ASP.NET Core Hosting + WPA Currently in early development fase => trying to use local SQL Server (SSMS) since I've been given a replica from an existing database

how to solve this problem at connectionString ? error : The option 'IntegratedSecurity' is not currently supported.

I like your video. I have a question. Can changes be displayed directly on the web as the database changes? Ask me what to do.

Hey! I couldn't find startup.cs file in my latest BlazorServer app. Can you help how to do Dependency injection at 21:27?

Hi Tim. I cannot get past this error when loading the people page. "ExtendedSocketException: No connection could be made because the target machine actively refused it. 127.0.0.1:3306" I know my server is running and whatever i try it will not load. Any Ideas?

Just a newbie question. Does this method not prone to cyber-attacks like SQL Injection?

How would you get the last inserted id when you add something to the database with dapper?

I am using this video to learn Dapper CRUD actions, but using a wpf .net Core application to test instead (I want to get the data layer down first). When using the connection.ExecuteAsync method I get an "Invalid operation. The connection is closed." exception. I noticed this problem goes away when I change the "using IDbConnection connection = xxx" to "IDbConnection connection = xxx" . It seems the async operation is closing the connection before the actual execution is complete. monitoring the sp_who in SQL Server Management Studio, I can see that removing the using portion of the statement does not leave any hanging open connections. Is this still dangerous practice, and is there some sort of special case with the a desktop application vs a blazor server app? Thanks for your videos they're great! edit: forgot to mention the using portion works fine for loading data, it is only the executing of queries that gives me the closed connection exception. I suspect this is because the LoadData function awaits the connection.QueryAsync and the SaveData does not await anything, just returns the task. thanks again!

if I change from MySql.Data to System.Data.SqlClient (and the appropriate "using MySql..." statements and connection string), when "Insert", "Update", or "Delete", I get the following error: "System.InvalidOperationException: Invalid operation. The connection is closed. at system.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)". Shouldn't this work the same with sql server? (I've tried Microsoft.Data.SqlClient also.)

Thank you Tim. It will be so nice if you can provide an tutorial / payed course on how to deploy simple .net web app / web api but on a shared hosting like goDady...because aws / azure are so expensive..for example, i want to build an blog with custom cms..and winforms admin app...and i will buy your full timco retail manager course wery soon...but i cannot deploy my small / beginer level apps on azure...so, i am ready to pay some course on how to deploy 'timco like' apps on a shared hosting. I think that course would be awesome...

Great video!, I have a trivial question, how can I send an explicit long query string with JOIN etc.? , thanks

I'm now at section "Dependency injection (startup.cs)" but there is no startup.cs in my BlazorServer project? Where to put the injection now? I try to put it in program.cs where the WeatherForecastService is

Hi Tim. thanks to yuo i'm using dapper and loving it. I have to change a blazor server app to blazor client. Every thing wen ok until i started to connect to mysql. In server everything its ok. In blazor client the mysql driver threw an exception in any operation even when i open te connection. ¿Have you use blazor client with mysql? its that posiible?. Thans in advance

you mentioned at the beginning of this video that you use Blazor server for calling mysel. as you cannot call to mysql from blazor webassembly as you said. my question is then what solution would you use to call to a backend like mysql from a blazor webassembly app?

wow a 3 years old tutorial that still works

Hello Tim, Can put a separate video connecting to Oracle Database Stored procedure with UDT

Hey Tim, when I am going to /people like in your video, I get an exception for the IDataAccess: InvalidOperationException: Cannot provide a value for property '_data' on type 'ShoppingBot_250922.Pages.People'. There is no registered service of type 'DataLibrary.IDataAccess' Could you help me pls?

Hello Tim, Thank you for a great video, I am currently working on a project and this helped me lots however at 47:20 you mention the use of Insert Form, I am struggling with that topic and merging it with searching MySQL DB. Would you have a video that make sense on how to add the search option using insert form? I have already created the whole page using Bootstrap, I just cannot link the input text to the "where" in my "select" command.

Hi Tim... When trying to add a new page, I don't have the choice for Razer components.. what do I need to do??

When I try the same with .NET 6 (kestrel server) , I'm getting lots of intermittent issue saying "connection must be valid and open" and table not getting refreshed after adding/deleting/updating model.

How do I turn on the Smart IDE that automatically adds your using statements?

Very informative. How about a tutorial on MongoDB.

is this video series include client server (API) sample project version?

Awesome video Tim, How to add method return single object