As you all know, if you create a sample API project you will get a folder HelpPage in Areas. This is for adding the XML description to each controller and actions we use in our API. If you document it well, any one can understand your API, so that you don’t need to explain what your API will do and what would be the output. If you are new to HelpPage implementation in API, please see here: API help page controller action description in Web API. Here I am going to create a Web API with the help page descriptions in Visual Studio 2015. And once the project is ready I will install the WebApiTestClient package to my solution. I hope you will like this.
Please be noted that this package is not officially released by Microsoft. This is a prototype created by Yao – MSFT
Download the source code
You can always download the source code here: API Test Client
Background
For the past few months, I had been working with API projects. Recently I was asked to create an application to test the API I created so that the testing team can test the API easily. Yes I agree that we have tools like Fiddler and Post Man for the same. Still we thought to create our own. As I started my development, I came to know about the package WebApiTestClient which does what we wanted. Finally we decided to stop developing the application and used this wonderful package. Here I am going to show you how can we use this.
Prerequisites
- Visual Studio With Web API Installed
Things we are going to do:
The following are the tasks we are going to do.
- Setting up database
- Creating an Entity Framework
- Creating API controller with the Model Created
- Installing WebApiTestClient
- Configuring WebApiTestClient
- Testing WebApiTestClient
Setting up database
Here I am going to create a database which I created for my demo purposes, you can always create this database by running the queries mentioned here.
Create database
- USE[master]
- GO
- /****** Object: Database [TrialsDB] Script Date: 5/12/2016 10:56:41 AM ******/
- CREATE DATABASE[TrialsDB]
- CONTAINMENT = NONE
- ON PRIMARY
- (NAME = N 'TrialsDB', FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TrialsDB.mdf', SIZE = 3072 KB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024 KB)
- LOG ON
- (NAME = N 'TrialsDB_log', FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\TrialsDB_log.ldf', SIZE = 1024 KB, MAXSIZE = 2048 GB, FILEGROWTH = 10 % )
- GO
- ALTER DATABASE[TrialsDB] SET COMPATIBILITY_LEVEL = 110
- GO
- IF(1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
- begin
- EXEC[TrialsDB].[dbo].[sp_fulltext_database] @action = 'enable'
- end
- GO
- ALTER DATABASE[TrialsDB] SET ANSI_NULL_DEFAULT OFF
- GO
- ALTER DATABASE[TrialsDB] SET ANSI_NULLS OFF
- GO
- ALTER DATABASE[TrialsDB] SET ANSI_PADDING OFF
- GO
- ALTER DATABASE[TrialsDB] SET ANSI_WARNINGS OFF
- GO
- ALTER DATABASE[TrialsDB] SET ARITHABORT OFF
- GO
- ALTER DATABASE[TrialsDB] SET AUTO_CLOSE OFF
- GO
- ALTER DATABASE[TrialsDB] SET AUTO_CREATE_STATISTICS ON
- GO
- ALTER DATABASE[TrialsDB] SET AUTO_SHRINK OFF
- GO
- ALTER DATABASE[TrialsDB] SET AUTO_UPDATE_STATISTICS ON
- GO
- ALTER DATABASE[TrialsDB] SET CURSOR_CLOSE_ON_COMMIT OFF
- GO
- ALTER DATABASE[TrialsDB] SET CURSOR_DEFAULT GLOBAL
- GO
- ALTER DATABASE[TrialsDB] SET CONCAT_NULL_YIELDS_NULL OFF
- GO
- ALTER DATABASE[TrialsDB] SET NUMERIC_ROUNDABORT OFF
- GO
- ALTER DATABASE[TrialsDB] SET QUOTED_IDENTIFIER OFF
- GO
- ALTER DATABASE[TrialsDB] SET RECURSIVE_TRIGGERS OFF
- GO
- ALTER DATABASE[TrialsDB] SET DISABLE_BROKER
- GO
- ALTER DATABASE[TrialsDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
- GO
- ALTER DATABASE[TrialsDB] SET DATE_CORRELATION_OPTIMIZATION OFF
- GO
- ALTER DATABASE[TrialsDB] SET TRUSTWORTHY OFF
- GO
- ALTER DATABASE[TrialsDB] SET ALLOW_SNAPSHOT_ISOLATION OFF
- GO
- ALTER DATABASE[TrialsDB] SET PARAMETERIZATION SIMPLE
- GO
- ALTER DATABASE[TrialsDB] SET READ_COMMITTED_SNAPSHOT OFF
- GO
- ALTER DATABASE[TrialsDB] SET HONOR_BROKER_PRIORITY OFF
- GO
- ALTER DATABASE[TrialsDB] SET RECOVERY FULL
- GO
- ALTER DATABASE[TrialsDB] SET MULTI_USER
- GO
- ALTER DATABASE[TrialsDB] SET PAGE_VERIFY CHECKSUM
- GO
- ALTER DATABASE[TrialsDB] SET DB_CHAINING OFF
- GO
- ALTER DATABASE[TrialsDB] SET FILESTREAM(NON_TRANSACTED_ACCESS = OFF)
- GO
- ALTER DATABASE[TrialsDB] SET TARGET_RECOVERY_TIME = 0 SECONDS
- GO
- ALTER DATABASE[TrialsDB] SET READ_WRITE
- GO
Create table with data
- USE[TrialsDB]
- GO
- /****** Object: Table [dbo].[Product] Script Date: 5/12/2016 10:54:48 AM ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE TABLE[dbo].[Product](
- [ProductID][int] NOT NULL, [Name][nvarchar](max) NOT NULL, [ProductNumber][nvarchar](25) NOT NULL, [MakeFlag][bit] NOT NULL, [FinishedGoodsFlag][bit] NOT NULL, [Color][nvarchar](15) NULL, [SafetyStockLevel][smallint] NOT NULL, [ReorderPoint][smallint] NOT NULL, [StandardCost][money] NOT NULL, [ListPrice][money] NOT NULL, [Size][nvarchar](5) NULL, [SizeUnitMeasureCode][nchar](3) NULL, [WeightUnitMeasureCode][nchar](3) NULL, [Weight][decimal](8, 2) NULL, [DaysToManufacture][int] NOT NULL, [ProductLine][nchar](2) NULL, [Class][nchar](2) NULL, [Style][nchar](2) NULL, [ProductSubcategoryID][int] NULL, [ProductModelID][int] NULL, [SellStartDate][datetime] NOT NULL, [SellEndDate][datetime] NULL, [DiscontinuedDate][datetime] NULL, [rowguid][uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate][datetime] NOT NULL
- ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]
- GO
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(1, N 'Adjustable Race', N 'AR-5381', 0, 0, NULL, 1000, 750, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N '694215b7-08f7-4c0d-acb1-d734ba44c0c8', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(2, N 'Bearing Ball', N 'BA-8327', 0, 0, NULL, 1000, 750, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N '58ae3c20-4f3a-4749-a7d4-d568806cc537', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(3, N 'BB Ball Bearing', N 'BE-2349', 1, 0, NULL, 800, 600, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N '9c21aed2-5bfa-4f18-bcb8-f11638dc2e4e', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(4, N 'Headset Ball Bearings', N 'BE-2908', 0, 0, NULL, 800, 600, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N 'ecfed6cb-51ff-49b5-b06c-7d8ac834db8b', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(316, N 'Blade', N 'BL-2036', 1, 0, NULL, 800, 600, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N 'e73e9750-603b-4131-89f5-3dd15ed5ff80', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(317, N 'LL Crankarm', N 'CA-5965', 0, 0, N 'Black', 500, 375, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 0, NULL, N 'L ', NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N '3c9d10b7-a6b2-4774-9963-c19dcee72fea', CAST(0x00009A5C00A53CF8 AS DateTime))
- INSERT[dbo].[Product]([ProductID], [Name], [ProductNumber], [MakeFlag], [FinishedGoodsFlag], [Color], [SafetyStockLevel], [ReorderPoint], [StandardCost], [ListPrice], [Size], [SizeUnitMeasureCode], [WeightUnitMeasureCode], [Weight], [DaysToManufacture], [ProductLine], [Class], [Style], [ProductSubcategoryID], [ProductModelID], [SellStartDate], [SellEndDate], [DiscontinuedDate], [rowguid], [ModifiedDate]) VALUES(318, N 'ML Crankarm', N 'CA-6738', 0, 0, N 'Black', 500, 375, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 0, NULL, N 'M ', NULL, NULL, NULL, CAST(0x0000921E00000000 AS DateTime), NULL, NULL, N 'eabb9a92-fa07-4eab-8955-f0517b4a4ca7', CAST(0x00009A5C00A53CF8 AS DateTime))











Sibeesh VenuPosted Jul 9, 2016, 10:39 PM
Rakesh Thanks
RakeshPosted Jul 9, 2016, 12:41 PM
Good one
Sibeesh VenuPosted Jul 8, 2016, 4:52 AM
Shobana J Thanks
Shobana JPosted Jul 8, 2016, 4:19 AM
Nice one
Sibeesh VenuPosted Jul 7, 2016, 12:29 PM
Sr Karthiga Thanks
Sr KarthigaPosted Jul 7, 2016, 8:08 AM
Nice
Sibeesh VenuPosted May 30, 2016, 3:12 AM
Debasis Saha Thanks
Debasis SahaPosted May 30, 2016, 3:01 AM
Nice share..
Sibeesh VenuPosted May 29, 2016, 2:40 AM
Munesh Sharma Thanks
Munesh SharmaPosted May 28, 2016, 3:12 PM
nice