Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Build professional real world C# Console Application
Rating: 3.0 out of 5(3 ratings)
1,024 students

Build professional real world C# Console Application

Learn how to build a console C# application to automate tasks and reuse over and over again for work projects
Created byStephen Mooney
Last updated 11/2022
English

What you'll learn

  • Console Applications
  • ADO
  • Clean Code
  • Logging
  • Databases
  • Notifications
  • Automating Tasks
  • Csv parsing

Course content

2 sections • 19 lectures • 1h 51m total length

  • Create database7:37

    Create your database using SQL Server management studio and analysing a Csv file

  • Create project0:33
  • Configure connection string5:30

    Configure a database connection for a real-world C# console app by using server explorer to obtain the connection string with source, catalog, and integrated security, then test via configuration manager.

  • Database connection3:04
  • Dummy data11:40
  • Insert data19:15
  • Insert Data 22:05
  • Download File2:43

    Learn to download a csv file by grabbing its url and saving it to a drive path with a temporary directory for security, using a dedicated download function.

  • Check if row exists before insert6:04

    Check if a car exists before inserting by building a check exists function, executing a parameterized query, and using the row count to prevent duplicates in a C# console app.

  • Parse Csv Part 11:31
  • Parse CSV Part 26:35
  • Refactor, clean up and test9:38

    refactor code to adhere to the single responsibility principle, creating a service and a manager class, and test processing steps with record checks and csv data.

  • Generate output3:28
  • Fix Bug2:45
  • Setting Logging13:00
  • Implement and test logging1:30
  • Automated Task8:25
  • Refactor, cleanup and finish project3:14

Requirements

  • No experience needed

Description

This is not a C# course and is not an ADO NET course or a .NET course, it is a course designed to show you how to build a professional CSV Parser using .NET.

This is a course that will benefit everyone but it would be helpful if you had basic knowledge of databases, C# and logging, but it is not necessary,

Are you tried of 40 hour courses where you do not retain most of it and cannot use most of it in your work? Well here is a course that lets you create a useful project you can actually use over and over and over.

Shiny web applications are not the only useful software around, in fact you will probably spend more time creating smaller applications to perform automated tasks and why not learn how to and have a base project you can use over and over gain while you are at it. Not only that but you get to create a CSV Parser and this is one of the most common small and larger projects in the workplace.

See what real world programming is and see how to manage and solve problems and mistakes. Do not try to remember endless syntax, instead learn how to ask the right questions to get the right answers.

We include how to use logging, performant ADO . NET, notification services, CSV parsing using CSV helper which is very popular, database design and creation and learn how to create clean expressive code. Make use of professional file and console logging using serilog to track your project during runtime to catch any issues and log useful information to the console.

You will truly tested with this project and you will see exciting challenges coming. Can you handle it? Can you? Well then enrol and lets get this journey started. 



Who this course is for:

  • Beginners

Report abuse