In This post we will learn Basic CRUD operation using ASP.Net MVC, JSON, ADO.Net, and Stored Procedure with a sample MVC Application. Our first step is to create and design a SQL Database, below step’s we have the demonstration of creating a database table and very basic CRUD Stored Procedure.
Category: MVC
IEnumerable Vs IQueryable
Differences between them based on their properties : IEnumerable Namespace: System.Collections Namespace Derives from: No base interface Deferred Execution : Supported Lazy Loading : Not Supported How does it work : While querying data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data. Hence does more work and becomes slow. Suitable for : LINQ to Object and […]