Determine your object relational mapper (ORM) of choice for enterprise applications using .NET Framework, and especially .NET Framework Core 3.1 and higher. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework begins with a simple overview of the two most common approaches to working with databases—database first and code first—and then focuses on working in a code first manner. Taking the code first approach allows the entire database to be built and maintained in code so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to thedatabase that is easily tracked in source control. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architecturalroles, and will be responsible for database design and implementation

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsEncrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configurationWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsEncrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configurationWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

Improve your odds of passing one of the most highly sought-after exams for developers working with Microsoft’s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development.Chapters in this book correspond directly to the exam skills outline and are delivered in a “from-the-ground-up” approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions.As you work through each chapter, you will get an introduction to the topic of the chapter followed by a comprehensive discovery of the key elements of the Azure service(s) being covered. You’ll be guided through solutions by studying typical, real-world scenarios. Each chapter concludes with review questions to solidify your learning and includes links to the corresponding Microsoft Learn modules that are relevant to the concepts in the chapter and associated with each section of the AZ-204 exam.What You Will LearnKnow the essential platform services of AzureDevelop and deploy secure and robust web solutionsArchitect and create serverless solutionsManage containers in the Azure Containers ecosystemChoose the correct messaging and event-handling tools for your applicationsMaster real-world examples and challenges that help prepare you for the AZ-204 examWho This Book Is ForDevelopers planning to take the AZ-204 exam, and developers who want to learn more about development on the most common Azure platform services

Improve your odds of passing one of the most highly sought-after exams for developers working with Microsoft’s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development.Chapters in this book correspond directly to the exam skills outline and are delivered in a “from-the-ground-up” approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions.As you work through each chapter, you will get an introduction to the topic of the chapter followed by a comprehensive discovery of the key elements of the Azure service(s) being covered. You’ll be guided through solutions by studying typical, real-world scenarios. Each chapter concludes with review questions to solidify your learning and includes links to the corresponding Microsoft Learn modules that are relevant to the concepts in the chapter and associated with each section of the AZ-204 exam.What You Will LearnKnow the essential platform services of AzureDevelop and deploy secure and robust web solutionsArchitect and create serverless solutionsManage containers in the Azure Containers ecosystemChoose the correct messaging and event-handling tools for your applicationsMaster real-world examples and challenges that help prepare you for the AZ-204 examWho This Book Is ForDevelopers planning to take the AZ-204 exam, and developers who want to learn more about development on the most common Azure platform services

Determine your object relational mapper (ORM) of choice for enterprise applications using .NET Framework, and especially .NET Framework Core 3.1 and higher. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework begins with a simple overview of the two most common approaches to working with databases—database first and code first—and then focuses on working in a code first manner. Taking the code first approach allows the entire database to be built and maintained in code so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to thedatabase that is easily tracked in source control. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architecturalroles, and will be responsible for database design and implementation

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsEncrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configurationWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

Take a developer journey that paves the way to enterprise-level database access from .NET and C# using the object-relational mapper (ORM) of choice. This second edition is revised to cover Entity Framework Core 5 and 6 (EF) and includes new content on table-per-type mapping, LINQ improvements (filtered includes), many-to-many navigation changes, split queries, simple logging using the DBCommandInterceptor, and other improvements available in EF Core 6. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions. Throughout the text, actual problems, questions, and common pitfalls are provided to help you recognize optimal solutions for maximum success in the different application scenarios you might encounter. Practical Entity Framework Core 6 focuses on the code first approach to developing a database. Taking the code first approach allows the entire database to be built and maintained in code using EF Core 6 so there is never a situation in which you cannot restore the database schema. Additionally, the code first approach creates an entirely transparent record of changes to the database that is easily tracked in source control systems such as GitHub. Emphasis throughout the book is on leaving you well positioned to architect and lead data development efforts for your organization.What You Will LearnBuild robust and maintainable databases using a code first approachCreate and execute stored procedures, triggers, and functionsAnalyze and optimize performance of database queriesEnsure data integrity through keys, constraints, and relationshipsEncrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configurationWho This Book Is For.NET developers who work with enterprise-level applications and need to interact with data structures and data within the back end data store, developers who want to take a code first approach to building database applications to prevent conflicts and optimize efficiency, and those who are moving into full-stack roles, or into senior and architectural roles, and will be responsible for database design and implementation

Improve your odds of passing one of the most highly sought-after exams for developers working with Microsoft’s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development.Chapters in this book correspond directly to the exam skills outline and are delivered in a “from-the-ground-up” approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions.As you work through each chapter, you will get an introduction to the topic of the chapter followed by a comprehensive discovery of the key elements of the Azure service(s) being covered. You’ll be guided through solutions by studying typical, real-world scenarios. Each chapter concludes with review questions to solidify your learning and includes links to the corresponding Microsoft Learn modules that are relevant to the concepts in the chapter and associated with each section of the AZ-204 exam.What You Will LearnKnow the essential platform services of AzureDevelop and deploy secure and robust web solutionsArchitect and create serverless solutionsManage containers in the Azure Containers ecosystemChoose the correct messaging and event-handling tools for your applicationsMaster real-world examples and challenges that help prepare you for the AZ-204 examWho This Book Is ForDevelopers planning to take the AZ-204 exam, and developers who want to learn more about development on the most common Azure platform services

Improve your odds of passing one of the most highly sought-after exams for developers working with Microsoft’s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development.Chapters in this book correspond directly to the exam skills outline and are delivered in a “from-the-ground-up” approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions.As you work through each chapter, you will get an introduction to the topic of the chapter followed by a comprehensive discovery of the key elements of the Azure service(s) being covered. You’ll be guided through solutions by studying typical, real-world scenarios. Each chapter concludes with review questions to solidify your learning and includes links to the corresponding Microsoft Learn modules that are relevant to the concepts in the chapter and associated with each section of the AZ-204 exam.What You Will LearnKnow the essential platform services of AzureDevelop and deploy secure and robust web solutionsArchitect and create serverless solutionsManage containers in the Azure Containers ecosystemChoose the correct messaging and event-handling tools for your applicationsMaster real-world examples and challenges that help prepare you for the AZ-204 examWho This Book Is ForDevelopers planning to take the AZ-204 exam, and developers who want to learn more about development on the most common Azure platform services