C# Programming (Intermediate) - Lecture 9: Unique Constraints in Databases, Entity Framework Sortin

C# Programming (Advanced/Intermediate) Lectures (9/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

In Lecture 9:
* How to hide and display a tab according to the authority of the logged-in user
* How to load a ready CSV dataset into the database with Entity Framework
* How to utilize task.factory to prevent user interface freeze
* How to update label from sub-threads, sub-tasks with dispatcher
* How to add uniqueness constraint to a database table with defining a unique index
* How to achieve unique adding to the database when using entity framework
* How to add sorting feature to your datagrid display when using entity framework for automatic display, insert, update, delete
* How to bind all elements of an enumeration to a combobox
* How to display description of enum items in the combobox
* How to get selected enumeration of itemssource bound combobox

Introduction

In software development, it is essential to have a good grasp of various techniques and tools that can help us in developing robust and efficient applications. This article will cover various topics related to software development, such as hiding and displaying a tab, loading a CSV dataset into a database, utilizing Task.Factory, updating a label from sub-threads, adding uniqueness constraints to a database table, achieving unique adding to a database when using Entity Framework, adding sorting feature to datagrid display, binding all elements of an enumeration to a combobox, displaying descriptions of enum items in a combobox, and getting the selected enumeration of items source-bound combobox.

How to Hide and Display a Tab According to the Authority of the Logged-in User
In software development, it is essential to manage user privileges to ensure that users can only access features that they are authorized to use. In WPF, we can use the IsEnabled and Visibility properties to hide or display a tab based on the authority of the logged-in user. We can define the authority of the user in the database, and based on that, we can enable or disable the tab as required. This technique helps to prevent unauthorized access to sensitive data and functionality.

How to Load a Ready CSV Dataset into the Database with Entity Framework
CSV (Comma Separated Values) is a popular format for storing data in a tabular format. In software development, we often need to load CSV data into a database for further analysis or processing. Entity Framework is a popular Object-Relational Mapping (ORM) tool that allows us to work with databases using C# code. We can use Entity Framework to load a ready CSV dataset into the database by creating a model that maps the CSV data to the database table, and then using the DbContext class to add the data to the table.

How to Utilize Task.Factory to Prevent User Interface Freeze
In software development, it is essential to ensure that the user interface remains responsive even when the application is performing heavy processing tasks. We can use Task.Factory to run time-consuming tasks asynchronously and prevent the user interface from freezing. Task.Factory allows us to run tasks on a separate thread and then update the user interface when the task is complete. This technique helps to provide a better user experience and improves the overall performance of the application.

How to Update Label from Sub-Threads, Sub-Tasks with Dispatcher
In WPF, we can use the Dispatcher class to update the user interface from sub-threads or sub-tasks. When a task or thread that is not the UI thread attempts to update the user interface, an exception is thrown. We can use the Dispatcher.BeginInvoke