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 … Read more

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 … Read more

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 … Read more

What is OAuth?

OAuth stands for Open Authorization for token based authentication and authorization over web.OAuth was first introduced in year 2007. In year 2010 OAuth2.0 was introduced. OAuth acts as an agent for a user to fetch the information.OAuth allows a user’s account information to be used by a 3rd party such as Twitter, Facebook, Google, without … 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

RSS
YouTube
YouTube
Instagram