Enjoy with new release of Visual Studio and SQL SERVER :)

Dear All,

Although, I am bit late to share this information and might be possible most of you people aware of this.Recently Microsoft released Visual Studio 2015

and SQL SERVER 2016 CTP. Not needed to say that there are various awesome features in both build.

You can download latest Visual Studio 2015 from below link


and SQL SERVER 2016 CTP from below link


In future post you will be find tips & tricks related to SQL SERVER 2016 & Visual Studio 2015.

Enjoy Learning !!!



A new milestone 125th post on Indiandotnet.wordpress.com so far so good

Dear Friends,
This post is different post from my regular technical articles and it is my 125th post on Indiandotnet.wordpress.com.

I would like to thank all of my friends, family members, colleges & most valuable the reader of this blog who continuously giving feedback and improving my skill also.
So thank you very very much.
Keep reading, Keep commenting, and keep giving feedback.
I need more improvement and I know you people will help me in sharing my thoughts.
God bless you all.

Happy Holidays.

Merry Christmas.
Rajat Jaiswal

Project List on which we will work in future

Dear Friends,

 Merry Christmas!

I Hope you are enjoying  the holidays.

 After seeing the market trend and requirements I am interested in making following projects which will help me and other friends to understand basic project development and use latest technologies with some productive output.

 In coming up sessions i am going to use this project topic and create sample with latest technologies like Silverlight, Windows phone 7, VS 2010 etc.

 So here we go

 1) College Management

 2) School Management

3) Job Portal

 4) Forums

5) Blog

6) Employee Management

7) Bug Tracker

8) Time Sheet

9) Address Book

10) Project Management

11) Survey engine

 12) Stock Manager

13) Property Broker

14) Shop Management

15) Matrimonial

 16) Social Networking

17) Hotel Management

 18) Inventory Management

19) Accounting

20) Transport Management

21) Hospital Management

22) Ecommerce

Etc are the project list on which I will work in future to enhance my knowledge with productive work.

I will share code base and case study also in future

Hope you like it Once again wish you Merry Christmas.


 Rajat Jaiswal

Some useful Terminology (acronyms)

Hello friends,
Here I am with some useful terminology and these acronyms are generally used now days in broad way take a look.
1) ESB : Enterprise Service Bus
2) POX : Plain OLD XML
3) REST: Representational State Transfer
4) SOAP: Simple Object Access Protocol
5) RIA : Rich Internet Application
6) XML : Extensible Markup Language
7) JASON: Java Script Object Notation
8) DOM : Document Object Modeling
9) XAML : Extensible Application Markup Language
10) LINQ : Language Integrated Query
11) RSS: Really Simple Syndication
12) WCF: Windows Communication Foundation
13) WF: Windows Foundation
14) WPF: Windows Presentation Foundation
15) AJAX: Asynchronous Java script and XML
16) XLST: Extensible Style Sheet Language Transformation
17) INDIGO: Code name of Microsoft windows Communication foundation Technology
18) OSLO: Code name of Microsoft Modeling Technology
19) SOA: Service Oriented Architecture
20) ORCAS: dot net 3.5 Version called ORCAS
21) AVALON: code name of Microsoft Windows Presentation foundation Technology
22) Azure: Microsoft new Operation system Related to Cloud computing
23) Astoria : Code name of Ado.net Data services

I hope you people like it.
Enjoy life with dot net.

Your host
Rajat Jaiswal

Basic Ado.net Data Services 5 minutes job Part -I

 1. What is Ado.net Data Services ? 




 Ado.Net Services formaly known as “Astoria“. It’s a facility that is used as a web services over net just like simple http with well known data format like jason or XML.

It’s a feature that allow user to mainuplate, traverse data through simple URIs. This allow easy access of data. The concept comes from general programming concept reffered as REST.It is avalilable with Vs 2008 + SP1.According to me I found only one and most important point that it is easily navigate through url.

Which is best feature.

2. What  it requires to run it ?


For this you have to install vs2008’s service pack 1 which is easily available at





3) Basic  Example for understanding :-



Here I am going to explain an example just follow the same way for initital starting. Just follow below step.

Step 1:-

Add new web project

Step 2:- Now add a new item “Ado.net Data Service” as shown in below fig when you add it. It adds a new item in your project just like I added “RajatDataService.svc




By default you get shared method which is initializeService

Step3:- Add new item Ado.net Entity model as shown in below fig.




Once you add it then you will get screen like below fig it has edmx extention.



Before going further I just explain you in breif edmxAdo.net entity model ” is just like Your linq mapper with extended functionality I will explain this later on in my new

Post. But for current point of time just think as ORM.

Step4 :- Once you done with this you have to do following code in your DataService.svc.vb file’s default shared method as we said in step 2





Imports System.Linq

Imports System.ServiceModel.Web 

Public Class RajatAdoNetService 





    Inherits DataService(Of MedicalProEntities)





‘The medical proEntries is your model entry class


 ‘ This method is called only once to initialize service-wide policies.


 Public Shared Sub InitializeService(ByVal config As IDataServiceConfiguration) 


‘ TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc.



 config.SetEntitySetAccessRule(“*” , EntitySetRights.AllRead) 


‘ above line is use for access rules for entities in model




 ‘if you want to access particular entity (table) from database then just give entity name at the place of * like below


 ‘ config.setEntitySetAccessRules(“tblProduct”,entitySetRight.allRead)


 ‘ The second option is for mainly giving rights like , read ,write,delete etc on entity set

 config.SetServiceOperationAccessRule(“*”, ServiceOperationRights.All) 




‘ The above line is service opration accessRules in this again just put * int first parameter, and all in second parameter

 End Sub

End  Class



Once you done with above code just set your .Svc page as set as start page and run the application. And you will be supprise you will get below screen




You will find in the above fig that all the tables are with in xml format. URL (
Now suppouse you want to access particular table database then you have to write fllowing url in addressbar




Then if you are not able to view data and get bleow screen




Then go to Internet explore option Tools –> Internet options –> Content tab ‘s Feed setting option and uncheck all the checkbox then

Refresh you will get fllowing screen


Step 6:-

Simillarly you can access any entity in entity model or we can say any table from url.


Suppose I want to access product table then I have to write




I this way we can get table with data in xml format as shown above.




Where 36 is identity column value.




Step 8: if you want to access particular id’s column field’s value then you have to write column name also in url suppose I want tblbank’s strbankCode column value where id = 36 then I have to write below url 
As shown below





I know this is not enough for your hunger even my too so don’t worry i will come up with more suitable example and live demo soon  here I hope you people got basic understanding. I will come up with latest example and more description in next chapters

Till then enjoy the code.

Keep Shining & Keep  Pushing  , Keep programming


Rajat Jaiswal



Step 7:- if you want to access particular id data then you have to write following url