• Complain

Schwichtenberg - Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#

Here you can read online Schwichtenberg - Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C# full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. City: Berkeley;CA, year: 2018, publisher: Apress L.P, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Schwichtenberg Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#
  • Book:
    Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#
  • Author:
  • Publisher:
    Apress L.P
  • Genre:
  • Year:
    2018
  • City:
    Berkeley;CA
  • Rating:
    3 / 5
  • Favourites:
    Add to favourites
  • Your mark:
    • 60
    • 1
    • 2
    • 3
    • 4
    • 5

Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Chapter 1: Introducing Entity Framework Core -- Chapter 2: Installing Entity Framework Core -- Chapter 3: Concepts of Entity Framework Core -- Chapter 4: Reverse Engineering for Existing Databases (Database First Development) -- Chapter 5: Forward Engineering for New Databases -- Chapter 6: Customizing the Database Schema -- Chapter 7: Database Schema Migrations -- Chapter 8: Read Data with LINQ -- Chapter 9: Object Relationships and Loading Strategies -- Chapter 10: Inserting, Deleting, and Modifying Records -- Chapter 11: Concurrency (Preventing Conflicts) -- Chapter 12: Logging -- Chapter 13: Asynchronous Programming -- Chapter 14: Dynamic LINQ Queries -- Chapter 15: Read and Modify Data with SQL, Stored Procedures, and Table Valued Functions -- Chapter 16: Tips and Tricks for Mapping -- Chapter 17: Performance Tuning -- Chapter 18: Software Architecture with Entity Framework Core -- Chapter 19: Commercial Tools -- Chapter 20: Additional Components -- Chapter 21: Appendix A: Case Studies -- Chapter 22: Appendix B: Internet Resources -- Chapter 23: Appendix C: New Features in Entity Framework Core 2.1.;C# developers, heres your opportunity to learn the ins-and-outs of Entity Framework Core, Microsofts 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. Youll also appreciate excerpts of conceptual software architecture discussion around Entity Framework Core that might otherwise take years to learn. What Youll LearnUnderstand 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 instructionGet up to speed with valuable database access scenarios and code samplesDiscover workarounds to augment missing features in Entity Framework CoreUse Entity Framework Core to write mobile appsBonus online appendix covers Entity Framework Core 2.1 release updatesWho This Book Is ForSoftware 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.--

Schwichtenberg: author's other books


Who wrote Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#? Find out the surname, the name of the author of the book and a list of all author's works by series.

Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C# — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
Holger Schwichtenberg 2018
Holger Schwichtenberg Modern Data Access with Entity Framework Core
1. Introducing Entity Framework Core
Holger Schwichtenberg 1
(1)
Essen, Germany
In this chapter, you will learn about Entity Framework Core and how it is an OR mapper for .NET (.NET Framework, .NET Core, Mono, and Xamarin). Entity Framework Core is a completely new implementation of the ADO.NET Entity Framework.
Together with .NET Core version 1.0 and ASP.NET Core version 1.0, Entity Framework Core version 1.0 was released on June 27, 2016. Version 2.0 was released on August 14, 2017. Version 2.1 is in progress.
What Is an Object-Relational Mapper?
In the database world, relational databases are prevalent. The programming world is all about objects. There are significant semantic and syntactic differences between the two worlds, called impedance mismatch ; see https://en.wikipedia.org/wiki/Object-relational_impedance_mismatch .
Working with objects as instances of classes in memory is at the core of object-oriented programming (OOP) . Most applications also include the requirement to permanently store data in objects, especially in databases. Basically, there are object-oriented databases (OODBs) that are directly able to store objects, but OODBs have only a small distribution so far. Relational databases are more predominant, but they map the data structures differently than object models.
To make the handling of relational databases more natural in object-oriented systems, the software industry has been relying on object-relational mappers for years. These tools translate concepts from the object-oriented world, such as classes, attributes, or relationships between classes, to corresponding constructs of the relational world, such as tables, columns, and foreign keys (see Figure ). Developers can thus remain in the object-oriented world and instruct the OR mapper to load or store certain objects that are in the form of records in tables of the relational database. Less interesting tasks and error-prone ones, such as manually creating INSERT , UPDATE , and DELETE statements, are also handled by the OR mapper, further reducing the load on the developer.
Figure 1-1 The OR mapper translates constructs of the OOP world to the - photo 1
Figure 1-1
The OR mapper translates constructs of the OOP world to the relational world
Two particularly striking differences between the object model and the relation model are N:M relations and inheritance. While in an object model you can map an N:M relationship between objects through a reciprocal set of objects, you need an intermediate table in the relational database. Relational databases do not support inheritance. There are different ways of replicating, but youll learn more about that later in the book.
OR Mappers in the .NET World
When a .NET developer reads in data from a database with a DataReader or DataSet , the developer is not doing object-relational mapping at this point. Although DataReader and DataSet are .NET objects, they only manage table structures. DataReader and DataSet are untyped, nonspecific containers from the point of view of an object model. Only when the developer defines specific classes for the structures stored in the tables and copies the contents from DataSet or DataReader into these specific data structures is the developer performing OR mapping. Such manual object-relational mapping is time-consuming, tedious, and monotonous programming work for read access (especially for very wide tables). If you then want to save changes in the objects again, the work becomes an intellectual challenge because you have to be able to recognize which objects have been changed. Otherwise, you constantly have to save all the data anew, which is an absurdity in multiuser environments.
While OR mappers have long been established in the Java world, Microsoft failed to bring a suitable product to market for a long time. The first version of .NET did not include an OR mapper but limited itself to direct data access and mapping between XML documents and the relational model. In .NET 3.5, there was an OR mapper named LINQ to SQL, but it was limited to Microsoft SQL Server and had many other restrictions.
Many .NET developers have therefore set about simplifying this work with auxiliary libraries and tools. In addition to the publicly known OR mappers for .NET, you will find many in-house solutions being built.
The following are third-party OR mappers for .NET (some of them open source):
  • NHibernate
  • Telerik Data Access (aka Open Access)
  • Genome
  • LLBLGen Pro
  • Wilson
  • SubSonic
  • OBJ.NET
  • DataObjects.NET
  • Dapper
  • PetaPoco
  • Massive
  • DevExpress XPO
With LINQ to SQL, ADO .NET Entity Framework, and Entity Framework, Microsoft itself now has three ORM products. The software company has meanwhile announced that further development efforts will concentrate solely on Entity Framework Core.
Version History of Entity Framework Core
Figure shows the version history of Entity Framework Core .
Figure 1-2 Entity Framework Core version history - photo 2
Figure 1-2
Entity Framework Core version history ( https://www.nuget.org/packages/Microsoft.EntityFrameworkCore )
Major and minor versions (1.0, 1.1, and so on) indicate feature releases from Microsoft, and revision releases (1.0.1, 1.0.2, and so on) indicate bug fix releases. This book mentions the minimum version when discussing a function that requires a particular version.
Note
The Entity Framework Core tools for Entity Framework Core 1. x were released on March 6, 2017, within the framework of Entity Framework Core 1.1.1 and Visual Studio 2017. Previously, there were only preview versions of the tools. Since Entity Framework Core 2.0, the tools are always delivered with the new product releases.
Supported Operating Systems
Like the other products in the Core product family, Entity Framework Core (formerly Entity Framework 7.0) is platform independent. The Core version of the established object-relational mapper runs not only on the full .NET Framework but also on .NET Core and Mono, including Xamarin. This allows you to use Entity Framework Core on Windows, Windows Phone/Mobile, Linux, macOS, iOS, and Android.
Supported .NET Versions
Entity Framework Core 1. x runs on .NET Core 1. x , .NET Framework 4.5.1, Mono 4.6, Xamarin.iOS 10, Xamarin Android 7.0 or higher, and the Universal Windows Platform (UWP).
Entity Framework Core 2.0 is based on .NET Standard 2.0 and therefore requires one of the following .NET implementations (see Figure ):
  • .NET Core 2.0 (or higher)
  • .NET Framework 4.6.1 (or higher)
  • Mono 5.4 (or higher)
  • Xamarin.iOS 10.14 (or higher)
  • Xamarin.Mac 3.8 (or higher)
  • Xamarin.Android 7.5 (or higher)
  • UWP 10.0.16299 (or higher)
Figure 1-3 Implementations of NET Standard - photo 3
Figure 1-3
Implementations of .NET Standard ( https://docs.microsoft.com/en-us/dotnet/standard/library )
Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#»

Look at similar books to Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C#»

Discussion, reviews of the book Modern Data Access with Entity Framework Core: Database Programming Techniques for . NET, . NET Core, UWP, and Xamarin with C# and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.