A Set of Masterpieces on Solving Issues with .NET and SQL
- Description
- Curriculum
- FAQ
- Reviews
Hi there,
This is a course built upon my own experience of encountering different kind of errors while compiling/running or testing applications with dotnet Core as well as executing MS SQL commands. This is followed by the debugging/sorting of the issues, so everything works nicely. There is little or no code involved in many of the lectures as that is the nature of these issues which needed to be tackled while development.
As and when more such common errors are encountered in future, I shall be updating the course with the solutions to these as well.
This course is a brainchild of my experience with the fact that all developers love to have their issues (that would otherwise be a showstopper for their projects) to be sorted in a nice and timely manner. Since this is helping others with their problem solving, it is hoped that the course will gain a good following and feedback from the relevant sections of students.
With myself coming from a Microsoft development background, I know fully well what it feels when a developer has to spend hours together on an error that seems to have no solutions that would fit his context.
Off course, there is the stackoverflow website, where one can raise his issues in a formatted manner giving the maximum possible information to recreate the error, still there is no guarantee that it would necessarily get a solution that works.
So this is a very small and humble effort to address some of the issues as a baby step forward in that direction.
I hope to receive learners experience and inputs to further improve the course in future.
-
1
Encouraging Constructive Feedback: A Message to Our Udemy StudentsThis lecture emphasizes how unexplained low ratings can deter new students from enrolling in our courses in a highly competitive market, highlighting the importance of constructive feedback for both instructors and learners.
-
2
Introduction
This is an introduction and overview of the course. It spells out the objectives and intended benefits of taking this course.
-
3
What This Course Doesn't Cover ?
This lecture clearly states what this course does not cover and why?
-
5
How to Fix a Use Case of Object Reference Not Set to An Instance Of Object ?
The most common type of Error in .Net is a Null Reference Error. This video recreates a use case for this exception and shows what the trigger is and how to handle this error, so that it doesn't recur?
-
6
How to Solve Docker Daemon Not Starting with Docker Desktop for Windows?
In this I have explained a scenario in which the Docker Desktop for Windows failed to start the docker engine and what I did to solve the issue?
-
7
How to Solve an Instance Specific Error Connecting to SQL from VS ?
This video shows how I resolved the "Network or Instance Specific Error While Connecting to SQL Server" while updating database through EF Core Migration. I have simulated the error as I encountered while working for a Web API project with EF Core and shown the debug and resolution so that Update-Database comand went through to create the database with the table,
-
8
How to Fix “AmbiguousMatchException The request matched multiple endpoints ?
In this lecture I have described a scenario in ASP.NET Core 6 web application that ends up in the error "“AmbiguousMatchException : The request matched multiple endpoints”
This lecture and the discussions, may help in troubleshooting the cause of this error from other origins of this error.
-
9
How to Solve "An Unhandled Error Has Occured" in Blazor ?
This lecture shows how to use F12 developer tools and the Startup class to debug this issue and then fix it.
-
10
How to Fix JSON Reader Exception in ASP.NET Core
This lecture discusses an error that happened during integration of Serilog package to an ASP.NET core project. It then reproduces the error and rectifies it. In the process learners will get some valuable insight into how some unintended operation can introduce an error and how to debug the same.
-
11
How to Fix “Inaccessible due to its Protection Level” Issue ?
In this lecture the students will learn a scenario of fixing the accessiblity issue of a method due to the absence of a C# keyword in the method signature that created the issue.
-
12
How to Fix “An object reference is required for the non-static field, method" ?
This is probably the most common .NET issue and in this particular scenario the students are taught how to tackle this issue with C# code example through a Visual Studio project. This issue is also referred to as the "Null Reference Exception" error.
-
13
How To Fix Not Implemented Exception in Explicit Interface Implementation?
After completing this lecture, learners will know what the differences between Interface Implementation and Explicit Interface Implementation are, as performed automatically by Visual Studio editor. This knowledge will help them avoid "Interface Not Implemented Error."
-
14
How to Fix Various Compile Errors in .NET Maui App in One Go?
As I tried to run the Notes application in part 2 of the YouTube series at https://youtu.be/3g1rdRckoNs?si=x8Iauiob4oFiJqDc for creating the part 3, the VS 2022 IDE ended up with a dozen compile errors, failing the build process. As the origin of the error was not obvious from the error output, I tried several strategies earlier like cleaning, rebuilding the solution and even restarting the application after deleting the bin and obj folders with no success. Finally, I could debug and fix the error and I have shared my journey in this video.
-
15
How to Fix SP Not Found Error ?
This lecture describes a situation where a simple typo in the SQL Stored Procedure brought this error, which took a good bit of time to resolve. So I have described the scenario and recreated the error and resolved it. As with all the earlier bugs and their solutions in this course which could have multiple origins, this is only one (of many) scenario that was encountered by the instructor. It is hoped that any other origin of this error could likewise be sorted by suitably debugging through the issue and applying logical sense to troubleshoot.
-
16
How to Fix Insert Statement Conflicted with Foreign Key Error in Visual Studio ?
This is a lecture that demonstrates what error you could end up with if you're trying to call an Customer object with a non-existent id to fetch the Orders for this customer, with the SQL referential integrity enforced in SQL server.
-
17
How to Solve Restore of Database failed with MS-SQL Server
The students will be able to solve a particular scenario of database restoration failed from a given backup of SQL server.
-
18
How to Solve MS-Sqlite Issue Resulting in Error 500 ?
Here an internal Sever Error was generated due to a missing line of code inadvertently which is supposed to create an Sqlite database with the named table.
-
19
How to Solve Invalid Column Name Error: SQL?
In this lecture I have discussed the context when such an Error may occur in a Web Application and how to get around and fix the error in that particular context. The students will know when/how to issue the Add Migration and Update Database commands through the package manager console.
