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 !!!



How easy to reduce efforts in retesting a asp.net web application?


Most of the time when you write code for a web application you need to test it again and again. You have to run a whole flow of positive or negative test cases to check whether your application is working or not.

Now suppose your application have 20 pages and you need to traverse each individual page and may be perform some operation and on each change of your development you need to perform same thing.

sometimes, this thing will irritate you and you will skip testing which may be harmful because most of the time it happens when you skipped something Smile you took a deep breath  and at that moment your application crashed Sad smile.

So , as a responsible developer we do not have to skip any test scenario but next question is how to reduce this effort which you feel boring sometime.

I can say we can reduce this effort by a installing a simple  Firefox add-in which is absolutely free. The add in “Selenium add in”

you can download it from https://addons.mozilla.org/en-US/firefox/addon/selenium-expert-selenium-ide/

once you have installed this you will find the selenium icon near by search bar as shown below


when you click this icon you will get a selenium interface as shown below


The basic concept of this tool is what ever you will run in browser it has capability of recording those steps so it is just play button and pause button game, no rocket science. You can easily run and use this.

I am sure it will reduce your testing effort and when when selenium ide will play your test cases you can take a deep breath and enjoy your coffee and snacks.

I hope this tip may be helpful to you somewhere.

Happy Holidays.



MVC from Beginner to advance session by Indiandotnet


Dear All,

Thanks for attending session on 30th Nov 2014. I would like to say a big thanks to Abhishek Sapkale also who delivered the session and share knowledge with us.

We tried to  do go live in this seminar and some people joined also and enjoyed the live streaming.

Those who were not able to attend the session due to some reason, they can see the videos of session from below links




You can also watch presentation at slide share



I hope it might help you.


Rj !!!

How to incorporate word press theme in my Razor Blog

Hello friends,
As you know currently I am working on Razor. So I am trying to make a WordPress blog with Razor.Net.
Now the challenging task for me is design. I am not so good in designing so it’s a big deal for me. I just thought to download the WordPress theme and incorporate in My Blog work. So thanks to  free word press themehttp://www.freewordpressthemes4u.com/category/technology) I just downloaded the technology themes from there you can visit and see the other design.I like Mac Doc wordpress theme so here is the steps which I followed which help you also.
1) Just downloaded  the theme from any free wordpress theme sites
2) Copy all the images in your image folder of site
3) Copy CSS file in your Style folder.
4) Now open your site Layout page
5) Replace the body part of your site layout with default preview page of word press theme which you are looking currently. In my Case (free Mac theme page)
6) Then try make pieces of your design like  in my case on the default page there is a header part, footer part,  Search Box part, Archive Part, Center part (Where we will see post),Tag part, Category part.
7) So what I did I created all this part as a separate page like header.cshtml, footer.cshtml, SearchBox.cshtml, Archive.cshtml, Deafult.cshtml, TagSearch.cshtml, CategorySearch.cshtml.
8) Just cut the part from your site layout for specific items like header, site bar, content, category etc.
9) In SiteLayout page only call this pages. This is the simplest way.
10) Now if I need to incorporate any other Word press theme then I just needs to copy the theme and just need to replay site layout. This is the simplest way I found with Razor.

11) The best part is I just need to create a page cshtml and can place anywhere according to need and it will work like a word press functionality.

I hope you got some idea.
Soon I am going to upload the Blog which will help you to understand the concept of Razor more. It’s a simplest blog creation.
Rajat Jaiswal

Simpletest way to fetch database records in Razor

Hello friends,
Today we are discussing how to fetch data from database in Razor.
You can connect with database using database.open() method.
This will return you database object.
For example
Database dbCon = Database.Open(“MyBlog”);

Now to fetch records from database you have mainly three methods which are
1) dbCon.Query() :- This method return IEnumeration object. You can use this method. Or in the other words it will return no of record sets which are available after running the specific query.
2) dbCon.QuerySingle():- By the name it will return single record set or single object. You can use it when you are sure the query will return single result set.
3) dbCon.QueryValue() :-
  This method is like your scalar method in ADONET. It will return scalar value or single value.

Here I am taking example of fetching multiple rows from a table.
Suppose I have a tag table and I need to fetch records from database and display it in a tabular html format. Then below are the steps.
1) Create database object
Database dbCon = Database.Open("MyBlog");
2) Get IEnumerable object  by query
var TagListRecords = dbCon.Query("SELECT * FROM lkuTag");
3) Run for loop on IEnumerable object  and print the columns of table result set
@foreach (var tagrecord in TagListRecords) {

You will get following screen after running it.

I hope it is simplest way to fetch records.

In next topic we will discuss how to insert records in database in razor.

Till than thanks a lot.

Take care
Rajat Jaiswal

Learn Razor.NET A new tool

Hello friends,

Today we are going to discuss Razor.NET (ASP.NET Razor). It is like a wrapper on .NET very useful easy to learn.

Before going further as you know I am big fan of WWH so we will use WWH (What, why, how) questionnaires What is Asp.net Razor (Razor.net)?

Razor is a free tool by Microsoft by which you can write your Server side code using either VB.NET or C# syntax or you can say Asp.net Razor is new technique for writing code.

It just likes your classic ASP & PHP code. You need to write code in design page and server side code start with @ symbol.

So it will be easier for you if you have some hand over classic ASP or PHP.

 Why Razor?

As you know in the near future everything is on Mobile, PDA, and touchpad and most probably on HTML5. So great news is as per my thought Razor is developed just because of that goal. It is simple and easy to use. It helps in Mobile web development.

How to use it?

To use Razor you have to download a new tool which is called Web Matrix. Web Matrix is new IDE for developing Razor Application, which provide various utility which help you in develop a Razor application. You can download IDE from http://www.microsoft.com/web/downloads/platform.aspx

What is CSHTML & VBHTML Extension?

CSHTML & VBHTML are new file extension in Razor. The CSHTML file denotes that code is written in C# language and VBHTML denotes that code is written in VB.NET.

What is @RenderPage () function in Razor?

If you are ASP or PHP developer than you are aware of how to include a file. Render page function is used for reusable content. For example suppose you define a layout in which you have header page, footer page and content page and header page & footer page you required in all the content page then  you have to write just a simple line to include that file


Other than this there are so many useful function like IsPost , @RenderSection(), @RenderBody Etc

which we will discuss in our next post.

Thanks for Reading

Enjoy weekend with Razor,

Rajat Jaiswal