sharepointcafe
ASP.Net Singleton Design Pattern
.
In the previous blog, we have seen about “What is Design Pattern?” Now this is time to explore the types of Design Pattern.Let’s start this with Singleton Design Pattern.Singleton Design pattern belongs to Creational Design Pattern. Singleton Pattern ensures that only one instance of the class exists through out the application life cycle.Singleton design pattern…
Web Service to return data in JSON format
.
Web services are those services which are available over web to communicate between systems.By default Web Service returns data in XML format, now if the requirement is to return in JSON format then we need to do modification in web method.Below webmethod returns data in JSON format. [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] …
Understanding WCF Bindings
.
Binding describes that how a client will communicate with WCF service. It tells that what protocol will be used to communicate, as WCF supports various protocols like HTTP, TCP, MSMQ, Named Pipes. Binding determine transport protocol i.e. TCP, HTTP, message exchange format i.e. plain text, XML You may go through to my earlier blogs to…
ABC of WCF
.
In this article, we will focus on ABC of WCF which is the core of WCF service endpoints. This is one of the most important interview questions. What is the ABC of WCF? ABC is the main foundation of WCF learning. WCF service comes into existence with a valid Endpoint. An endpoint consists of 3…
First WCF Service Application – WCF Tutorial
.
In this blog, I will be creating a WCF service application project. If you want to learn WCF from the beginning, please read my earlier blog. Let’s create the first WCF Service Application To create a WCF project open Visual Studio 2012 and select File->New Project. Click on WCF from an installed template (Left area)…
How to maintain page scroll position after page post back in asp.net
.
In this blog, I will write about How to maintain page scroll position after page post back in ASP.Net. Suppose there is a page with a huge number of inputs and in one case some error/exception occurs at bottom of the page. But in the postback, the page scroll position moved to the top. In…
Differences between Stored Procedure and Functions
.
Very frequent question asked in interview is Differences between Stored Procedure and Functions.Below are the differences between these 2. 1) Functions must return a value. Stored procedure need not be.2) Stored procedures can be called using EXEC command where as Functions can be called from another SQL Statement.3) Stored Procedures are precompiled. Functions are not precompiled.4) Generally Stored procedures are…
How to call ASP.Net web method using JQuery AJAX ?
.
In normal ASP.NET web forms, if you want to send any data to server your web page will be refreshed i.e. will do a post back.In some case, if you want to send data to the server without using any post back then in this case you have to use a web method at server…
Java Script Code to detect browser and apply CSS property
.
How to detect browser using Java Script Code and apply CSS property ? As we all know that IE browser behaves unexpected in some cases and need some extra CSS property or change in CSS property to work/view perfectly. Below is the code to detect browser and if browser is IE then apply or override…
Fault Contract in WCF – WCF Service Tutorial
.
In this article, we will see how to implement Fault Contract in WCF. In typical ASP.Net code we use try catch block to manage exception, but in WCF Fault Contract is used handle exception so that reason of error can reach to the client. WCF Fault Contract If you are new to WCF Contracts, please…
Data Contract vs Message Contract in WCF – WCF Service Tutorial
.
If you are new to Data Contract and Message Contract. Please read my earlier blogs. Data Contract Message in WCF Data Contract has very less control over SOAP message, while Message Contract has full control. Data Contract vs Message Contract Data Contract is used to define the structure of data which will be exchanged between…
Message Contract in WCF – WCF Service Tutorial
.
If you are new to WCF Service, please read my earlier blogs. WCF Introduction and WCF Contracts As we know the default message protocol in WCF is SOAP. Message contract is used to define the SOAP structure. As we know SOAP has Envelope, Header, and Body. So if you want control over SOAP then you must…
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…
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…
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…
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…
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…
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…
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…
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…
