Mastering Entity Framework Core - Advanced Querying, Migrations and Testing

Exploring Data Validation 5 lectures 30:25 The Course Overview This video will give an overview of the entire course Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code Exploring Data Validation 5 lectures 30:25 The Course Overview This video will give an overview of the entire course Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code The Course Overview This video will give an overview of the entire course The Course Overview This video will give an overview of the entire course The Course Overview This video will give an overview of the entire course The Course Overview This video will give an overview of the entire course This video will give an overview of the entire course This video will give an overview of the entire course Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Implementing Data Validation Using Attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes The aim of this video is to make sure we validate the data before persisting it in the database to ensure all business rules are followed. • We add validation attributes from data annotations namespace to implement basic business rules • We plug in code into DbContext to run validation rules • We need to learn built-in validation attributes Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Validation In Controllers The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API The aim of this video is to intercept invalid data in our API inside web controller instead of waiting till DbContext fires to have more flexibility in the process. • Learn how to use controller base functionality to validate models as part of model binding • See how child object validation work when we submit object graph • Explore ModelStateDictionary API Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Exposing Validation in MVC Views The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes The aim of this video is to provide helpful user hints and better experience • Understand client side unobtrusive JQuery validation that comes with ASP.NET Core • Implement client side validation in MVC views • Extend client side validation with custom attributes Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code Using Business Objects for Validation The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code The aim of this video is to use business objects for validation to provide better separation of concerns between UI and persistence layer • Make a case for business objects • Create business objects that support validation • Use AutoMapper to simplify code Advanced Query Techniques 4 lectures 30:24 Windowing Functions The aim of this video is to learn how to retrieve the data in pages using windowing functions. • We need to understand paging concepts • Learn how to use Skip() and Take() functions to accomplish paging • Discuss how to get the totals necessary to provide UI Working with Joins The aim of this video is to combine related data from multiple tables in a single results set. This is where joins come in. • Learn the joins functionality available in RDBMSs • Implement joins with query syntax • Implement joins with method syntax Left Outer Joins and Unions The aim of this video is to combine similar data from unrelated tables in a single query using unions. • Understand the left outer joins functionality available in RDBMSs • Implement left outer joins using query and method syntax • Use unions to combine and reshape the data from multiple tables Using Stored Procedures and Views The aim of this video is to use existing database assets or have a facility to optimize our data access code with database procedures and views • Learn how to execute stored procedures with DbContext API • Understand how to expose views and query them with Entity Framework • Use parameterized procedures to query data Advanced Query Techniques. 4 lectures 30:24 Windowing Functions The aim of this video is to learn how to retrieve the data in pages using windowing functions. • We need to understand paging concepts • Learn how to use Skip() and Take() functions to accomplish paging • Discuss how to get the totals necessary to provide UI Working with Joins The aim of this video is to combine related data from multiple tables in a single results set. This is where joins come in. • Learn the joins functionality available in RDBMSs • Implement joins with query syntax • Implement joins with method syntax Left Outer Joins and Unions The aim of this video is to combine similar data from unrelated tables in a single query using unions. • Understand the left outer joins functionality available in RDBMSs • Implement left outer joins using query and method syntax • Use unions to combine and reshape the data from multiple tables Using Stored Procedures and Views The aim of this video is to use existing database assets or have a facility to optimize our data access code with database procedures and views • Learn how to execute stored procedures with DbContext API • Understand how to expose views and query them with Entity Framework • Use parameterized procedures to query data Windowing Functions The aim of this video is to learn how to retrieve the data in pages using windowing functions strong ...