Posts

LINQ (Language Integrated Query) - Part 4

Image
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

Image
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?

15 Most Useful Visual Studio Tips/Tricks by me

Image

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"

Image
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 w e 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 sq

LINQ (Language Integrated Query) - Part 2

Image
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.

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

Image
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.

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.

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Customize User's Profile in ASP.NET Identity System