Skip to main content

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

Post a Comment

Popular posts from this blog

Creating Simple Cascading DropDownList In ASP.NET Core MVC With New Tag Helpers

Topic Database part Creating application Installing Package for Entity framework core From NuGet Adding Connection string and Setting up DbContext Adding Category, SubCategory, MainProduct Model in Models Folder Adding DbSet for Category, SubCategory, and MainProduct Model in DatabaseContext class Adding Controller [DemoController] Getting Data from Database using Entity framework core. Adding View [index.cshtml] Binding Category Dropdownlist using new Tag helper Adding SubCategory and Product Dropdownlist to index.cshtml View Adding SubCategory and GetProducts Action Method to Demo Controller Adding Jquery reference on View and Default items in drop-down list Binding SubCategory and Product drop-down list with jquery Ajax Adding Index Action method for handling post request and getting selected values Saving and Run Application Read Entire Article on below link :- http://www.c-sharpcorner.com/article/creating-simple-cascading-dropdownlist-in-asp-net-core-mvc-with-...
Post a Comment
Read more

Capturing Image From Web Cam in ASP.Net MVC

This article shows how to capture an image using a webcam in MVC4 and in this application we will use a jQuery webcam.js plug-in for capturing images. I have seen that most online applications currently require webcam image capturing functionality in some way or another. Most social networking sites use this kind of functionality in their application for capturing user profile pictures. To see Complete Article Visit: -  http://www.c-sharpcorner.com/UploadFile/4d9083/capturing-image-from-web-cam-in-Asp-Net-mvc139/ Agenda Create basic MVC application. Download and Adding webcam.js related reference files to project. Adding Controller ( PhotoController ). Adding Index view. Adding Action Method Capture( ). Adding Script for capturing Image. Adding Action Method and Script for binding image. Adding [HttpPost] Index Action Method. Displaying the index View in New Window. Changephoto.cshtml Code Snippet. PhotoController Code Snippet. Index.cshtml Code ...
Post a Comment
Read more

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...
Post a Comment
Read more