Map complex types of stored procedure - Entity Framework

Jun 03, 2019 BY xtreme

We can map complex types of stored procedure with the Entity Framework Designer (EF Designer) either Auto or Manually .  Step 1 : Create Stored Procedure Make sure the last select statement should not be a dynamic statement Step 2: add your stored procedure to the EDMX file (when you...

List of ORM libraries - Asp.Net

Jun 03, 2019 BY xtreme

An Object Relation Mapping(ORM) library helps developers to create data access applications by programming against a conceptual model instead of programming against a relational database model. Advantage of ORMs 1. RDBMS independent data access layer development 2. rapid application developme...

How to use Stored Procedure In Entity Framework

Jun 02, 2019 BY xtreme

Using ADO.NET Modelpublic IEnumerable<resultModel> GetReport(int? id) { List<resultModel> result = new List<resultModel>(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString())) { using (SqlCommand cmd = new SqlC...