C# Programming (Intermediate) - Lecture 2: SQL Server, CRUD, DisplayMemberPath, ObservableCollectio

C# Programming (Advanced/Intermediate) Lectures (2/14) will teach you #CSharp #programming from beginner to intermediate/expert level. This course is an excellent source to learn advanced concepts in C# #coding. If you are a beginner to C#, watch our previous course lectures. The playlist link of the previous course is below.

Full playlist of the previous course: C# For Beginners ⤵️
https://www.youtube.com/playlist?list=PL_pbwdIyffskoSXySh0MdiayPJsBZ7m2o

Discord ➡️ https://bit.ly/SECoursesDiscord
Patreon ➡️ https://www.patreon.com/SECourses

Technology Playlist (30+ Tutorial / Guide / News / Review Videos) ⤵️
https://www.youtube.com/playlist?list=PL_pbwdIyffsnkay6X91BWb9rrfLATUMr3

Stable Diffusion Playlist (30+ Tutorial / Guide Videos) ⤵️
https://www.youtube.com/playlist?list=PL_pbwdIyffsmclLl0O144nQRnezKlNdx3

Please join discord, mention me and ask me any questions. Thank you for like, subscribe, share and Patreon support. I am open to private consulting with Patreon subscription.

Full playlist of this course ⤵️
https://www.youtube.com/playlist?list=PL_pbwdIyffslHaBdS3RUW26RKzSjkl8m4

You can watch for free our C# Programming, ASP .NET Core MVC programming, Machine Learning and Software Engineering related courses on our playlists page ⤵️
https://www.youtube.com/@SECourses/playlists

GitHub code repository of this course (source codes of the lectures) ⤵️
https://github.com/FurkanGozukara/Introduction-to-Programming-2-2021

The topics that have been covered in Lecture 2:

* How to compose a custom class
* How to use overwritten property to display the custom formatted results of other properties inside a class
* How to compose read-only or write-only properties inside a custom class
* How to do inline If and Else
* How to use the Switch statement
* How to use For loop
* How to use and utilize ObservableCollection to display custom class objects inside a ListBox // this can be applied to any main window objects
* How to use ItemsSource DisplayMemberPath of a ListBox inside a WPF application
* How to access elements of ListBox as an instance of a custom class when selection changed
* How to install Microsoft SQL Server 2019 Developer edition
* How to install SQL Server Management Studio
* How to compose database and table with SQL Server Management Studio
* What is database collation and what difference does it make
* How to write insert, update, delete, and select queries with SQL Server Management Studio
* When to write full path or not in SQL queries such as the database.dbo.table or just table
* How to uniquely identify a record and do SQL operations such as select, update, and delete certain records
* How to use "in" keyword in SQL queries

Composing a Custom Class:

When it comes to object-oriented programming, one of the essential concepts is the creation of custom classes. Creating a custom class in any programming language allows the developer to define a data structure that fits their specific needs. A class is a blueprint or a template for creating objects. An object is an instance of a class that has its own identity and can have its own set of values for the class's variables.

Read-only or Write-only Properties:

Sometimes, it may be necessary to define properties that can only be read or written to. To accomplish this, you can define read-only or write-only properties in your custom class. A read-only property is a property that can only be accessed for reading. It can be useful when you want to prevent accidental modification of a property's value. On the other hand, a write-only property is a property that can only be accessed for writing.

Inline If and Else:

In programming, sometimes it is necessary to execute a particular block of code based on a condition. One way to accomplish this is by using an If statement. An If statement evaluates a condition and executes a block of code if the condition is true. An inline If statement, also known as a ternary operator, is a shorthand way to write an If statement. It allows you to write a conditional expression in a single line of code.

ObservableCollection:

An ObservableCollection is a collection class in the .NET Framework that provides notifications when items are added, removed, or changed. It is useful when you want to display a collection of objects in a UI element such as a ListBox. The ObservableCollection class implements the INotifyCollectionChanged interface, which defines an event that is raised when the collection is changed.

ItemsSource DisplayMemberPath of a ListBox:

In a WPF application, the ItemsSource and DisplayMemberPath properties of a ListBox can be used to display a collection of objects. The ItemsSource property specifies the collection of objects to display, and the DisplayMemberPath property specifies the property of the object to display. When the ListBox is bound to an ObservableCollection of custom objects, the DisplayMemberPath property can be set to the name of a property of the custom object to display.