Entity Framework Core in Action

Entity Framework Core in Action
Author: Jon Smith
Publisher: Simon and Schuster
Total Pages: 791
Release: 2018-07-15
Genre: Computers
ISBN: 1638355940

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

Entity Framework Core in Action, Second Edition

Entity Framework Core in Action, Second Edition
Author: Jon P Smith
Publisher: Simon and Schuster
Total Pages: 622
Release: 2021-07-13
Genre: Computers
ISBN: 1638351317

"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

LINQ in Action

LINQ in Action
Author: Steve Eichert
Publisher: Simon and Schuster
Total Pages: 700
Release: 2008-01-31
Genre: Computers
ISBN: 1638354626

LLINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and database interaction. It addreses O/R mapping issues by making query operations like SQL statements part of the programming language. It also offers built-in support for querying in-memory collections like arrays or lists, XML, DataSets, and relational databases. LINQ in Action is a fast-paced, comprehensive tutorial for professional developers. This book explores what can be done with LINQ, shows how it works in an application, and addresses the emerging best practices. It presents the general purpose query facilities offered by LINQ in the upcoming C# 3.0 and VB.NET 9.0 languages. A running example introduces basic LINQ concepts. You'll then learn to query unstructured data using LINQ to XML and relational data with LINQ to SQL. Finally, you'll see how to extend LINQ for custom applications. LINQ in Action will guide you along as you explore this new world of lambda expressions, query operators, and expression trees. As well, you'll explore the new features of C# 3.0, VB.NET 9.0. The book is very practical, anchoring each new idea with running code. Whether you want to use LINQ to query objects, XML documents, or relational databases, you will find all the information you need to get started But LINQ in Action does not stop at the basic code. This book also shows you how LINQ can be used for advanced processing of data, including coverage of LINQ's extensibility, which allows querying more data sources than those supported by default. All code samples are built on a concrete business case. The running example, LinqBooks, is a personal book cataloging system that shows you how to create LINQ applications with Visual Studio 2008. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

.NET Core in Action

.NET Core in Action
Author: Dustin Metzgar
Publisher: Simon and Schuster
Total Pages: 458
Release: 2018-07-12
Genre: Computers
ISBN: 1638357048

Summary .NET Core in Action shows .NET developers how to build professional software applications with .NET Core. Learn how to convert existing .NET code to work on multiple platforms or how to start new projects with knowledge of the tools and capabilities of .NET Core. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Technology .NET Core is an open source framework that lets you write and run .NET applications on Linux and Mac, without giving up on Windows. Built for everything from lightweight web apps to industrial-strength distributed systems, it's perfect for deploying .NET servers to any cloud platform, including AWS and GCP. About the Book .NET Core in Action introduces you to cross-platform development with .NET Core. This hands-on guide concentrates on new Core features as you walk through familiar tasks like testing, logging, data access, and networking. As you go, you'll explore modern architectures like microservices and cloud data storage, along with practical matters like performance profi ling, localization, and signing assemblies. What's Inside Choosing the right tools Testing, profiling, and debugging Interacting with web services Converting existing projects to .NET Core Creating and using NuGet packages About the Reader All examples are in C#. About the Author Dustin Metzgar is a seasoned developer and architect involved in numerous .NET Core projects. Dustin works for Microsoft. Table of Contents Why .NET Core? Building your first .NET Core applications How to build with .NET Core Unit testing with xUnit Working with relational databases Simplify data access with object-relational mappers Creating a microservice Debugging Performance and profiling Building world-ready applications Multiple frameworks and runtimes Preparing for release appendix A - Frameworks and runtimes appendix B - xUnit command-line options appendix C - What's in the .NET Standard Library? appendix D - NuGet cache locations

Programming Entity Framework

Programming Entity Framework
Author: Julia Lerman
Publisher: "O'Reilly Media, Inc."
Total Pages: 920
Release: 2010-08-09
Genre: Computers
ISBN: 1449399657

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

Practical Entity Framework Core 6

Practical Entity Framework Core 6
Author: Brian L. Gorman
Publisher:
Total Pages: 0
Release: 2022
Genre:
ISBN: 9781484273029

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.

Pro Entity Framework Core 2 for ASP.NET Core MVC

Pro Entity Framework Core 2 for ASP.NET Core MVC
Author: Adam Freeman
Publisher: Apress
Total Pages: 656
Release: 2018-04-18
Genre: Computers
ISBN: 1484234359

Model, map, and access data effectively with Entity Framework Core 2, the latest evolution of Microsoft’s object-relational mapping framework. You will access data utilizing .NET objects via the most common data access layer used in ASP.NET Core MVC 2 projects. Best-selling author Adam Freeman explains how to get the most from Entity Framework Core 2 in MVC projects. He begins by describing the different ways that Entity Framework Core 2 can model data and the different types of databases that can be used. He then shows you how to use Entity Framework Core 2 in your own MVC projects, starting from the nuts and bolts and building up to the most advanced and sophisticated features, going in-depth to give you the knowledge you need. Chapters include common problems and how to avoid them. What You’ll Learn Gain a solid architectural understanding of Entity Framework Core 2 Create databases using your MVC data model Create MVC models using an existing database Access data in an MVC application using Entity Framework Core 2 Use Entity Framework in RESTful Web Services Who This Book Is For ASP.NET Core MVC 2 developers who want to use Entity Framework Core 2 as the data access layer in their projects

Entity Framework 4 in Action

Entity Framework 4 in Action
Author: Stefano Mostarda
Publisher: Manning Publications
Total Pages: 0
Release: 2011
Genre: ADO.NET (Software framework)
ISBN: 9781935182184

"Microsoft Entity Framework in Action" is an introduction to the Entity Framework for developers working in .NET who possess a working knowledge of ADO.NET.

Mobile Development with .NET

Mobile Development with .NET
Author: Can Bilgin
Publisher: Packt Publishing Ltd
Total Pages: 572
Release: 2021-04-09
Genre: Computers
ISBN: 1800206984

A mobile applications development masterclass for .NET and C# developers Key FeaturesUncover the new features and capabilities of the .NET 5 framework in this updated and improved second editionOptimize the time required to develop highly performant cross-platform applicationsUnderstand the architectural patterns and best practices for mobile application developmentBook Description Are you a .NET developer who wishes to develop mobile solutions without delving into the complexities of a mobile development platform? If so, this book is a perfect solution to help you build professional mobile apps without leaving the .NET ecosystem. Mobile Development with .NET will show you how to design, architect, and develop robust mobile applications for multiple platforms, including iOS, Android, and UWP using Xamarin, .NET Core, and Azure. With the help of real-world scenarios, you'll explore different phases of application development using Xamarin, from environment setup, design, and architecture to publishing. Throughout the book, you'll learn how to develop mobile apps using Xamarin and .NET Standard. You'll even be able to implement a web-based backend composed of microservices with .NET Core using various Azure services including, but not limited to, Azure Active Directory, Azure Functions. As you advance, you'll create data stores using popular database technologies such as Cosmos DB and data models such as the relational model and NoSQL. By the end of this mobile application development book, you'll be able to create cross-platform mobile applications that can be deployed as cloud-based PaaS and SaaS. What you will learnDiscover the latest features of .NET 5 that can be used in mobile application developmentExplore Xamarin.Forms Shell for building cross-platform mobile UIsUnderstand the technical design requirements of a consumer mobile appGet to grips with advanced mobile development concepts such as app data management, push notifications, and graph APIsManage app data with Entity Framework CoreUse Microsoft’s Project Rome for creating cross-device experiences with XamarinBecome well-versed with implementing machine learning in your mobile appsWho this book is for This book is for ASP.NET Core developers who want to get started with mobile development using Xamarin and other Microsoft technologies. Working knowledge of C# programming is necessary to get started.

Modern Data Access with Entity Framework Core

Modern Data Access with Entity Framework Core
Author: Holger Schwichtenberg
Publisher: Apress
Total Pages: 665
Release: 2018-06-27
Genre: Computers
ISBN: 1484235525

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.