LINQ with an MVC Project

This blog contains basic information about LINQ. Also, we will see how can we use LINQ in an MVC project. What is LINQ? LINQ stands for Language Integrated Query. LINQ can be used to query from a variety of data sources for eg  SQL Server, Array, and XML. LINQ defines keywords that you can use … Read more

How to insert Data using Entity Framework

If you are new to Entity Framework, then read my earlier blog – Introduction to Entity FrameworkThis blog will help you about How to insert data into sql using Entity Framework.I have used Database first model approach.HTML File: <html xmlns=”http://www.w3.org/1999/xhtml”> <head>     <title></title>     <script src=”js/jquery.min.js”></script>     <script>         function SubmitData() {             var name … Read more

Introduction to Entity Framework – Entity Framework Tutorial

In my another blog, I have explored about ASP.Net and ASP.Net Core. In this blog, we will see about Entity Framework. What is Entity Framework? Entity Framework is an object-relational mapping which allows developers to work with relational databases. Entity Framework is an open source framework. What is ORM? Before starting with Entity Framework lets know … Read more

Create a login module using Entity Framework

If you are new to Entity Framework then read my earlier blog on this.In this blog I will explain about how to create a login module using entity framework. Create a login module using Entity Framework Create Table Script: /****** Object:  Table [dbo].[Admin]    Script Date: 16/08/2016 10:45:45 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER … Read more

The underlying provider failed to open – Entity Framework Error

I found this error – “The underlying provider failed to open” while I was working on Entity framework project. I searched this and found the solution.Inner Exception says: Cannot open database “xxxx” requested by the login. The login failed.Login failed for user ‘xxxxx’. How to solve underlying Provider failed error? Go to web.config and make changes … Read more