“Xaero” - Entity Framework Core Advanced Project

Releases

v1.0

About

The “Xaero” Project is a Movie Project which is quite big and advanced. It will manage the records of a Movie Company like:

1. The Production Company which are creating movies.
2. The Movie details containing all the information about the movies that are created.
3. The Distribution companies whose task is to distribute the movies in different countries.

There are 5 database tables to manage these stuffs and they have Relationships among themselves like – One-to-Many, One-to-One & Many-to-Many.

The Database diagram is given below.

(Don't Confuse it with the "Xaero" character of Quake 3 who carries RailGun and gives perfect headshot. I am a big fan of that character so I used his picture in the image.)

Working Video

What you will learn from this Project

Entity Framework Core is the latest and most powerful Object/Relational Mapping (O/RM) framework for performing database operations. Users will learn how to make a Professional and Advanced Project with it. They will learn:

• [x] CRUD Operations
• [x] Inserting & Updating Single, Multiple and Related records.
• [x] Reading records in Paginations (Number Paging).
• [x] One-to-Many Relationship.
• [x] One-to-One Relationship
• [x] Many-to-Many Relationship
• [x] Sorting of Records
• [x] CRUD Operations

Some Important tutorial links

1. Installation of Entity Framework Core
2. DbContext Class in Entity Framework Core
3. Migrations in Entity Framework Core
4. Insert Records in Entity Framework Core
5. Fluent API in Entity Framework Core
6. One-to-Many Relationship Entity Framework Core
7. One-to-One Relationship Entity Framework Core
8. Many-to-Many Relationship Entity Framework Core

Give a Star ⭐️

If you found this Implementation helpful or used it in your Projects, do give it a star. Thanks! Or, If you are feeling really generous, Support the Project with a small contribution!

Tech Stack

• ASP.NET Core 5.0
• Entity Framework Core 5.0
• MS SQL Server
• JavaScript
• Bootstrap 4

Getting Started

0. Make sure you have EF CLI Tools installed. Open up Powershell and run the following command dotnet tool install --global dotnet-ef
1. Clone this Repository and Extract it to a Folder.
2. Do Migrations to create the database
   Feel Free to Clone the Project and try it out. Raise any issues / requests that you may find.
3. I have posted a 10,000+ words tutorial of Xaero covering all the aspects from A to Z. Do Visit it.

Support

Support This Project to keep it active.

About the Author

YogYogi

• Blogs at yogihosting.com
• Facebook - yogihosting
• Twitter - yogihosting

Licensing

Project is licensed with the MIT License. Feel free to use it in your projects. Do share it with your friends in FB, Twitter, Linked, etc.