Wednesday, November 19, 2014

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Could not locate the assembly "System.Web.Mvc,Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35,processorArchitecture=MSIL

Posted: 18 Nov 2014 09:12 AM PST

Microsoft recent security update has resulted in compilation error.  After spending some time came across this link.  This is a known issue. Error: Could not load file or assembly 'System.Web.Mvc, Version=4.0.0.1, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT

Attempt by security transparent method 'WebMatrix.WebData.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed.

Posted: 18 Nov 2014 09:11 AM PST

Error: Attempt by security transparent method 'WebMatrix.WebData.PreApplicationStartCode.Start()' to access security critical method 'System.Web.WebPages.Razor.WebPageRazorHost.AddGlobalImport(System.String)' failed. Solution: Install Nuget Package Microsoft.AspNet.WebHelpers Example: Install-Package Microsoft.AspNet.WebHelpers

Could not load file or assembly 'WebMatrix.Data, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Posted: 18 Nov 2014 09:11 AM PST

Error: Could not load file or assembly 'WebMatrix.Data, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Solution: Install Nuget Package Microsoft.AspNet.WebPages.Data Example: Install-Package Microsoft.AspNet.WebPages.Data

Sunday, May 25, 2014

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

A connection was successfully established with the server, but then an error occurred during the login process. (Microsoft SQL Server, Error 233)

Posted: 24 May 2014 06:30 PM PDT

Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider) Solution: Step 1: Open SQL Server Configuration Manager Go to Windows 8 Start screen. Start typing in SQLServerManager11.msc if you are looking for SQL

Login failed for user. (Microsoft SQL Server, Error 18456)

Posted: 24 May 2014 06:22 PM PDT

I was recently facing this error when created a SQL Server login and then try login using that newly created login. Error: Login failed for user. (Microsoft SQL Server, Error 18456) (.Net SqlClient Data Provider) Please note: Solution is available on this link, but since microsoft has bad habit of link breaking issue; I have copied and pasted the solution for my reference. http://

Thursday, February 6, 2014

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Free ASP.NET Training for 2014

Posted: 06 Feb 2014 02:10 AM PST

Find this useful blog post on Scott hanselman blog Bookmark for to do list [01:00] - Windows Azure [18:17] - Virtual Machines [41:39] - SQL Database [49:49] - Web Sites [1:31:40] - Storage [1:34:47] - Active Directory 1: What's New in ASP.NET 4.5 2: Building and Deploying Websites with ASP.NET MVC 4 3: Creating HTML5 Applications with jQuery 4: Building a Service Layer with ASP.NET Web API

Wednesday, November 13, 2013

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Easiest Repository Pattern Tutorial

Posted: 12 Nov 2013 09:06 PM PST

I would like to explain how to implement repository pattern before we proceed any further with our single page application discussion. What is repository pattern? Repository pattern separates the logic that retrieves the data from the database and logic that uses the data by your application.  Thus it makes your data access layer independent of your presentation layer. As shown in above

Tuesday, November 12, 2013

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Understanding Flow of control for Hot Towel SPA Template

Posted: 11 Nov 2013 08:04 PM PST

Like any other application HTS is not following default route of having Global.asax as starting point.  "I believe" this is not good and there are few other things which "I believe" you won't do it for your production code which we will be going to customize in upcoming blog post. Flow of process for Hot Towel SPA template App_Start/BreezeWebApiConfig.cs/RegisterBreezePreStart() App_Start/

First Single Page App (SPA) using Hot Towel SPA Template

Posted: 11 Nov 2013 07:38 PM PST

In this post, I will be creating our first SPA application using Hot towel SPA template. If you haven't installed VS.Net 2012.2 Update, then please do it now before reading further. Step 1: Open VS.Net and start creating asp.net mvc application Step 2: There are 2 default template available for creating SPA application, choose "Hot Towel SPA" template Step 3: Ones your solution is ready

Single Page Application (SPA) - Overview

Posted: 11 Nov 2013 05:37 PM PST

For those of you haven't got chance to work on Single Page Application (SPA), I will be discussing few of my learning in series of post, including how to perform CRUD operation using both Breeze and Web Api. What is Single Page Application (SPA)? (From Asp.net Site) ASP.NET Single Page Application (SPA) helps you build applications that include significant client-side interactions using HTML 5,

Sunday, November 10, 2013

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

NotMapped attribute for PetaPoco or Ignore Column while Insert/Update in Petapoco

Posted: 09 Nov 2013 10:34 AM PST

NotMapped Property for PetaPoco or Ignore Column while Insert/Update in Petapoco [NotMapped]   ==>  [ResultColumn] [NotMapped] equivalent of entity framework in Petapoco is [ResultColumn] For more information Example:  If you have contact form model where you want user to enter captcha, but you don't want this captcha to be store in db, so In order to ignore captcha column while inserting

Saturday, November 2, 2013

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Delete all the rows from all the tables in SQL Server

Posted: 01 Nov 2013 11:58 AM PDT

If you are in situation where you just want empty database structure, without having data in it. Run following select statement which will generate set of delete statement to delete all the records for all the tables in your database. SELECT 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';'  FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' ORDER by