Resources   No resource found

• Difference between ADO.NET, ORM and DapperMay 20, 2024. 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.
• Insight.Database .NET Micro ORM - Executing And Carrying Out SELECT SQL CommandsJan 09, 2023. Insight. The database micro-format for.NET is quick, light, and, dare we say it, fantastic. SQL commands are simple to run using Insight. SqlCommand class and parameters are no longer used. AddWithValue. Insight automatically converts command arguments from an object.
• Insight.Database , .NET Micro ORM - Write Less Code In Data Access Layer Using Auto Interface ImplementationNov 07, 2021. In this article, you will learn about Insight.Database is a fast, lightweight, (and dare we say awesome) micro-orm for .NET. Auto Interface Implementation implements the interface for you automatically, and you can just call the method, with full type-safety and full performance of IL-generated code.
• Dapper Micro ORM (Connection Management)Jul 12, 2021. In this article, you will learn about Database Connection Management in Dapper ORM.
• Learn ASP.NET Core MVC With MSSQL Using Dapper ORM (RESTful) And Swagger UIJan 18, 2019. In this article, we will learn ASP.NET Core MVC with MSSQL using dapper asynchronously in the data access layer and testing API in Swagger UI.
• Using NPoco ORM In ASP.NET CoreFeb 27, 2018. As you know, we have so many ORM available such as NHibernate, Entity Framework, Dapper.Net which are used to communicate with database in order to perform CRUD (Create, Read, Update, Delete), and also retrieving data based on criteria.
• Get Return Value From Stored Procedure Using Dapper ORM In ASP.NET MVCApr 11, 2016. In this article we will learn how to get return value from stored procedure using Dapper ORM in ASP.NET MVC.
• Automatic Table Generation in Any Database by NHibernate ORM and CodeDomMar 28, 2015. This article describes how to allow users to build a database automatically from an application via two technologies, code generation (CodeDOM) and NHibernate (Fluent) that let us make a backend regardless of the type of database and without involving complicated concepts.
• Dapper - King of Micro ORM (C#.NET)Mar 03, 2015. This article explains what the Object Relationship Mapper (ORM) Dapper is and how to use Dapper for ORM.
• Building a Better ORM With NHIbernate For .NETFeb 15, 2015. In this article you will learn how to build a better ORM with NHIbernate for .NET.
• Performing CRUD Operation With Dapper ( Open Source ORM From Stack Overflow) in MVCJul 14, 2014. This article explains how to use Dapper and do CRUD operations with Dapper in MVC.
• Entity Framework Performance Improvements with Code ExamplesJun 23, 2024. Learn how to optimize Entity Framework performance with practical code examples. This guide covers essential techniques to enhance database efficiency, improve query performance, and eliminate bottlenecks.
• Optimizing Performance with Dapper with .NET Core API May 30, 2024. Learn Dapper best practices for optimal database interaction in .NET applications. Explore techniques like using output parameters and handling multiple result sets in stored procedures. Enhance efficiency with optimized query writing for delete operations.
• Implementing CURD Using Dapper(ORM) With C# WebAPIMar 28, 2023. In this article, you will learn how to implement CURD using Dapper(ORM) with C# WebAPI.
• Working With Parameters In Dapper ORMDec 26, 2022. In this article, I'm going to explain how we can get values from In, Out, and return parameters while working with Dapper ORM
• ORM Vs Stored Procedures In ProgrammingAug 10, 2022. In this article, you will learn about ORM vs Stored Procedures in Programming.
• CRUD Operation In ASP.NET Core 2.0 Using Dapper ORMAug 20, 2018. In this article, we will learn CRUD operation in ASP.NET Core 2.0 using Dapper ORM step by step. We will use Visual Studio 2017 to develop the web application using ASP.NET Core 2.0 with razor pages using Dapper. If you don’t have a basic idea of ASP.NET Core and how to set up ASP.NET Core Environment. How to install Visual Studio 2017. Then Please go with my previous article as follow.
• ASP.NET MVC CRUD With Dapper (Micro ORM)Jun 30, 2017. In this article, you will learn about CRUD (Create, Retrieve, Update, Delete) functionality in ASP.NET MVC with the help of DAPPER, the Micro ORM tool.
• CRUD Operation In ASP.NET MVC Using jQuery JSON With Dapper ORMMar 25, 2016. In this article we will learn how to make CRUD operations in ASP.NET MVC using jQuery JSON with Dapper ORM.
• CRUD Operations In ASP.NET MVC 5 Using Dapper ORMSep 27, 2015. In this article we will learn to make CRUD operations in ASP.NET MVC 5 using Dapper ORM.
• ORM Designer for Entity FrameworkMay 21, 2015. This article describes the Entity Developer tool Devart.
• New HTML5 Form Attributes-Part 2Feb 27, 2013. In this article I describe the implementation and use of the Form Attribute, Formaction Attribute and Formenctype Attribute of HTML5.
• Tips to Improve Entity Framework PerformanceFeb 11, 2013. There are some points that we should consider while designing and querying databases using the Entity Framework ORM.
• Object Relational Mapping (ORM) Using NHibernate - Part 8 of 8Jan 20, 2013. In this article we clear the question from the end of the first article, How do we manage a persistent object across sessions? .
• Object Relational Mapping (ORM) Using NHibernate - Part 7 of 8Nov 16, 2012. In this seventh article and its client code, we will demonstrate that the classes we have put forth to incorporate the shipping functionality will allow shipment items of an order to be shipped in parts by multiple shipping services.
• Object Relational Mapping (ORM) Using NHibernate - Part 6 of 8Nov 02, 2012. We will discuss one of four ways of mapping inheritance hierarchies in Nhibernate; the way which gives maximum support for inheritance and polymorphism (the main benefit of capturing an inheritance heirarchy). This is called Table Per Subclass.
• Object Relational Mapping (ORM) Using NHibernate: Part 5 - B of 8Oct 25, 2012. The idea here is to apply the Many-To-Many entity association in the E-Commerce scenario used, for example, throughout this article series.
• Object Relational Mapping (ORM) Using NHibernate - Part 5 - A of 8Oct 16, 2012. This is Part 5A of the article series, which concentrates on Many-to-Many Entity Association with a commonly used example but the model and code is a little different.
• Object Relational Mapping (ORM) Using NHibernate - Part 4 of 8Oct 16, 2012. Here in this article the intent is to eliminate the nulls introduced in the database by correctly mapping the association between PaymentApprovedOrder and Item as optional One-To-Many.
• Object Relational Mapping (ORM) Using NHibernate - Part 3 of 8Oct 08, 2012. Firstly in part 1 of this article series, it had been shown that in ORM, while mapping a one-to-one association between objects to their corresponding tables, the primary key of one table is posted as a foreign key of the other table. But in ORM, mapping a one-to-many association is done differently
• Object Relational Mapping (ORM) Using NHibernate - Part 2 of 8Sep 28, 2012. Object-Relational Mapping (ORM) is a programming technique that allows developers to interact with a relational database using object-oriented programming paradigms. It bridges the gap between the object-oriented domain model used in application code and the relational database model used for data storage. ORM frameworks like NHibernate facilitate the mapping between objects and database tables, automating much of the data access and manipulation processes.
• Object Relational Mapping (ORM) Using NHibernate - Part 1 of 8Sep 24, 2012. To establish the ideas of Object Relational Mapping Internals, Nhibernate fundamentals, Intemediate and Advanced coding concepts using NHibernate more clearly (for me and hopefully to readers).
• Active Application Watcher in .NET Using Windows FormsJan 26, 2007. This application will help out a user to know how much time , he is spending on each application every day. This application assumes that the window, which is active as the application on which the user is working.
• Django Web Framework Model Class with ExampleMay 29, 2025. Learn how Django's Model class works with simple examples. Understand how to define data structures, interact with databases, and build dynamic web apps using Django ORM in Python.
• Mastering Named, Positional, and Input/Output Parameters in Stored Procedures with EF CoreMay 22, 2025. Understanding Name Parameters, Positional Parameters, Input/Output Parameters, and Their Usage in Stored Procedures with EF Core
• Improved CRUD operations for GridView with Redshift in ASP.NET Core MVC (Utilizing C# 14 Features)May 08, 2025. Learn how to enable CRUD operations in an ASP.NET Core MVC application using Amazon Redshift and C# 14 features. This guide covers setup, connection, SQL commands, data manipulation, security, and best practices.
• Prevent Accidental Data Deletion with Two Simple StrategiesMar 25, 2025. Recently, I came across several discussions on Communities where users shared their experiences with accidental data deletion.
• Getting Started with EF Core: Part 1Feb 24, 2025. Entity Framework Core (EF Core) is a powerful ORM for .NET applications, simplifying database interactions. In this comprehensive guide (Part 1), we’ll cover the basics, including setup, configuration, and the code-first approach.
• Power of Dapper in .Net Core Feb 16, 2025. Dapper is a high-performance micro ORM for .NET Core, known for its speed and efficiency in database access. It simplifies SQL execution, object mapping, and data retrieval while maintaining flexibility.
• A Better .NET SQL Builder: KnightMoves.SqlObjectsFeb 04, 2025. KnightMoves.SqlObjects is a .NET SQL builder that is built entirely on objects, making it orders of magnitude more powerful and feature-rich than any string manipulating SQL builder could ever be. If you use SQL in your .NET application with ORMs like Dapper, for example, this library is for you.
• ADO.NET vs Entity Framework: Understanding the DifferencesFeb 03, 2025. This article compares ADO.NET and Entity Framework (EF), two popular data access technologies in .NET. It explores their differences in performance, data manipulation, and development approaches like code-first vs database-first, helping developers choose the right tool for their application needs.
• Generic Repository with EF Core Store Procedure in .NET Core 8Jul 16, 2024. Entity Framework Core (EF Core) empowers .NET developers with seamless database interaction through object-relational mapping (ORM) and support for stored procedures. It optimizes performance by executing complex SQL logic directly on the server, enhancing efficiency for CRUD operations.
• Working with Entity Framework CoreJul 15, 2024. Entity Framework Core (EF Core) is a powerful Object-Relational Mapping (ORM) framework provided by Microsoft for .NET applications. It simplifies data access and persistence by allowing developers to work with databases using .NET objects, thus abstracting away the complexity of database interactions.
• Programming in Practice - Structural DataMay 19, 2024. In object-oriented programming, the basic way to create structural data is to define custom types and interconnect them using references. Let's analyze this case using sample code in the context of intentionally programmed relationships between items.
• Entity Framework Core: Features, Real-time Implementation, Best PracticesApr 29, 2024. 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 adopting a database-first or code-first approach, EF Core simplifies data access and manipulation.
• API Development Using Dapper and Microsoft Asp.NET Core Web API Dec 24, 2023. ASP.NET Core is a powerful framework for building web applications, and "Dapper" is a popular micro ORM (Object-Relational Mapping) that works well with ASP.NET Core for database operations. Dapper provides a simple way to interact with databases using raw SQL queries while mapping the results to objects.
• ASP.NET Core MVC CRUD Application with DapperOct 24, 2023. Learn how to build a robust CRUD application in ASP.NET MVC with Dapper, a lightweight and efficient ORM library.
• Data Access with Dapper.NETAug 30, 2023. Streamline data access with Dapper.NET, a lightweight ORM for .NET apps. Learn its key features like speed, lightweight design, raw SQL support, and automatic object mapping. Delve into practical examples showcasing basic and parameterized queries, plus stored procedure usage. Embrace Dapper.NET's efficiency for optimal data access in your .NET development journey.
• Fetching Multiple Tables With Dapper In .NET 7 APIDec 20, 2022. In this article, I'm going t explain how we can fetch multiple tables using dapper in Dot NET 7 API
• Get Started With Entity Framework Core Using SQLiteDec 13, 2022. In this article, you will learn about entity framework core using SQLite.
• Introduction Of The Entity Framework Core 6.0Oct 12, 2022. In this article, you will learn about Entity Framework Core 6.0.
• Symmetrical Repository Pattern - Data Access Made Easy In .NETMay 09, 2022. In this article, I will describe an interesting pattern that can be implemented to make it trivial to perform CRUD/RESTful data access across a full-stack .net system, with this technique that abstracts away the boilerplate.
• .NET Core NUGET packages Jul 05, 2021. In this article, you will learn about the best NuGet packages we can select while developing restful microservices.
• Entity Framework DBFirst Approach - Step-By-Step GuideJun 22, 2020. This article is important with respect to the ORM tool Entity framework.
• Create A Blazor Server SPA With Dapper Nov 17, 2019. In this post, we will see how to create a single page application in Blazor Server with Dapper ORM. We will see all the CRUD operations with Dapper using native SQL commands and stored procedures.
• Using Dapper For Data Access In ASP.NET Core ApplicationsNov 11, 2019. Dapper is a lightweight ORM for ASP.NET Core, offering efficient data access with minimal overhead. It simplifies database interactions by mapping query results to objects, enhancing performance in web applications.
• ASP.NET Core Web API With Oracle Database And DapperMay 30, 2018. This guide explores the creation of a Web API using ASP.NET Core, integrating with an Oracle Database through the Dapper ORM. Learn how to set up a robust backend service, implement CRUD operations, and optimize database interactions.
• Django ModelsMay 09, 2018. This article is the fifth one in the Django series. I'll be talking about creating and manipulating models.
• New Features Of Entity Framework Core 2.0Feb 28, 2018. 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 article explains the new features of EF Core 2.0.
• Introduction To Entity Framework CoreOct 26, 2016. Explore the basics of Entity Framework Core in this introduction. Learn how EF Core simplifies data access in .NET Core applications through Object-Relational Mapping (ORM).
• Display Multiple Tables Data in Single View From DataBase in ASP.NET MVC Using DapperApr 18, 2016. In this article we will learn how to display multiple table records from DataBase tables in ASP.NET MVC using Dapper.
• NHibernate OverviewJun 30, 2015. In this article you will learn about NHibernate. NHibernate is a popular open-source .Net ORM. It is based on the popular Java ORM framework and built on top of ADO.NET.
• Code First Approach in MVC Using Entity FrameworkApr 15, 2015. This article shows how to use the Code First Approach in MVC using the Entity Framework.
• Entity Framework Code First ExampleJan 19, 2015. 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 classes and DbContext for seamless interaction with a database.
• NHibernate in Details: Part 1Jan 11, 2015. In this article you will learn how to use Hibernate with .NET or other programming language.
• Practical Introduction To Entity Framework: Day 5Aug 18, 2014. 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 for robust data modeling and seamless database interactions.
• Working With Stored Procedures Using Entity Framework: Part 1Jul 04, 2014. 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 database interactions, and enhancing performance using Entity Framework with SQL Server.
• Practical Introduction To Entity Framework: Day 1Jun 09, 2014. In this article, we will discover the fundamentals of Entity Framework in this practical introduction. Learn about ORM concepts, database operations, and CRUD operations through hands-on examples.
• C# Corner Chandigarh Chapter Meet, August 3, 2013 Official RecapAug 07, 2013. C# Corner Chandigarh Chapter has organized its second in-person event on the Third of August 2013. It was a house full of attendees who came across to attend this event. Thanks to all who joined us.
• CRUD using the Repository Pattern in MVCJul 29, 2013. 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 application.
• Connecting the MVC Application Using EntityFramework DB-First Approach: Part 3Jul 13, 2013. The article is an attempt to overcome the confusion related to how to use EntityFramework with MVC application in a very simple way.
• Code Review Checklist and Guidelines for C# DevelopersJun 08, 2013. This is a general Code Review checklist and guidelines for C# Developers, that will serve as a reference point during development.
• Silverlight 4 LINQ to SQL Classes in VS 2010Jul 14, 2011. LINQ to SQL is an ORM (stands for Object Relational Mapper/Mapping), which provides a data access layer for the application.
• Creating an Entity Data Model (Entity Framework 4.0)Feb 22, 2011. The ADO.NET Entity Framework is a new data access platform from Microsoft for writing .NET applications. It is a set of technologies in ADO.NET that helps fill in the space between object-oriented.
• Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIOct 06, 2008. This article contains a very simple ADO.NET Entity Framework application to update and delete the data to the database using ADO Entity Framework.
• Getting started with ADO.NET Entity Framework in .NET 3.5Sep 30, 2008. This article contains a very simple ADO.NET Entity Framework application to display and add the data to the database using ADO Entity Framework.