Ask your technical questions on forums or here :
ASP.NET or MVC | C# | Windows Phone
Microsoft Technology Journals by Abhimanyu K Vatsa
HOME ABOUT RAZOR BOOK SPEAKING MVC ASP.NET JQUERY VIDEOS EBOOK ARCHIVE

31 Aug 2012

LINQ (Language Integrated Query) - Part 4

This is fourth part of the ‘LINQ’ series posts that I have started from here. And in this post, you will learn how to setup a demo project to explore LINQ queries. I will use my preinstalled ‘Northwind’ database that you can download from here and install it in SQL Server Management Studio.


Monthly Blogging Report: August 2012

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.


LINQ (Language Integrated Query) - Part 3

This is third part of the ‘LINQ’ series posts that I have started from here. And in this post, you will learn something on ‘Generic’ like what are generic types, why we need it in LINQ?


30 Aug 2012

15 Most Useful Visual Studio Tips/Tricks by me


ORA-01034: Oracle Not Available

It is a simple error meaning your database is down. To fix this, follow the steps given below:

SQL>connect sys/password as sysdba
SQL>startup
SQL>exit

SP2-0110: Cannot create save file "afiedt.buf"

Any query/command (single line or multiple line) we execute resides in the buffer temporarily and it is lost when we execute new query/command because new one takes that place.

In case we try to edit that query/command which is in the buffer we get an error "SP2-0110: Cannot create save file "afiedt.buf"".

There are many ways to fix this, I'm going to show you three different ways.


1. Always run the SQL Command Line as administrator.



Once you start this way, you will not see said error.


2. Sometimes we get this error message because we don't have write permission on the current directory. Either start sqlplus from a different directory, or change the editfile entry in sqlplus:

SQL>set editfile d:/sqledit.sql

In above code, you can use any drive for this and any file name.

3. Create sqledit.sql file and save it in bin directory (sometimes this file misses cause this error) of oracle where sqlplus.exe is resides.Then run sql command line as administrator.

LINQ (Language Integrated Query) - Part 2

This is second part of the ‘LINQ’ series posts that I have started from here. And in this post, you will see some quick examples on LINQ title.

As I said in previous post, with LINQ you just need to perform three distinct actions: Obtain the Data Source, Create the query and Execute the query, you will notice it in sample programs given below. We will create Console Apps and test various LINQ concepts. I will walk through very simple programs here and in coming part will dig in depth.

25 Aug 2012

Error: this template attempted to load component assembly 'NuGet.VisualStudio.Interop, Version=*, Culture=neutral, PublicKeyToken=*'

Error: this template attempted to load component assembly 'NuGet.VisualStudio.Interop, Version=*, Culture=neutral, PublicKeyToken=*'. For more information on this problem and how to enable this template, please see documentation on Customizing Project Templates.

23 Aug 2012

LINQ (Language Integrated Query) - Part 1

Recently I had started exploring ‘LINQ to Entities’ new features. So, I thought to start a series of posts on ‘LINQ’ title and accumulate it on my blog for the beginner’s.

Hope, this series will be helpful to you to understand the ‘LINQ’ and before jump start to the application development let’s talk on basics something like: what is linq and its benefits.

16 Aug 2012

Windows 8 RTM for MSDN/TechNet Subscribers & Visual Studio 2012 RTM for MSDN Subscribers now available

So, it's 15th August 2012 (Independance Day of India) and as per the previous announcement by Microsoft, Windows 8 and Visual Studio 2012 is now available for downloads.

Model First Approach in Entity Framework

Introduction

Read my previous two posts ‘Code First Approach in Entity Framework’ & ‘Database First Approach in Entity Framework’ for EF basics. In this post I’m directly going to jump on Model First Demo Project.

13 Aug 2012

Learn .NET and C# in 60 Days Video Series : by Shivprasad Koirala

Friends, recently I subscribed a YouTube channel to boost-up my .NET and C# skills by just watching videos. These videos are being recorded by our start tech leader ‘Shivprasad Koirala’ sir (http://www.questpond.com). I recommend you to go and subscribe the channel to receive the upcoming videos in your inbox and even watch the uploaded videos that is already recorded. I watched all of the recordings and eagerly waiting for new alert in my inbox. 

12 Aug 2012

Entity Framework Videos in Hindi Language

Want to learn Entity Framework then I got some videos for you in HINDI Language, go ahead and watch it.

11 Aug 2012

Database First Approach in Entity Framework

Introduction

Read my last post ‘Code First Approach in Entity Framework’ for EF introduction even for the basic touch.

9 Aug 2012

Code First Approach in Entity Framework

Introduction

Entity Framework is the Microsoft preferred method of data access for .NET applications. It supports strongly-typed access through LINQ. Entity Framework also allows developers to program against a conceptual model that reflects application logic rather than a relational model that reflects the database structure. Entity Framework can be used from an ASP.NET Application, (using Entity Data Source) or in ASP.NET MVC etc. In this article we will be creating this using MVC App and we’ll be using Visual Studio 2012 for demo.

7 Aug 2012

The procedure entry point_Atomic_fetch_sub_4 could not be located in the dynamic library: C:\Program Files\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe

After the installation of newly released Office 2013 Preview I noticed Visual Studio 2012 RC won’t running anymore. And it said error “The procedure entry point_Atomic_fetch_sub_4 could not be located in the dynamic library: C:\Program Files\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe.”

5 Aug 2012

Best Practices for Speeding up Your Web Site

The Exceptional Performance team has identified a number of best practices for making web pages fast. The list includes 35 best practices:

3 Aug 2012

Monthly Blogging Report: July 2012

Consolidating all blog posts monthly are very refreshing as it gives me chance to go back and see what I did in last month and for readers gives the chance to see what he not followed up.

Bundling and Minification in Visual Studio 2012 or Migrate existing Website

Bundling and minification are two new techniques introduced with ASP.NET 4.5 Beta to improve request load time.  It improves load time by reducing the number of requests to the server and reducing the size of requested assets (such as CSS and JavaScript).

2 Aug 2012

Set Startup Programs in Windows 8

In previous versions of Windows, to set startup programs we just open Run > msconfig.exe and in appeared window find ‘Startup’ tab or click on Start > All Programs > Startup (and list the programs here by dragging icons) but in Windows 8 there is bit changes.