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

What are Idempotent and Non-Idempotent methods?

After reading this article, you will be confident about Idempotent and Non-Idempotent methods?Let’s start by understanding the meaning of Idempotent.Idempotent means  “unchanged in value following multiplication by itself” Idempotent Methods Idempotent HTTP methods are those methods which will not make any modification event after calling multiple times.For eg – If your client makes a DELETE request by … Read more

Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported – Entity Framework

In the previous blog, we have seen about Entity Framework.In this blog, we will see error resolution related to Data binding directly to a store query. In Visual Studio 2015 I was using Entity Framework and wrote a code to bind data with GridView. I wrote the normal Linq and browse my web page. And … 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

How to create secure Web API in asp.net

In my earlier blog I wrote about how to create a web api in asp.net , now your WebAPIi is ready to work. Web API security is very important especially if you are allowing it to external users to consume it.Now suppose you want to control your web api in the context of security. How you … 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

Business Connectivity Service in SharePoint 2013

In this blog, we will see what’s new in BCS in SharePoint 2013. BCS stands for Business Connectivity Services which returns the result to the user through an external list or data sources.BCS allows us to perform operations with external data sources like MS-SQL, MS-Access etc. Create, Read, Update and Delete operation can be performed … Read more

Design Patterns in ASP.Net

If you are an ASP.Net developer or any other programming technologies, then you must have came across the word Design Patter.In this blog, we will see What are design patterns and their types What are Design Patterns? Design patterns provide efficient and re-usable solutions in software development.There are several design patterns available, each patterns have … Read more

Dispose vs Close

In this blog, we will see the differences between Dispose() and Close() What are the differences between Dispose() and Close() Dispose() and Close() function for is used to dispose or close SharePoint server objects like SPWeb, SPSite. Purpose of these 2 methods is same. So which one is better to use? It is better to … Read more

SharePoint 2013 Installation step by step

In this blog, I will explain about SharePoint 2013 installation on Windows Server 2008 R2, which I did recently on my system.Below is minimum software requirement for SharePoint 2013 installation.OS-  Windows Server 2008 R2 (Service Pack1) or aboveSQL Server – SQL Server 2008 SP1 or above.Double click on setup file and you will see below … Read more

RSS
YouTube
YouTube
Instagram