Friday, 29 January 2016

WCF Data Services with ASP.NET Application to Expose Data as oData


Download Solution from here

WCF Data Services (formerly ADO.NET Data Services,) is a platform for what Microsoft calls Data Services. It is actually a combination of the runtime and a web service through which the services are exposed. WCF Data Services exposes data, represented as Entity Data Model (EDM) objects, via web services accessed over HTTP. The data can be addressed using a REST-like URI. The data service, when accessed via the HTTP GET method with such a URI, will return the data. The web service can be configured to return the data in either plain XML, JSON or RDF+XML. In the initial release, formats like RSS and ATOM are not supported, though they may be in the future. In addition, using other HTTP methods like PUT, POST or DELETE, the data can be updated as well. POST can be used to create new entities, PUT for updating an entity, and DELETE for deleting an entity.

Create ASP.NET application to expose data as OData

I will be walking you through creating an ASP.NET application that utilizes a WCF (Windows Communication Foundation) data service, along with the WCF Data Services Entity Framework Provider to render the data  as an OData endpoint.

In this article, I will be using Visual Studio 2015 Community version, which you can download for free by going to this link and clicking the Download button under Visual Studio Community.

You will create a sample data service that uses WCF Data Services to expose an Open Data Protocol (OData) feed that is based on the FaithDb sample database. The task involves the following basic steps:

  1. Create an ASP.NET Web application.

  2. Define the data model by using the Entity Data Model tools.

  3. Add the data service to the Web application.

  4. Enable access to the data service.

Create an ASP.NET Web application.

Once you have, open it up and create an ASP.NET Web Application using the Visual C# empty template. Name the project Faith.FaithDataService and save it somewhere on your local drive (see image below).

To define the data model

  1. In Solution Explorer, right-click the name of the ASP.NET project, and then click Add New Item.

  2. For the name of the data model, type ArticleModel.edmx.

  3. In the Entity Data Model Wizard, select Generate from Database, and then click Next

  4. Connect the data model to the database by doing one of the following steps, and then click Next:

    • If you do not have a database connection already configured, click New Connection and create a new connection.

    • If you have a database connection already configured to connect to the FaithDbdatabase, select that connection from the list of connections.

  5. On the final page of the wizard, select the check boxes for all tables in the database, and clear the check boxes for views and stored procedures.

  6. Click Finish to close the wizard.

To create the data service

  1. In Solution Explorer, right-click the name of your ASP.NET project, and then click Add New Item.

  2. In the Add New Item dialog box, select WCF Data Service.For the name of the service, type OurDataService.By default, the code-editor window opens. In Solution Explorer, the service will have the name, OurDataService, with the extension .svc.cs or .svc.vb

  3. In the code for the data service, replace the comment /* TODO: put your data source class name here */ in the definition of the class that defines the data service with the type that is the entity container of the data model, which in this case is NorthwindEntities. The class definition should look this the following:

    IMPORTANT POINT:Incase you are using entity framework 6 you need to install WCF Data service Entity Framework Provider like shown below

    Replace the base type of your DataService. For EF 5 or below, your data service should inherit from DataService<T> where T is a DbContext or ObjectContext. For EF 6 or greater, your data service should inherit from EntityFrameworkDataService<T> where T is a DbContext like shown below

To enable access to data service resources

  1. In the code for the data service, replace the placeholder code in the InitializeService function with the following:

    This enables authorized clients to have read and write access to all resources .You can set it for the specified entity sets also.

Next & Final Steps

You have successfully created a new data service that exposes an OData feed that is based on the FaithDbsample database, and you have enabled access to the feed for clients that have permissions on the ASP.NET Web application. Next, you will start the data service from Visual Studio and you will access the OData feed by submitting HTTP GET requests through a Web browser:

Run Application and Set OurDataService.srv as startup Page or directly view ourservice.srv in browser  The output will be shown like shown below

if you will observe It is showing list of tables from database or list of entities Model is made of.

Same way you can check other entities like


Hope this Helps

Thursday, 21 January 2016

Simple way to Develop , Build and Deploy your windows AZURE Cloud Service

AZURE Cloud Service

In this article, we are going to walk through how to create  and deploy your Windows AZURE Cloud Service.
It also provides a good introduction on how to quickly  create and set up your Windows AZURE Cloud Service for deployment.

Cloud Computing

The "cloud" in cloud computing can be defined as the set of hardware, networks, storage, services, and interfaces (I.T Infrastructure) that combine to deliver aspects of computing as a service. Cloud services can be software, infrastructure, and storage over the Internet (either as separate components or a complete platform) based on user demand.
It can also be defined next stage in the Internets evolution, providing the means by which everything — from computing power to computing infrastructure, applications and business processes can be delivered to you as a service wherever and whenever you need and will be charged on basis of usage like we use electricity and pay on basis of monthly usage..

Some businesses, such as Google and Amazon, already have most of their IT resources in the cloud. They have found that it can eliminate many of the complex constraints from the traditional computing environment, including space, time, power, and cost.
Now coming to Microsoft they have also setup cloud computing for their customers known as AZURE.


Microsoft way of cloud computing :) Windows Azure is Microsoft's application platform for the public cloud. You can use this platform in many different ways. For instance, you can use Windows Azure to build a web application that runs and stores its data in Windows Azure data centers. You can use Windows Azure just to store data, with the applications that use this data running on-premises (that is, outside the public cloud). You can use Windows Azure to create virtual machines for development and test or to run SharePoint and other applications. You can use Windows Azure to build massively scalable applications with lots and lots of users. Because the platform offers a wide range of services, all of these things-and more-are possible.

Develop,Build and Deploy your windows AZURE Cloud Service in Steps

If you already have an account, connect by clicking on PORTAL


  • Click on CLOUD SERVICE tab and  Click New (+ New)
Here it is possible to create a Quick Cloud Service and configure it again later or create a custom cloud service by chosing configuration.
  • So lets create a Quick Cloud Service and fill parameters such as URL, REGION OR AFFINITY GROUP , SUBSCRIPTION. Next click on link Create Cloud Service

  • Service created screen
Our Cloud Service is now created Quickly or Customized, lets get Azure SDK Tools so as to code our service logic.
  • Click on OurCustomersService and click on link install a Windows AZURE SDK, and our Visual Studio Version and Install it.
Here we are going to create a WCF Service and deploy it on our cloud Service.
  • So, create a new Project ,chose Windows Azure Cloud Service template and WCF Service Web Role.
web role provides an environment for running web sites or applications as supported by Internet Information Services (IIS) 7.0

  • WCF web Service (OurCustomersService.svc) looks like as shown below:

  • To test this service locally first just create console application ,windows or web what ever you are comfort with .just fallow below steps
  1.   I will create windows console application to test this service


 Now Deployment

  • To deploy our Cloud Service, we have to Create a Package : chose our Service Configuration and Build Configuration and note the output directory or remove files to our custom directory.
  • Next , Go back again to our Portal, click on OurCustomersService,  and click on link New production deployment
  • Next  chose a deployment name and our Package and configuration files
  • Now reference our Cloud Service and test It

Hope this help..


Friday, 15 January 2016

Seventh (7th) Pay Commission 2016 Salary (Pay Scale) Calculation.

Seventh (7th) Pay Commission 2016 Salary (Pay Scale) Calculation.

To get your expected salary including expected pay scale and pay band. Please enter the following things in the text boxes.

  1. Current Basic Pay Scale as per 6th Pay Commission
  2. Your Current HRA in Percentage as per 6th Pay Commission
  3. Your Current TA in Percentage as per 6th Pay Commission
Approx. Value
Approx. Value
2.25 of Old TA
Approx Value

  1. Recommended 2.5 factor pay increase in average
  2. DA 5 %
  3. HRA 8%, 16% ,24% as eligibility
  4. TA increased factor 2.25
  5. Cash handling allowance and SB allowance abolished
Note:This 7th CPC calculator calculates your basic and gross pay based on the new pay scale structure that is announced by the Pay Commission. This new Pay Scale is termed as 'Pay Matrix'.

Sunday, 10 January 2016

How to retrieve a visitor's IP address,Region and other details


Every visitor i mean any user coming to your website/web application has an IP address. If  you want to keep track of user ip address along with other details. I
The issue  is when they're behind a proxy . So, here are the code snippets in ASP and .Net that first check for an IP addresses that's forwarded from behind a proxy, and if there's none then just get the IP address.

And here's the IP retriever with proxy detection in .Net (C#)

public string IpAddress()
    string strIpAddress;
    strIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
    if (strIpAddress == null)
       strIpAddress = Request.ServerVariables["REMOTE_ADDR"];
    return strIpAddress;
And here's the same IP retriever with proxy detection in .Net, but in VB.Net (CODE BEHIND FILE OR FUNCTIONS)

Public Function IpAddress()
    Dim strIpAddress As String
    strIpAddress = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
    If strIpAddress = "" Then
       strIpAddress = Request.ServerVariables("REMOTE_ADDR")
    End If
    IpAddress = strIpAddress
End Function
Now question is how you retieve all the details like counry,region,region code ,latitite and logitute
Here is the complate code for getting all details about user 
 private string GetVisitor()
//client connecting to a web server through an HTTP proxy or load balancer
String ip = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (string.IsNullOrEmpty(ip))
ip = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
return ip;}
private DataTable GetLocation(string strIPAddress)
WebRequest rssReq = WebRequest.Create("" + 
WebProxy px = new WebProxy("" + strIPAddress, true);
rssReq.Proxy = px;
rssReq.Timeout = 2000;
WebResponse rep = rssReq.GetResponse();
XmlTextReader xtr = new XmlTextReader(rep.GetResponseStream());
DataSet ds = new DataSet();
return ds.Tables[0];
{return null;}
protected void btnGetIpaddress_Click(object sender, EventArgs e){
DataTable dt = new DataTable();
dt = GetLocation(GetVisitor());
if (dt.Rows.Count > 0)
dvIpaddressdetail.DataSource = dt;
string ipaddress= dt.Rows[0].Field<string>(0);
catch (Exception ex)
throw ex;

 <div class="middle-form" >
<form name="form" autocomplete="off" runat="server">
<div class="row">
<h3 style="margin-left:20%;"> Lookup IP address and Domain location now with our 
free IP Locator.</h3>

<div class="row"> 
<asp:TextBox ID="txtipaddress" runat="server" Text="" 
<div class="row"> 
<asp:Button ID="btnGetIpaddress" runat="server" Text="Lookup IP Address With IP 
Lookup" OnClick="btnGetIpaddress_Click" CssClass="btn btn-blue"/> </div>

<div class="row" style="margin-top:15px!important;"><br />
<asp:DetailsView ID="dvIpaddressdetail" runat="server" Width="100%" 
CellPadding="4" ForeColor="#333333" GridLines="None" HeaderText="IP ADDRESS 
DETAIL" BorderColor="#EEEEEE" BorderStyle="Solid">
<AlternatingRowStyle BackColor="White" />

<CommandRowStyle BackColor="#F9F9F9" Font-Bold="True" />

<FieldHeaderStyle BackColor="#F2F2F2" Font-Bold="True" />

<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<HeaderStyle BackColor="#0099FF" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />

<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
ControlToValidate="txtipaddress" ErrorMessage="*"></asp:RequiredFieldValidator>

<asp:HiddenField ID="txtlat" runat="server" ClientIDMode="Static" />

<asp:HiddenField ID="txtlon" runat="server" ClientIDMode="Static" />


See live demo of this