Code-first Entity Framework 2 with Legacy Databases
Most code generators are inflexible, but with the Entity-Framework Reverse POCO Generator, you can create code exactly how you want it. You'll learn how to reverse-engineer a legacy or current SQL Server database into Code-first Entity-Framework code.
What you'll learn
With EDMX support fading away, it's even more important to use code-first as EF7 approaches. Most generators are rigid and don't provide you any flexibility in how the code is to be generated. But in this course, Code-first Entity Framework with Legacy Databases, we will be using the "Entity-Framework Reverse POCO Generator", a free visual studio tool, available at www.ReversePoco.com. This generator has been designed from the ground up to be customizable, and produce the code you would have done if you hand-coded it yourself. This course will show you what each of the various settings has on the generated code, and you'll also learn how to create separate data and model projects, as well as create repositories, unit tests and integration tests. By the end of this course, you will be able to flexibly generate code that meets your needs.
Table of contents
- Version Check 0m
- Introduction 0m
- Module Overview 0m
- Demo Introduction 0m
- Namespace 2m
- DbContextName 1m
- DbContextInterfaceBaseClasses and MakeClassesPartial 7m
- ConnectionStringName and ConfigFilenameSearchOrder 2m
- TargetFrameworkVersion 1m
- ConfigurationClassName 1m
- GenerateSeparateFiles 2m
- UseCamelCase 4m
- IncludeComments and IncludeExtendedPropertyComments 4m
- IncludeViews 1m
- IncludeTableValuedFunctions 3m
- DisableGeographyTypes 2m
- CollectionType 4m
- AddUnitTestingDbContext 1m
- IncludeQueryTraceOn9481Flag 4m
- AdditionalNamespaces 1m
- AdditionalContextInterfaceItems 4m
- WCF 4m
- Summary 0m
- Customizing the Generated Code 0m
- Demo Introduction 1m
- Demo: Setup 3m
- Demo: Table Rename 5m
- Demo: Update Column 2m
- Demo: Enums 2m
- Demo: Stored Procedure Renaming and Return Types 2m
- Demo: Class Attributes 2m
- Demo: Base Classes 2m
- Demo: Class Body 1m
- Demo: Column Properties 2m
- Demo: English Pluralisation 4m
- Demo: Spanish Pluralisation 3m
- Summary 1m
About the author
Simon has been designing, developing software for 26 years in the UK. Simon is currently the lead developer at www.bybox.com where he spends his time creating state of the art wireless warehouse systems. He spent a few years teaching the MSDN courses for Cap Gemini Training. Simon dove into the world of mathematics and created a quantitative risk analysis and explosion modeling software for a leading oil company, and was part of the team who created the Crest settlement bank system. Simon was ... more