Andy Blog

Full-stack developer

Nested transaction in C#

Senario We have a simple table with Request <-> Log is one-to-many relationship. script create table Log ( [Id] [bigint] not null identity, [Timestamp] [datetime] not null, [E...

APICloud tutorial

Download source Prepare environment Download and install APICloud Studio2 or the complete IDE at APICloud SDK. It includes APICloud Studio、Sublime APICloud Plugins、WebStorm APICloud P...

Chain of state pattern for auto processing

Introduction State pattern State pattern is a behavioral software design pattern. It implements a state machine in object-oriented design. State pattern can be used to maintain various states in ou...

Entity Framework working with stored procedure

Preparation database create a Blog table CREATE TABLE Blogs( BlogId int IDENTITY(1,1) PRIMARY KEY, Name nvarchar(50), Url nvarchar(50) ) Populate some data INSERT INTO dbo.Blogs ( Na...

nopCommerce tutorial - (3) develop a plugin

Introduction There are two approaches to customize nopCommerce to fit our needs. Plugin can be used to extend the functionality of nopCommerce. Theme can be used to define the look and feel of page...

nopCommerce tutorial (2) increase file upload size

Issue nopCommerce throws exception when uploading a large file for downloadable products. Solution Please modify web.config because nopCommerce uses .NET MVC Please note that the default maxim...

nopCommerce tutorial (1) - installation and debug

Prepare environment operating system windows 7+, sql server 2008+ control panel > program and features > turn windows feature on/off > IIS > Application Development F...

ASP.NET WCF Service Tutorial

Download source Introduction WCF(Windows Communication Foundation) is a service layer that allows us to build applications that can communicate using a variety of communication approaches. With it...

ASP.NET SOAP ASMX Web Services Tutorial

Introduction A web service is a web application which is basically a class consisting of methods that could be used by other applications. Active Server Methods (ASMX) is a solution put forwarded ...

SQL Server Reporting Services Tutorial 5 - Integrate reports in web page

Prepare report(s)/chart(s) Report1: Report2: Integrate reports - way1: use iframe find the report file at http://localhost/reportserver open a report and get the url like http://hostnam...