Performing CRUD Operation with Dapper ( Open Source ORM from Stack Overflow) in MVC

Whats is Dapper?

Dapper.NET is an Open-Source, lightweight ORM developed by the developers of Stack Overflow.

They develop this ORM keeping performance in Mind.

Dapper is authored by Sam Saffron of Stack Overlfow.

One of Common things which is required by most of application is accessing data from relational database.

If we are using three layered Architecture that we Use Data access layer (DAL) for getting records from database and Perfoming various CRUD operation.

If we are using Entity FrameWork (ORM) Object relationship and mapping then we are using Dbcontext for Creating Connection and getting records from database.

Now we are going to see more simple way of access data from Database Using open source ORM called Dapper.

It is Easy to use and write as compare to Entity framework.

Here is link visit this site and learn dapper ORM .

http://www.c-sharpcorner.com/UploadFile/4d9083/performing-crud-operation-with-dapper-in-mvc/

And Also in Performance.

Comments

IList in C#

Lists and arrays implement IList. This interface is an abstraction that allows list types to be used with through a single reference type. Properties of IList Few popular property of IList interface is given below. Count:- It will return number of object in List IsReadOnly:- This property will indicate whether the IList is read-only or not. Item:- It will return the particular Item of specified index. Example :- For calling this class method in void Main. Final Output :-

Spire.Office for .NET

Introduction Free Spire.Doc for .NET is a Community Edition of the Spire.Doc for .NET, which is a totally free word component for commercial and personal use. As a free C#/VB.NET component, it also offers a lot of powerful functions. Developers can use it to generate, read, write, save, print and convert documents on any .NET applications. The featured function, conversion allows converting Word documents (Word 97-2003, Word 2007, Word 2010, word 2013) to commonly used file format, such as XML, RTF, TXT, PDF, XPS, EPUB, HTML and Image etc. Visit Site for Details :- Click Here to Visit Official Site Click here to Download Tools :- Download Here In this article we are going to learn how to generate DOC file Use Powerful tool Spire.Office for .NET Tool Required We are using Visual Studio 2012. Free Spire.Office Component [Free for commercial and personal use] Support .Net from [ 2.0 to 4.5 ] Getting Started Let’s start with cre...

List in C#

The Collection classes are a group of classes designed specifically for grouping together objects and performing tasks on them. List class is a collection and defined in the System. Collections.Generic namespace and it provides the methods and properties like other Collection classes such as add, insert, remove, search etc. The C# List < T > class represents a strongly typed list of objects that can be accessed by index and it supports storing values of a specific type without casting to or from object. Referred from :- http://csharp.net-informations.com/collection/list.htm Download Code from below link :- https://app.box.com/s/kplszfmpooytythic1b29u85uhiffo9s Example :- For calling this class method in void Main. Final output :-

dotnet-sai

Search This Blog