[PDF] Modern Data Access With Entity Framework Core eBook

Author : Holger Schwichtenberg
Publisher : Apress
Page : 665 pages
File Size : 24,19 MB
Release : 2018-06-27
Category : Computers
ISBN : 1484235525

GET BOOK

C# developers, here’s your opportunity to learn the ins-and-outs of Entity Framework Core, Microsoft’s recently redesigned object-relational mapper. Benefit from hands-on learning that will teach you how to tackle frustrating database challenges, such as workarounds to missing features in Entity Framework Core, and learn how to optimize the performance of your applications, head-on! Modern Data Access with Entity Framework Core teaches best practices, guidance, and shortcuts that will significantly reduce the amount of resources you internally dedicate to programming data access code. The proven methods and tools taught in this book, such as how to get better performance, and the ability to select the platform of your choice, will save you valuable time and allow you to create seamless data access. Dive into succinct guidance that covers the gamut-- from installing Entity Framework Core, reverse engineering, forward engineering (including schema migrations), and data reading and modification with LINQ, Dynamic LINQ, SQL, Stored Procedures, and Table Valued Functions- to using third-party products such as LINQPad, Entity Developer, Entity Framework Profiler, EFPlus, and AutoMapper. You'll also appreciate excerpts of conceptual software architecture discussion around Entity Framework Core that might otherwise take years to learn. What You'll Learn Understand the core concepts of Entity Framework Core, as well process models for existing databases (reverse engineering) and the generation of database schemas from object models (forward engineering) Study real-world case studies for hands-on EF Core instruction Get up to speed with valuable database access scenarios and code samples Discover workarounds to augment missing features in Entity Framework Core Use Entity Framework Core to write mobile apps Bonus online appendix covers Entity Framework Core 2.1 release updates Who This Book Is For Software developers who have basic experience with .NET and C#, as well as some understanding of relational databases. Knowledge of predecessor technologies such as ADO.NET and the classic ADO.NET Entity Framework is not necessary to learn from this book.

Author : Jon Smith
Publisher : Simon and Schuster
Page : 791 pages
File Size : 46,31 MB
Release : 2018-07-15
Category : Computers
ISBN : 1638355940

GET BOOK

Summary Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. Following the crystal-clear explanations, real-world examples, and around 100 diagrams, you'll discover time-saving patterns and best practices for security, performance tuning, and unit testing. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology There's a mismatch in the way OO programs and relational databases represent data. Entity Framework is an object-relational mapper (ORM) that bridges this gap, making it radically easier to query and write to databases from a .NET application. EF creates a data model that matches the structure of your OO code so you can query and write to your database using standard LINQ commands. It will even automatically generate the model from your database schema. About the Book Using crystal-clear explanations, real-world examples, and around 100 diagrams, Entity Framework Core in Action teaches you how to access and update relational data from .NET applications. You'l start with a clear breakdown of Entity Framework, long with the mental model behind ORM. Then you'll discover time-saving patterns and best practices for security, performance tuning, and even unit testing. As you go, you'll address common data access challenges and learn how to handle them with Entity Framework. What's Inside Querying a relational database with LINQ Using EF Core in business logic Integrating EF with existing C# applications Applying domain-driven design to EF Core Getting the best performance out of EF Core Covers EF Core 2.0 and 2.1 About the Reader For .NET developers with some awareness of how relational databases work. About the Author Jon P Smith is a full-stack developer with special focus on .NET Core and Azure. Table of Contents Part 1 - Getting started Introduction to Entity FrameworkCore Querying the database Changing the database content Using EF Core in business logic Using EF Core in ASP.NET Core web applications Part 2 - Entity Framework in depth Configuring nonrelational properties Configuring relationships Configuring advanced features and handling concurrency conflicts Going deeper into the DbContext Part 3 - Using Entity Framework Core in real-world applications Useful software patterns for EF Core applications Handling database migrations EF Core performance tuning A worked example of performance tuning Different database types and EF Core services Unit testing EF Core applications Appendix A - A brief introduction to LINQ Appendix B - Early information on EF Core version 2.1

Author : Jon P Smith
Publisher : Simon and Schuster
Page : 622 pages
File Size : 18,24 MB
Release : 2021-07-13
Category : Computers
ISBN : 1638351317

GET BOOK

"The most comprehensive reference for EF Core that does—or ever will—exist." - Stephen Byrne, Intel Corporation Entity Framework Core in Action, Second Edition teaches you to write flawless database interactions for .NET applications. Summary Entity Framework Core in Action, Second Edition is an in-depth guide to reading and writing databases with EF Core. Revised from the bestselling original edition, it’s filled with over 100 diagrams, code snippets, and examples—including building and scaling your own bookselling web application. Learn from author Jon Smith’s extensive experience working with EF Core in production, as you discover time-saving patterns and best practices for security, performance tuning, and unit testing. All of the book’s code is available on GitHub. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology Entity Framework radically simplifies data access in .NET applications. This easy-to-use object-relational mapper (ORM) lets you write database code in pure C#. It automatically maps classes to database tables and enables queries with standard LINQ commands. It even generates SQL, so you don’t have to! About the book Entity Framework Core in Action, Second Edition teaches you to write flawless database interactions for .NET applications. Following relevant examples from author Jon Smith’s extensive experience, you’ll progress quickly from EF basics to advanced techniques. In addition to the latest EF features, this book addresses performance, security, refactoring, and unit testing. This updated edition also contains new material on NoSQL databases. What's inside Configure EF to define every table and column Update your schema as your app grows Integrating EF with existing C# application Write and test business logic for database access Applying a Domain-Driven Design to EF Core Getting the best performance out of EF Core About the reader For .NET developers familiar with relational databases. About the author Jon P. Smith is a freelance software developer and architect with a special focus on .NET and Azure. Table of Contents PART 1 1 Introduction to Entity Framework Core 2 Querying the database 3 Changing the database content 4 Using EF Core in business logic 5 Using EF Core in ASP.NET Core web applications 6 Tips and techniques for reading and writing with EF Core PART 2 7 Configuring nonrelational properties 8 Configuring relationships 9 Handling database migrations 10 Configuring advanced features and handling concurrency conflicts 11 Going deeper into the DbContext PART 3 12 Using entity events to solve business problems 13 Domain-Driven Design and other architectural approaches 14 EF Core performance tuning 15 Master class on performance-tuning database queries 16 Cosmos DB, CQRS, and other database types 17 Unit testing EF Core applications

Author : Prabhakaran Anbazhagan
Publisher : Packt Publishing Ltd
Page : 376 pages
File Size : 23,94 MB
Release : 2017-12-15
Category : Computers
ISBN : 1788296214

GET BOOK

Learn how to leverage the features of the new Entity Framework Core APIs and use them to build pure .NET Core applications. About This Book Learn how to effectively manage your database to make it more productive and maintainable. Write simplified queries using LINQ to acquire the desired data easily Raise the abstraction level from data to objects so teams can function independently, resulting in easily maintainable code Who This Book Is For This book is for .NET Core developers who would like to integrate EF Core in their application. Prior knowledge of .NET Core and C# is assumed. What You Will Learn Create databases and perform CRUD operations on them Understand and build relationships (related to entities, keys, and properties) Understand in-built, custom, and remote validation (both client and server side) You will learn to handle concurrency to build responsive applications You will handle transactions and multi-tenancy while also improving performance In Detail Being able to create and maintain data-oriented applications has become crucial in modern programming. This is why Microsoft came up with Entity Framework so architects can optimize storage requirements while also writing efficient and maintainable application code. This book is a comprehensive guide that will show how to utilize the power of the Entity Framework to build efficient .NET Core applications. It not only teaches all the fundamentals of Entity Framework Core but also demonstrates how to use it practically so you can implement it in your software development. The book is divided into three modules. The first module focuses on building entities and relationships. Here you will also learn about different mapping techniques, which will help you choose the one best suited to your application design. Once you have understood the fundamentals of the Entity Framework, you will move on to learn about validation and querying in the second module. It will also teach you how to execute raw SQL queries and extend the Entity Framework to leverage Query Objects using the Query Object Pattern. The final module of the book focuses on performance optimization and managing the security of your application. You will learn to implement failsafe mechanisms using concurrency tokens. The book also explores row-level security and multitenant databases in detail. By the end of the book, you will be proficient in implementing Entity Framework on your .NET Core applications. Style and approach This book is filled with various examples that will help you use Entity Framework Core 2.0 to write efficient software.

Author : Ricardo Peres
Publisher : Packt Publishing Ltd
Page : 788 pages
File Size : 30,36 MB
Release : 2020-06-25
Category : Computers
ISBN : 1789614287

GET BOOK

Explore the tools and techniques to build scalable and secured RESTful web services and web applications using C# 8 and ASP. NET Core 3.1 Key FeaturesDelve into MVC patterns, configuration, routing, and deployment to build professional-grade applicationsLearn how to integrate ASP applications with the JavaScript frameworks React, Vue, and AngularImprove the performance of applications and the development team by implementing advanced ASP.NET Core conceptsBook Description ASP.NET has been the preferred choice of web developers for a long time. With ASP.NET Core 3, Microsoft has made internal changes to the framework along with introducing new additions that will change the way you approach web development. This second edition has been thoroughly updated to help you make the most of the latest features in the framework, right from gRPC and conventions to Blazor, which has a new chapter dedicated to it. You’ll begin with an overview of the essential topics, exploring the Model-View-Controller (MVC) pattern, various platforms, dependencies, and frameworks. Next, you’ll learn how to set up and configure the MVC environment, before delving into advanced routing options. As you advance, you’ll get to grips with controllers and actions to process requests, and later understand how to create HTML inputs for models. Moving on, you'll discover the essential aspects of syntax and processes when working with Razor. You'll also get up to speed with client-side development and explore the testing, logging, scalability, and security aspects of ASP.NET Core. Finally, you'll learn how to deploy ASP.NET Core to several environments, such as Azure, Amazon Web Services (AWS), and Docker. By the end of the book, you’ll be well versed in development in ASP.NET Core and will have a deep understanding of how to interact with the framework and work cross-platform. What you will learnUnderstand the new capabilities of ASP.NET Core 3.1Become well versed in how to configure ASP.NET Core to use it to its full potentialCreate controllers and action methods, and understand how to maintain stateImplement and validate forms and retrieve information from themImprove productivity by enforcing reuse, process forms, and effective security measuresDelve into the new Blazor development modelDeploy ASP.NET Core applications to new environments, such as Microsoft Azure, AWS, and DockerWho this book is for If you are a developer with basic knowledge of ASP.NET MVC and want to build powerful applications, then this book is for you. Developers who want to explore the latest changes in ASP.NET Core 3.1 to build professional-level applications will also find this book useful. Familiarity with C#, ASP.NET Core, HTML, and CSS is expected to get the most out of this book.

Author : Julia Lerman
Publisher : "O'Reilly Media, Inc."
Page : 193 pages
File Size : 24,19 MB
Release : 2012
Category : Computers
ISBN : 1449312942

GET BOOK

Annotation Code first is an additional means of building a model to be used with the Entity Framework and is creating a lot of excitement in the .NET development community. The reader will begin with an overview of what code first is, why it was created, how it fits into the Entity Framework and when to use it over the alternatives.

Author : Brian L. Gorman
Publisher :
Page : 0 pages
File Size : 23,64 MB
Release : 2022
Category :
ISBN : 9781484273029

GET BOOK

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 Learn Build robust and maintainable databases using a code first approach Create and execute stored procedures, triggers, and functions Analyze and optimize performance of database queries Ensure data integrity through keys, constraints, and relationships Encrypt your database columns at rest with TDE and Always-On Encryption Leverage the FluentAPI and attributes for entity configuration.

Author : Julia Lerman
Publisher : "O'Reilly Media, Inc."
Page : 920 pages
File Size : 39,2 MB
Release : 2010-08-09
Category : Computers
ISBN : 1449399657

GET BOOK

Get a thorough introduction to ADO.NET Entity Framework 4 -- Microsoft's core framework for modeling and interacting with data in .NET applications. The second edition of this acclaimed guide provides a hands-on tour of the framework latest version in Visual Studio 2010 and .NET Framework 4. Not only will you learn how to use EF4 in a variety of applications, you'll also gain a deep understanding of its architecture and APIs. Written by Julia Lerman, the leading independent authority on the framework, Programming Entity Framework covers it all -- from the Entity Data Model and Object Services to WCF Services, MVC Apps, and unit testing. This book highlights important changes for experienced developers familiar with the earlier version. Understand the core concepts you need to make the best use of the EF4 in your applications Learn to query your data, using either LINQ to Entities or Entity SQL Create Windows Forms, WPF, ASP.NET Web Forms, and ASP.NET MVC applications Build and consume WCF Services, WCF Data Services, and WCF RIA Services Use Object Services to work directly with your entity objects Create persistent ignorant entities, repositories, and write unit tests Delve into model customization, relationship management, change tracking, data concurrency, and more Get scores of reusable examples -- written in C# (with notes on Visual Basic syntax) -- that you can implement right away

Author : Derek J. Rouleau
Publisher : Apress
Page : 345 pages
File Size : 16,99 MB
Release : 2018-03-02
Category : Computers
ISBN : 1484233751

GET BOOK

Use the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain. Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings. By eliminating tedious data access code that developers are otherwise forced to use, Entity Framework Core 2.0 enables you to work directly with the data in a database through domain-specific objects and methods. Beginning Entity Framework Core 2.0 is a carefully designed tutorial. Throughout the book you will encounter examples that you can use in your day-to-day coding, and you will build a solid foundation on which to create database-backed applications. If you are looking for a way to get started without getting buried under details you are only going to forget, then this is the book for you. The author aims to leave you comfortably able to connect to, access, modify, and delete data from a relational database. The book provides a clear, straightforward approach and includes code that you can look back at months later and understand. What You'll Learn Study easy-to-follow, real-world examples you can use every day Focus on DbContext and the Database First approach Understand how to work with single and multiple tables Use the LINQ query language to manipulate data Who This Book Is For C# and ASP.NET programmers looking for an easier way of accessing data in a relational database than writing in SQL—a way that meshes better into object-oriented application development

Author : Mark J. Price
Publisher : Packt Publishing Ltd
Page : 819 pages
File Size : 42,39 MB
Release : 2019-10-31
Category : Computers
ISBN : 1788471571

GET BOOK

Publisher's Note: Microsoft stops supporting .NET Core 3.1 in December 2022. The newer 7th edition of this book is available that covers .NET 7 (end-of-life May 2024) or .NET 6 (end-of-life November 2024), with C# 11 and EF Core 7. Key FeaturesBuild modern, cross-platform applications with .NET Core 3.0Get up to speed with C#, and up to date with all the latest features of C# 8.0Start creating professional web applications with ASP.NET Core 3.0Book Description In C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development, Fourth Edition, expert teacher Mark J. Price gives you everything you need to start programming C# applications. This latest edition uses the popular Visual Studio Code editor to work across all major operating systems. It is fully updated and expanded with new chapters on Content Management Systems (CMS) and machine learning with ML.NET. The book covers all the topics you need. Part 1 teaches the fundamentals of C#, including object-oriented programming, and new C# 8.0 features such as nullable reference types, simplified switch pattern matching, and default interface methods. Part 2 covers the .NET Standard APIs, such as managing and querying data, monitoring and improving performance, working with the filesystem, async streams, serialization, and encryption. Part 3 provides examples of cross-platform applications you can build and deploy, such as web apps using ASP.NET Core or mobile apps using Xamarin.Forms. The book introduces three technologies for building Windows desktop applications including Windows Forms, Windows Presentation Foundation (WPF), and Universal Windows Platform (UWP) apps, as well as web applications, web services, and mobile apps. What you will learnBuild cross-platform applications for Windows, macOS, Linux, iOS, and AndroidExplore application development with C# 8.0 and .NET Core 3.0Explore ASP.NET Core 3.0 and create professional web applicationsLearn object-oriented programming and C# multitaskingQuery and manipulate data using LINQUse Entity Framework Core and work with relational databasesDiscover Windows app development using the Universal Windows Platform and XAMLBuild mobile applications for iOS and Android using Xamarin.FormsWho this book is for Readers with some prior programming experience or with a science, technology, engineering, or mathematics (STEM) background, who want to gain a solid foundation with C# 8.0 and .NET Core 3.0.