Challenge: Refactoring in C# Challenges are for testing your skill and understanding of a specific topic. The purpose is not to write complete applications but instead to write just enough to test out your knowledge of one particular piece. This process of testing out what you learn is critical for learning a topic well. You have to practice what you learn. This is that practice. For more information on what this particular challenge is about, check out this video: ﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿ Instructions Video Help Sometimes you need to refresh your mind on a topic. Here is a link to help you…

The Complete Path From Database to Display and Back Tutorials are excellent at teaching you about a piece of the overall development puzzle but sometimes you want to take a step back and look at the bigger picture. That way you can see where those puzzle pieces you have been collecting fit into place. This video is going to be that bigger picture overview. We are going to build a small demo of an MVC application and its accompanying database. We will set up a form to collect data, capture that data, and put it into our database. We will…

Conference Talk Resources Hey, I hope you enjoyed my conference talk on Dapper. Below you will find the resources from my talk. I have also provided my contact information. I would love to hear from you about your thoughts on the talk (or anything else). Also, I have included some links to other videos that my help expand your understanding of the topic of Dapper. If you have a question around other related technologies, please let me know. Presentation Resources Slides: Source Code: Tim’s Contact Info Email: tim@iamtimcorey.com YouTube Channel: https://youtube.com/IAmTimCorey Twitter: https://www.twitter.com/IAmTimCorey Join Tim’s Mailing List: https://iamtimcorey.com/general-sign-up Additional Resources ﻿﻿﻿﻿﻿﻿﻿﻿﻿

Challenge: Error Handling in C# Challenges are for testing your skill and understanding of a specific topic. The purpose is not to write complete applications but instead to write just enough to test out your knowledge of one particular piece. This process of testing out what you learn is critical for learning a topic well. You have to practice what you learn. This is that practice. For more information on what this particular challenge is about, check out this video: ﻿﻿﻿﻿﻿﻿﻿﻿﻿﻿ Instructions Video Help Sometimes you need to refresh your mind on a topic. Here is a link to help…

Database Management and Deployment in Visual Studio What if I told you that you could create a SQL Database in Visual Studio, manage it like any other project, track it with source control, deploy it to multiple environment, and refactor it like C# code? In this video, I am going to show you how to do all of those tasks and more. The best part is that it is free and comes baked into Visual Studio. And no, we aren’t going to be using Entity Framework, although this method is compatible with Entity Framework. ﻿﻿﻿﻿﻿﻿﻿﻿﻿ Resources mentioned in the video…

Challenge: Text Files in C# Challenges are for testing your skill and understanding of a specific topic. The purpose is not to write complete applications but instead to write just enough to test out your knowledge of one particular piece. This process of testing out what you learn is critical for learning a topic well. You have to practice what you learn. This is that practice. For more information on what this particular challenge is about, check out this video: ﻿﻿﻿﻿﻿﻿﻿﻿﻿ Instructions Starter Code Solution You don’t have to purchase the solution. You would only need to purchase something if…

Easier than MSI Files, Better Than ClickOnce Deploying your desktop software isn’t the easiest thing to do well. Either you go the simple route and just copy your files to another machine or you try to create a complex installer file that is hard to understand and support. Fortunately, there is a third option. In this video, we are going to look at Squirrel, a simple to use installer that just works. We are going to see how easy it is to create an installer that also keeps our software up to date without being a huge headache. ﻿﻿﻿﻿﻿﻿﻿﻿ Resources…

Challenge: foreach in C# Challenges are for testing your skill and understanding of a specific topic. The purpose is not to write complete applications but instead to write just enough to test out your knowledge of one particular piece. This process of testing out what you learn is critical for learning a topic well. You have to practice what you learn. This is that practice. For more information on what this particular challenge is about, check out this video: ﻿﻿﻿﻿﻿﻿﻿﻿ Instructions Starter Code For this particular video, there is no starter code. Some challenges will have code to get you…

In the PASS Insights video, we saw how to quickly get Dapper up and running. If you want to play around with it yourself, here are the scripts and source files that were used in the demo: Full Database Script: Source Code: For more free videos on SQL and C#, check out Tim’s YouTube channel at https://YouTube.com/IAmTimCorey. If you want to see how C# and SQL fit together in the real world, check out the course C# Application from Start to Finish.

Going Beyond Just Writing Methods Have you ever heard the term DRY, as in “Keep your code DRY”? DRY refers to one of the foundational design principles in programming. It stands for Don’t Repeat Yourself. On the surface, that sounds so easy to do. However, as you will see in this video, there is a lot to think through when trying to get this right. From thinking through where to put code to ensuring that you don’t repeat yourself in testing and bug fixing, there is a lot beneath the surface of simply keeping code DRY. ﻿﻿﻿﻿﻿﻿﻿ Resources mentioned in…