Curso Entity Framework Core C# e Bônus
Master .NET Core data persistence! Learn the core technology + 3 bonuses. Boost your career & stand out.
Course Content
Curso Entity Framework Core C# e Bônus is an all-levels Udemy course taught by Carlos Andrade. It runs 10h 20m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 3.7 out of 5 from 4 reviews, with 36 students enrolled. It is a paid course, last updated June 2024.
Unlock your potential as a full-stack developer with this comprehensive course covering data persistence in .NET! Go beyond the basics of Entity Framework Core and master LINQ and ADO .NET to significantly boost your career prospects.
This course is meticulously designed to teach you the core technologies for interacting with databases, focusing on ADO .NET and Entity Framework Core, with LINQ as your primary tool for data manipulation. Each module includes downloadable projects to reinforce your learning.
What you'll learn:
Entity Framework Core
- Project Setup: Learn to create new projects and select the appropriate packages for Entity Framework Core.
- Database Context Configuration: Understand and configure your database context for seamless data access.
- Data Annotations: Master DataAnnotations for defining your data model directly within your C# code.
- Column Mapping (DataAnnotations): Map database columns to your entities using DataAnnotations.
- Foreign Key Mapping (DataAnnotations): Establish relationships between tables using DataAnnotations for Foreign Key constraints.
- Navigation Properties: Implement navigation properties for easy traversal of relationships.
- Fluent API: Explore the power of the Fluent API for more complex and flexible data model configuration.
- Column Mapping (Fluent API): Map database columns using the Fluent API.
- Foreign Key Mapping (Fluent API): Define Foreign Key relationships using the Fluent API.
- Relationship Types: Understand and implement various relationship types including:
- One-to-Many
- Many-to-Many
- One-to-One
- Code Refactoring & Best Practices: Learn to write clean, maintainable code with industry-standard refactoring techniques.
- Developer Challenge: Apply your knowledge to solve real-world development problems.
- Repository Pattern: Implement the Repository Pattern for improved data access logic.
- Final Challenge: A comprehensive project to solidify your understanding.
Data Operations
- Query Operations: Execute various queries to retrieve data efficiently.
- Insert Operations: Learn to insert new records into your database.
- Update Operations: Modify existing data in your database.
- Delete Operations: Remove data from your database.
Include&TheInclude: Efficiently load related data with theIncludeandTheIncludemethods.AsNoTracking: Optimize query performance by usingAsNoTracking.
Repository Pattern (Bonus)
- Base Repository: Create a reusable base class for your repositories.
- Repository Creation: Implement repositories for different entities.
- Repository Interfaces: Define clear interfaces for your repository implementations.
- Repository Pattern Structure: Understand the overall structure and benefits of the Repository Pattern.
Hands-on Practice
- Homework Assignments: Reinforce your learning with practical exercises.
LINQ (Bonus)
- What is LINQ?: Understand the fundamentals of LINQ (Language Integrated Query).
- Database Creation: Learn to create and manage databases.
- Table Creation: Create tables within your database.
- Queries & Filters: Write powerful queries with various filters.
- Table Joins: Combine data from multiple tables using different join types.
- XML Manipulation: Learn to manipulate XML data within your queries.
LIKEOperator: Use theLIKEoperator for pattern matching.- Mathematical Operations: Perform mathematical calculations within your queries.
- Grouping & Aggregation: Use grouping and aggregation functions for data analysis.
- Extension Methods: Extend the functionality of LINQ with custom extension methods.
- Subqueries: Write complex queries using subqueries.
- Real-World Examples: Explore numerous practical examples of LINQ usage in development.
ADO .NET (Bonus)
- Diagram Creation: Create visual representations of your database schema.
- Model Structures: Design efficient and scalable data models.
- Best Practices: Follow industry best practices for ADO .NET development.
- Adapter Usage: Learn to use adapters for improved database interaction.
ExecuteReader: UtilizeExecuteReaderfor retrieving data.ExecuteNonQuery: UseExecuteNonQueryfor executing data modification statements.ExecuteScalar: Retrieve a single scalar value from the database.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.