ntity framework Resources

Share

Related resources for ntity framework

Dynamic Mapping Database result to Entity T5/20/2024 7:16:04 AM. This article provides logic for Mapping the SQL Result to C# Class. This code snippet demonstrates the dynamic mapping of SQL result columns to C# properties, converting SNAKE_CASE SQL column names to
Dotnet Core, EF Core Store Procedure With Multiple Results5/20/2024 6:33:57 AM. Entity Framework Core coupled with stored procedures for SQL database data retrieval encounters a constraint: consistent return of all columns required for DbQuery<T> properties. This alternativ
Difference between ADO.NET, ORM and Dapper5/20/2024 4:39:12 AM. This article explores ADO.NET, ORM, and Dapper in the .NET ecosystem, detailing their history, evolution, and best practices and providing C# code examples for effective data access management.
A Simple Step to Entity Framework: Code First Approach5/17/2024 11:02:24 AM. Learn the foundational steps of Entity Framework's Code First approach in this straightforward guide. Dive into database development with ease using C# and Visual Studio, mastering Object-Relation
Table Splitting in Entity Framework 6 (Code First Approach)5/17/2024 10:42:39 AM. Table Splitting in Entity Framework 6 (Code First Approach) allows multiple entity types to map to a single database table. This technique is useful for organizing related data within the same table,
Entity Framework's Database Seed Method5/17/2024 10:35:16 AM. In this article, we will learn Entity Framework Database Seed Method that allows you to seed some dummy data in the database for testing purposes.
Working With Change Tracking Proxy in Entity Framework 6.05/17/2024 10:21:30 AM. In this article, you will learn about Proxy Objects, ObjectStateManager, and EntityState to leverage advanced tracking features for data manipulation and performance optimization in your .NET applicat
Get Comma Separated Values From SQL Server Using Entity Framework (EF)5/17/2024 10:20:28 AM. Learn how to retrieve data from SQL Server using Entity Framework (EF) in C#. This tutorial covers querying with LINQ, transforming results into comma-separated values (CSV), and leveraging EF's d
Entity Framework: Code First Data Annotations5/16/2024 11:28:54 AM. Entity Framework code First approach allows us to use our POCO (domain) classes as model and Entity framework is use this classes to querying data, change tracking and other updating function.
Inserting Data Into Multiple Tables In MSSQL At Once In .NET (Affecting Multiple Rows)5/16/2024 8:33:44 AM. Efficiently insert data into multiple SQL tables in .NET using ADO.NET transactions, ensuring atomicity and data integrity across affected rows for robust database operations.
Working With Stored Procedures Using Entity Framework: Part 15/16/2024 8:32:00 AM. Learn how to leverage Entity Framework for interacting with stored procedures in your .NET applications. This tutorial explores integrating stored procedures into your data access layer, optimizing da
3 Ways of Doing Optimistic Locking in .NET5/16/2024 8:31:32 AM. In this article we will touch base 3 ways of doing optimistic locking i.e. Using ADO.NET dataset, SQL Server Timestamp check and old / new value check.
New Features in .NET 4.5 and 5.05/16/2024 5:51:25 AM. Discover the latest enhancements in .NET with versions 4.5 and 5.0. Explore async programming using async/await, improved performance, Entity Framework updates, ASP.NET Core (in .NET 5.0), enhanced LI
Entity Framework: DbComparisonExpression Requires Arguments With Comparable Types5/16/2024 5:44:07 AM. The "DbComparisonExpression Requires Arguments With Comparable Types" error in Entity Framework indicates a type mismatch in a query comparison. It occurs when attempting to compare two valu
Pre-Generated Views With a Code First Model Entity Framework 6.05/16/2024 5:39:46 AM. Pre-generated views in Entity Framework 6.0 with a Code First model enhance performance by reducing the cost of view generation at runtime. By pre-compiling these views, you can significantly improve
Entity Framework (0), Overview5/16/2024 5:36:28 AM. In this article, you will learn about entity framework (0), Overview, concept, and approaches.
Entity Framework (0-1), Overview Additions5/16/2024 5:35:32 AM. This article will add some additions for Entity Framework Overview.
Entity Framework (1), With .Net MVC, Code-First5/16/2024 5:33:58 AM. Setup Entity Framework with .Net MVC in Visual Studio 2019, with Code-First approach
Entity Framework (5), With .Net Core MVC, Database-First5/16/2024 5:33:27 AM. This article will describe Entity Framework with .Net Core MVC, Database-First approach,
Entity Framework (2), With .Net MVC, Database-First5/16/2024 5:08:39 AM. This article will be Entity Framework with .Net MVC, Database-First approach,
Entity Framework (7), With .NET WPF, Database-First5/16/2024 5:08:19 AM. This article describe to develop a WPF app with entity framework, database first approach.
Tips for Improving Performance in Entity Framework5/15/2024 5:30:04 AM. Optimizing Entity Framework performance, particularly in EF Core, is crucial for efficient data access. These strategies, like eager loading and compiled queries, enhance responsiveness and reduce ove
Association in Entity Framework5/14/2024 11:00:56 AM. Entity Framework manages associations between entities in databases, facilitating relationships like one-to-one, one-to-many, and many-to-many. Through navigation properties and various mapping strate
Deciding the Right Data Reading Architecture in .NET5/11/2024 2:26:25 PM. In the dynamic realm of .NET development, choosing the right data reading architecture is paramount for application performance, scalability, and maintainability. Let's delve into practical exampl
CRUD using the Repository Pattern in MVC5/10/2024 7:59:18 AM. This article introduces the repository pattern in an MVC application. Repository pattern is intended to create an abstraction layer between the data access layer and the business logic layer of an app
CRUD Operations Using Entity Framework 5.0 Code First Approach in MVC5/9/2024 11:56:39 AM. Perform CRUD operations in MVC using Entity Framework 5.0's Code First approach. Define entity classes, utilize DbContext and LINQ for data access, and generate views and controllers with scaffold
Entity Framework: Code First Migrations With the Existing Database5/9/2024 11:52:10 AM. Explore Entity Framework's Code First Migrations to seamlessly integrate existing databases with your application. Learn efficient techniques for data modeling, schema synchronization, and version
Role Based Authorization In Blazor 5/9/2024 10:24:11 AM. Role-Based Authorization in Blazor enables access control based on user roles. By defining roles and policies, specific functionalities or resources can be restricted to users with certain roles. Blaz
Building CRUD Operations in .NET Core 8 with MongoDB5/9/2024 4:48:33 AM. Learn to create CRUD operations in .NET Core 8 Minimal API with MongoDB via Entity Framework Core. Build RESTful endpoints for seamless data interaction, leveraging ASP.NET Core's capabilities for
Stored Procedures With Entity Framework5/8/2024 9:54:50 AM. Stored procedures in Entity Framework offer a way to execute database logic from within your .NET application. Utilize EF's capabilities to map and execute stored procedures efficiently, enhancing
Relationship in Entity Framework Using Code First Approach With Fluent API5/7/2024 11:23:34 AM. Learn how to establish relationships in Entity Framework using the Code First approach with Fluent API. Explore configuring one-to-one, one-to-many, and many-to-many relationships using navigation pro
Simple Insert And Select (CRUD) Operation Using .NET Core MVC With ADO.NET And Entity Framework Core5/7/2024 10:33:55 AM. Learn to perform basic CRUD operations in .NET Core MVC using both ADO.NET and Entity Framework Core. Build a robust data access layer for seamless integration with your web application.
Inject a DbContext Instance Into BackgroundService in .NET Core5/5/2024 8:28:55 AM. In this article, Learn how to inject and use a DbContext instance within a BackgroundService in .NET Core. Utilize dependency injection to access database operations from a background task, ensuring p
Database Connectivity in Visual Studio 5/3/2024 9:16:16 AM. Visual Studio facilitates robust database connectivity through technologies like ADO.NET and Entity Framework. Developers can seamlessly integrate with SQL Server, MySQL, Oracle, and more using connec
CRUD Operation Using Single Stored Procedure In ASP.NET MVC Of Real-Time Project5/2/2024 10:03:03 AM. Explore ASP.NET MVC's streamlined CRUD operations using a single stored procedure in a real-time project. Leverage Entity Framework, SQL Server, and ViewModel mapping for efficient database intera
Implement Many-To-Many Relationship in C# Class5/1/2024 11:13:30 AM. Learn to implement a many-to-many relationship in C# using collections and junction tables. Explore how to model associations between entities, use LINQ queries for retrieval, and leverage tools like
Multi-Tenant Migrations With Entity Framework 6.0 (Code First Model)5/1/2024 11:04:59 AM. Master multi-tenant migrations in Entity Framework 6.0 with ease. Learn seamless data management strategies for code-first models, ensuring robust and efficient database migrations in a multi-tenant e
Filter WebGrid With Cascading Dropdownlist Along With Paging in MVC4/30/2024 9:54:32 AM. This tutorial provides a comprehensive guide for developers new to MVC, offering step-by-step instructions for creating a basic MVC application using Visual Studio 2012 and integrating features like P
SQL Server Primary & Foreign Key Association: Visual C# Entity Framework 4/30/2024 9:52:50 AM. Learn how to establish primary key and foreign key relationships in SQL Server using Visual C# 2010 and Entity Framework. This tutorial covers creating database tables, defining primary keys, and esta
NHibernate in Details: Part 24/30/2024 9:49:29 AM. Dive deeper into NHibernate with Part 2, exploring advanced topics like session management, querying, and performance optimization. Uncover the intricacies of this powerful object-relational mapping t
Code First Migrations With Entity Framework4/30/2024 9:39:59 AM. This article will provide answers to the following questions relevant to relationships in Entity Framework: whether or not to create a database, how to add / remove a field from an existing table, how
Real-Time Text Display in Power Apps 4/30/2024 9:16:05 AM. Explore the seamless integration of real-time text input updates with Power Apps. Discover how effortlessly display text input changes dynamically in labels, enhancing user interaction and engagement.
Entity Framework Core in .NET Core: MySQL Code-First Migration4/30/2024 9:15:07 AM. This article walks you through how to use EF Core 5.0 in .NET Core 3.1 to implement a code-first approach to create/update a MySQL database on Visual Studio 2019 for a RESTful API application.
💠 Clean Architecture End To End In .NET 54/30/2024 9:06:48 AM. Explore the implementation of Clean Architecture in ASP.NET 5.0, covering aspects like Entity Framework Code First Approach, Dependency Injection, AutoMapper for object-object mapping, JWT Authenticat
.NET Core : Implementing Authentication & Authorization in .NET Core Apps4/30/2024 3:40:13 AM. This article provides a structured guide with code snippets and references for implementing authentication and authorization in .NET Core applications. It covers mechanisms such as Identity framework,
Entity Framework Core: Features, Real-time Implementation, Best Practices4/29/2024 10:27:09 AM. Entity Framework Core (EF Core) stands as a powerful toolset for .NET developers, streamlining the interaction between applications and databases through object-relational mapping (ORM). Whether adopt
Working With Multiple Tables in MVC Using Entity Framework4/29/2024 10:12:37 AM. Learn how to effectively work with multiple database tables in ASP.NET MVC using Entity Framework. Explore entity relationships, database modeling, and data access strategies.
Complex Custom Validation Attribute Specific to Entity4/29/2024 9:59:12 AM. Complex custom validation attributes tailored for entities in Entity Framework enable validation logic beyond standard rules. These attributes empower precise data validation, ensuring compliance with
Seed Databases in EntityFramework4/29/2024 9:58:30 AM. Seeding databases in Entity Framework simplifies initial data setup. Utilize migrations and DbContext to seed essential data, ensuring a consistent database state. This approach streamlines developmen
Entity Framework - Database First Approach4/29/2024 9:54:15 AM. Learn Database First approach with Entity Framework. Utilize existing databases to create entity models. Use the ADO.Net Entity Data Model to connect. Customize model options including pluralizing, i
Database First Approach in MVC 5: Part 24/25/2024 10:41:59 AM. In MVC 5's Database First Approach (Part 2), delve deeper into leveraging Entity Framework for seamless integration with existing databases. Explore scaffolded views, data validation, and CRUD ope
Database First Approach in MVC 5: Part 14/25/2024 10:10:15 AM. This article shows the development of an ASP.NET Web application in an MVC 5 project template that connects with a database that exists already and allows the users to interact with the data.
Database First Approach in MVC 5: Part 34/25/2024 8:02:50 AM. Learn advanced techniques in database design, Entity Framework Designer, and building robust Data Access Layers within the Model-View-Controller architecture.
Table Splitting in Entity Framework4/25/2024 5:56:24 AM. Entity Splitting in Entity Framework involves mapping an entity across multiple database tables, aiding in organizing data and optimizing performance. Table Splitting divides a single table into two,
Enum Support (Code First) in Entity Framework 54/24/2024 1:51:17 PM. Entity Framework 5 introduces enhanced support for enums in Code First development. Enums can now be seamlessly integrated into entity classes, offering a more structured approach to representing fixe
Entity Framework Code First Example4/24/2024 1:24:22 PM. Explore an Entity Framework Code First example to understand database modeling in C#. This tutorial demonstrates object-relational mapping (ORM) techniques, using .NET Framework to create entity class
Data Annotations and Code First Migration in Entity Framework4/24/2024 1:18:51 PM. Explore the seamless integration of Data Annotations and Code First Migration within the Entity Framework. Learn how to leverage annotations to define data models and relationships, and master the art
Mapping TVFs Using Entity Framework Database First4/24/2024 7:43:49 AM. Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
Entity Framework 6 CRUD Stored Procedures: Code-First Approach4/23/2024 11:22:38 AM. Learn how to implement Insert, Update, and Delete operations using stored procedures in Entity Framework 6 with a Code First approach. This tutorial covers setting up stored procedures, mapping them t
Preview of Dynamic Data and Entity Data For EF 64/23/2024 7:23:32 AM. The preview of Dynamic Data and Entity Data for EF 6 introduces efficient database connectivity and modeling within the .NET Framework. It enables seamless integration of data with code through Entity
Logging Database Operations in Entity Framework4/22/2024 8:53:24 AM. Discover Entity Framework 6's new feature: logging database operations. Easily debug and troubleshoot performance issues by logging SQL commands, parameters, timestamps, and more. Customize loggin
Update Data Using Code First Approach4/22/2024 7:44:10 AM. Explore updating data with ASP.NET and Entity Framework's Code First approach. Define Employee model, set up DbContext, and create a Webform for user input. Implement logic to update employee det
Insert and Select Data in Entity Object Generator4/18/2024 1:14:07 PM. Learn to efficiently manage data with Entity Object Generator through inserting and selecting operations. Master CRUD tasks, harnessing Entity Framework's power for seamless database interaction,
Delete and Update Data With Entity State (Deleted) Via EDF Framework4/18/2024 1:13:26 PM. Explore how to manipulate data using Entity State (Deleted) and (Modified) via EDM Framework in ASP.NET applications. Learn to delete and update data efficiently by managing entity states. Utilize ASP
Select Data Using Complied Query4/18/2024 11:13:18 AM. Learn how to optimize data retrieval in your application by utilizing compiled queries. This technique, often employed in Entity Framework and LINQ, enhances performance by pre-compiling queries, resu
Select and Insert Data With Entity State (Unchanged) Via EDF Framework4/18/2024 10:44:37 AM. Utilize Entity Data Framework (EDF) to select and insert data with Entity State (Unchanged) for efficient data manipulation. Leverage EDF's change tracking mechanisms to maintain object state, ens
Select Data Using Spatial Types Via EDF Framework 5.04/18/2024 10:28:09 AM. Explore the utilization of spatial types for data retrieval in Entity Data Model Framework 5.0. Learn how to design entities, create a web application, and implement data retrieval using Entity Frame
Select Data With Enums Via EDF Framework 5.04/18/2024 8:46:39 AM. Utilize Entity Framework 5.0 to select data with enums. Employ LINQ queries for efficient data retrieval, leveraging strong-typed enums for enhanced code readability and database querying.
Working With Temporal Tables In EF Core 6.04/18/2024 8:46:18 AM. Get started with creation of SQL Server Temporal Tables using Entity Framework Core 6.0 Code First approach and querying the historical data using LINQ.
Reducing Complexity Using Entity Framework Core Owned Types4/18/2024 8:45:52 AM. Simplify data modeling in Entity Framework Core with Owned Types. Streamline database schema and relationships, reducing complexity in code-first approaches. Enhance maintainability and readability wi
GraphQL In .NET Core Web API With Entity Framework Core - Part Four4/18/2024 8:20:28 AM. In this article, we will explore advanced GraphQL integration in .NET Core Web API with Entity Framework Core. Part Four delves into optimized data access, schema design, and API development for robus
A Comprehensive Guide to Entity Framework Core in .NET 84/16/2024 10:54:12 AM. Explore the comprehensive guide to Entity Framework Core in .NET 8, enriched with the latest features of C# 10. Authored by Ziggy Rafiq, this detailed overview covers everything from basic concepts to
Installing EF Core with Empty Template in ASP.NET MVC Core 3.04/15/2024 11:49:21 AM. Discover how to seamlessly integrate Entity Framework Core into your ASP.NET MVC Core 3.0 application using an empty template. Follow a step-by-step installation guide to set up the data access layer
Enable Identity Core With Empty Template In ASP.NET MVC core 3.04/15/2024 11:48:04 AM. Learn how to integrate Identity Core into an empty template in ASP.NET MVC Core 3.0. Explore authentication and authorization features, configure user management, and enhance security.
How to Insert Console Application with Entity Framework 4/15/2024 11:41:37 AM. Learn how to seamlessly integrate a console application with Entity Framework for efficient database operations. Explore how to perform CRUD (Create, Read, Update, Delete) operations within your .NET
Combine ADO.NET, EF Core And Dapper In Same Blazor App 4/15/2024 11:09:08 AM. Discover the power of combining ADO.NET, EF Core, and Dapper within a single Blazor application. Seamlessly integrate these data access technologies to leverage the strengths of each, enhancing perfor
Pagination in a .NET with EF Core4/15/2024 5:20:15 AM. Pagination allows you to retrieve a large number of records split into pages instead of returning all the results at once. In this article, I present how to implement OffSet and Keyset pagination in a
CRUD Operation with Dapper Using ASP.NET Core4/13/2024 5:08:16 PM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
Soft Delete in Entity Framework Core4/8/2024 7:15:23 AM. Soft delete in Entity Framework Core allows for logically marking records as deleted without physically removing them from the database. This technique involves setting a flag, often "IsDeleted,&
Multi-Tenancy with Separate Databases Approach in .NET Core4/8/2024 5:44:25 AM. In this article, we will learn how to implement a separate database approach of multi-tenancy in the .Net Core application and how to provide a dynamic connection string to DbContext
Model in ASP.Net MVC : Part 14/2/2024 9:15:36 AM. The Model in MVC encapsulates application logic, excluding view and controller logic. It manages data and performs operations. This article guides through creating and utilizing a Model class in an MV
Database First Approach With ASP.NET MVC Step By Step Part 14/1/2024 9:47:43 AM. In this article, I will demonstrate you about Database First Approach in Entity Framework and will also show how to implement it with ASP.NET MVC.
Difference between IEnumerable vs IQuerable4/1/2024 6:34:21 AM. Understand the difference between IEnumerable and IQueryable in .NET collections. While IEnumerable is suitable for in-memory collections, IQueryable allows for optimized queries, especially in scenar
Seamless Database Integration with C#3/26/2024 5:50:08 AM. Efficiently integrating databases with C# applications is crucial for managing data seamlessly. Explore various approaches like ADO.NET, Entity Framework Core, and Dapper along with best practices for
Soft Deletion in Entity Framework Core3/23/2024 6:35:46 AM. In this article, we will delve into the concept of soft deletion and illustrate how to implement it effectively with EF Core.
Learn Everything About REST API3/21/2024 6:31:08 AM. This tutorial covers building a full-fledged application with WPF, REST API, and Entity Framework. It emphasizes the importance and implementation of REST APIs, discussing CRUD operations and their re
Implementing Common Audit Fields With EF Core’s Shadow Property3/11/2024 9:25:16 AM. Implement audit fields in EF Core using shadow properties for efficient tracking of entity modifications. Utilize Entity Framework's built-in functionality to automatically update created and modi
GraphQL In .NET Web API With Entity Framework Core - Part One3/11/2024 9:22:06 AM. In this article, we will learn about the step-by-step implementation of GraphQL in a Web API using ASP.NET Core, including database setup, scaffolding, configuration, repository creation, and GraphQL
Shadow Properties In Entity Framework Core3/7/2024 11:32:17 AM. Entity framework core added many new features that are already present in older entity framework versions. One of the features of the Entity framework core is "Shadow Properties". The featur
Code First Approach in Entity Framework3/7/2024 11:28:21 AM. This content provides a comprehensive guide on implementing Entity Framework's code-first approach in ASP.NET MVC applications. It begins with an introduction to Entity Framework, highlighting its
Entity Framework Core 5.0 - An Introduction To What's New 3/7/2024 11:26:50 AM. Discover the latest features in Entity Framework Core 5.0, including improved performance, enhanced LINQ capabilities, migration enhancements, and streamlined database schema management.
GraphQL In .NET Core Web API With Entity Framework Core - Part Three3/7/2024 8:58:59 AM. Explore GraphQL integration in .NET Core Web API using Entity Framework Core in Part Three of this series. Learn to efficiently query data with C# backend development, enhancing API capabilities.
New Features Of Entity Framework Core 2.03/7/2024 8:53:53 AM. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
Shadow Properties In Entity Framework Core3/7/2024 8:52:35 AM. In this article, you will learn Entity Framework Core's shadow properties, and hidden fields in the model that aren't mapped to the database schema directly. Learn how to leverage them for met
Connected And Disconnected Scenarios in Entity Framework3/7/2024 8:45:09 AM. In this article, we will explore the intricacies of data handling in Entity Framework through connected and disconnected scenarios. Learn how to manage data manipulation, state tracking, and persisten
Entity Framework Core Triggers In Action (Unofficial Package)3/7/2024 8:44:28 AM. This article shows you how to work with database triggers in Entity Framework Core using a third-party library and Entity Framework Core Triggers with this unofficial package, enhancing database opera
Code Only Design using ADO.NET Entity Framework 4.0 3/7/2024 8:43:43 AM. This code snippet implements Code Only Design in ADO.NET Entity Framework 4.0, connecting to a SQL Server database, configuring entities, and binding data to a GridView with exception handling.
Practical Introduction to Entity Framework: Day 63/6/2024 10:40:13 AM. In this article, you will Explore Day 6 of our Practical Introduction to Entity Framework series, diving deeper into database integration. Learn essential concepts, including object-relational mapping
Practical Introduction To Entity Framework: Day 53/6/2024 10:39:36 AM. Day 5 of our practical introduction to Entity Framework delves deeper into database management with advanced concepts like relationships and efficient CRUD operations. Explore Entity Framework Core fo
Practical Introduction To Entity Framework: Day 43/6/2024 10:36:48 AM. This content provides a detailed guide on returning multiple result sets or data sets in Entity Framework. It walks through the steps involved, including creating a normal stored procedure, adding an

Topics