VSTest is a very extensible unit test execution framework. The base engine, discovers tests and runs them. It can parallelize across cores, provides process isolation and can integrate with Visual Studio. It has extensibility for different test frameworks, code coverage, test impact analysis, data collection, test result reporting and much more.
Following is a chart that shows licensing cost comparison between standard and Enterprise Edition of SQL Server 2012, 2016 and 2017.
| Version | Edition | License Cost | 2 Quad core Processors | 4 Quad core Processors |
|---|---|---|---|---|
| Per Core | 8 Cores | 16 Cores | ||
| SQL Server 2012 | Standard | $1,793 | $14,344 | $28,688 |
| SQL Server 2012 | Enterprise | $6,874 | $54,992 | $109,984 |
| SQL Server 2016\ 2017 | Standard | $1,858 | $14,864 | $29,728 |
| SQL Server 2016 \2017 | Enterprise | $7,128 | $57,024 | $114,048 |
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>@ViewBag.Title - My ASP.NET Application</title>
<link href="~/node_modules/bootstrap/dist/css/bootstrap.css" rel="stylesheet" />
<link href="~/app/app.component.css" rel="stylesheet"/>
<link href="~/Content/Site.css" rel="stylesheet" type="text/css" />
<!-- 1. Load libraries -->
<!-- IE required polyfills, in this exact order -->
<script src="~/node_modules/angular2/es6/dev/src/testing/shims_for_IE.js"></script>
<script src="~/node_modules/es6-shim/es6-shim.min.js"></script>
<script src="~/node_modules/systemjs/dist/system-polyfills.js"></script>
<script src="~/node_modules/angular2/bundles/angular2-polyfills.js"></script>
<script src="~/node_modules/systemjs/dist/system.src.js"></script>
<script src="~/node_modules/rxjs/bundles/Rx.js"></script>
<script src="~/node_modules/angular2/bundles/angular2.dev.js"></script>
<!-- Required for http -->
<script src="~/node_modules/angular2/bundles/http.dev.js"></script>
<!-- Required for routing -->
<script src="~/node_modules/angular2/bundles/router.dev.js"></script>
<!-- 2. Configure SystemJS -->
<script>
System.config({
packages: {
app: {
format: 'register',
defaultExtension: 'js'
}
}
});
System.import('app/main')
.then(null, console.error.bind(console));
</script>
</head>
<body>
<div>
@RenderBody()
<pm-app>Loading App...</pm-app>
</div>
@RenderSection("Scripts", required: false)
</body>
</html> 
import { Component } from 'angular2/core';
@Component({
selector: 'pm-app',
template:`
<div><h1>{{pageTitle}}</h1>
<div>My First Component</div>
</div>
`
})
export class AppComponent {
pageTitle: string = "DNT AngularJS 2.0 APP";
} selector: 'pm-app',
<div> @RenderBody() <pm-app>Loading App...</pm-app> </div>
template:`
<div><h1>{{pageTitle}}</h1>
<div>My First Component</div>
</div>
` 
import { Component } from 'angular2/core'; 
<div>
@RenderBody()
<pm-app>Loading App...</pm-app>
</div> System.import('app/main') /// <reference path="../node_modules/angular2/typings/browser.d.ts" />
import { bootstrap } from "angular2/platform/browser";
// Our main component
import { AppComponent } from "./app.component";
bootstrap(AppComponent); node_modules\angular2\src\core\application_ref.d.ts(171,81): error TS2304: Build: Cannot find name 'Promise'. node_modules\angular2\src\core\change_detection\differs\default_keyvalue_differ.d.ts(23,15): error TS2304: Build: Cannot find name 'Map'.
Recently I have published this blog, which talks about configuring the ASP.NET 5 application in IIS.
After you set this up, if you run into any issues while accessing the website you can enable the inbuilt logging provided within the HTTPPlatform Handler.
| Method | Jit | Platform | Mean | Scaled |
|---|---|---|---|---|
| ByReference | LegacyJit | X64 | 1.649 us | 1.00 |
| ByReferenceUnsafe | LegacyJit | X64 | 1.721 us | 1.04 |
| ByReference | LegacyJit | X86 | 1.666 us | 1.00 |
| ByReferenceUnsafe | LegacyJit | X86 | 1.673 us | 1.00 |
| ByReference | RyuJit | X64 | 1.684 us | 1.00 |
| ByReferenceUnsafe | RyuJit | X64 | 1.709 us | 1.02 |
To our surprise, the safe way is faster than unsafe!
dynamic excel = Activator.CreateInstance(Type.GetTypeFromProgID("Excel.Application", true));
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); System.__ComObject does not contain a definition for 'Visible'
using Excel = Microsoft.Office.Interop.Excel;
// ...
var excel = new Excel.Application();
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); <ItemGroup>
<Reference Include="Interop.WIA">
<HintPath>..\DNTScanner.Core.TypeLibrary\bin\Debug\Interop.WIA.dll</HintPath>
<EmbedInteropTypes>True</EmbedInteropTypes>
</Reference>
</ItemGroup> <ItemGroup Condition=" '$(TargetFramework)' == 'net40' ">
<Reference Include="Microsoft.CSharp" />
</ItemGroup>
<ItemGroup Condition="'$(TargetFramework)' == 'netstandard2.0'">
<PackageReference Include="Microsoft.CSharp" Version="4.5.0" />
</ItemGroup> <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<OutputType>Exe</OutputType>
<TargetFramework>netcoreapp3.0</TargetFramework>
</PropertyGroup>
<!--
The following 'COMReference' items were copied from a .NET Framework project.
They were added by using the Visual Studio COM References window.
See https://docs.microsoft.com/en-us/visualstudio/ide/managing-references-in-a-project?view=vs-2017.
Observe the 'EmbedInteropTypes' tag value.
See https://docs.microsoft.com/en-us/visualstudio/msbuild/common-msbuild-project-items?view=vs-2017#comreference
-->
<ItemGroup>
<COMReference Include="Microsoft.Office.Core">
<Guid>{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}</Guid>
<VersionMajor>2</VersionMajor>
<VersionMinor>8</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="Microsoft.Office.Interop.Excel">
<Guid>{00020813-0000-0000-C000-000000000046}</Guid>
<VersionMajor>1</VersionMajor>
<VersionMinor>9</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="VBIDE">
<Guid>{0002E157-0000-0000-C000-000000000046}</Guid>
<VersionMajor>5</VersionMajor>
<VersionMinor>3</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
</ItemGroup>
</Project> using System;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
namespace ExcelDemo
{
class Program
{
public static void Main(string[] args)
{
Excel.Application excel;
Excel.Workbook workbook;
Excel.Worksheet sheet;
Excel.Range range;
try
{
// Start Excel and get Application object.
excel = new Excel.Application();
excel.Visible = true;
// Get a new workbook.
workbook = excel.Workbooks.Add(Missing.Value);
sheet = (Excel.Worksheet)workbook.ActiveSheet;
// Add table headers going cell by cell.
sheet.Cells[1, 1] = "First Name";
sheet.Cells[1, 2] = "Last Name";
sheet.Cells[1, 3] = "Full Name";
sheet.Cells[1, 4] = "Salary";
// Format A1:D1 as bold, vertical alignment = center.
sheet.get_Range("A1", "D1").Font.Bold = true;
sheet.get_Range("A1", "D1").VerticalAlignment =
Excel.XlVAlign.xlVAlignCenter;
// Create an array to multiple values at once.
string[,] saNames = new string[5, 2];
saNames[0, 0] = "John";
saNames[0, 1] = "Smith";
saNames[1, 0] = "Tom";
saNames[1, 1] = "Brown";
saNames[2, 0] = "Sue";
saNames[2, 1] = "Thomas";
saNames[3, 0] = "Jane";
saNames[3, 1] = "Jones";
saNames[4, 0] = "Adam";
saNames[4, 1] = "Johnson";
// Fill A2:B6 with an array of values (First and Last Names).
sheet.get_Range("A2", "B6").Value2 = saNames;
// Fill C2:C6 with a relative formula (=A2 & " " & B2).
range = sheet.get_Range("C2", "C6");
range.Formula = "=A2 & \" \" & B2";
// Fill D2:D6 with a formula(=RAND()*100000) and apply format.
range = sheet.get_Range("D2", "D6");
range.Formula = "=RAND()*100000";
range.NumberFormat = "$0.00";
// AutoFit columns A:D.
range = sheet.get_Range("A1", "D1");
range.EntireColumn.AutoFit();
// Make sure Excel is visible and give the user control
// of Microsoft Excel's lifetime.
excel.Visible = true;
excel.UserControl = true;
}
catch (Exception e)
{
Console.WriteLine($"Error: {e.Message} Line: {e.Source}");
}
}
}
} 
public object ProcessingBoundary(IList<SummaryCellData> columnCellsSummaryData)
{
if (columnCellsSummaryData == null || !columnCellsSummaryData.Any()) return 0;
var list = columnCellsSummaryData;
var lastItem = list.Last();
return lastItem.CellData.PropertyValue;
} Method 'set_DisplayFormatFormula' in type 'Hezareh.Modules.Accounting.Reporting.ViewModels.MySampleAggregateFunction' from assembly 'Hezareh.Modules.Accounting, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation.
public class MySampleAggregateFunction : IAggregateFunction
{
public MySampleAggregateFunction()
{
}
/// <summary>
/// Fires before rendering of this cell.
/// Now you have time to manipulate the received object and apply your custom formatting function.
/// It can be null.
/// </summary>
public Func<object, string> DisplayFormatFormula { set; get; }
#region Fields (6)
double _groupAvg;
long _groupRowNumber;
double _groupSum;
double _overallAvg;
long _overallRowNumber;
double _overallSum;
#endregion Fields
#region Properties (2)
/// <summary>
/// Returns current groups' aggregate value.
/// </summary>
public object GroupValue
{
get { return _groupAvg; }
}
/// <summary>
/// Returns current row's aggregate value without considering the presence of the groups.
/// </summary>
public object OverallValue
{
get { return _overallAvg; }
}
#endregion Properties
#region Methods (4)
// Public Methods (1)
/// <summary>
/// Fires after adding a cell to the main table.
/// </summary>
/// <param name="cellDataValue">Current cell's data</param>
/// <param name="isNewGroupStarted">Indicated starting a new group</param>
public void CellAdded(object cellDataValue, bool isNewGroupStarted)
{
checkNewGroupStarted(isNewGroupStarted);
_overallRowNumber++;
_groupRowNumber++;
double cellValue;
if (double.TryParse(cellDataValue.ToSafeString(), NumberStyles.AllowThousands | NumberStyles.AllowLeadingSign, CultureInfo.InvariantCulture, out cellValue))
{
groupAvg(cellValue);
overallAvg(cellValue);
}
}
// Private Methods (3)
private void checkNewGroupStarted(bool newGroupStarted)
{
if (newGroupStarted)
{
_groupRowNumber = 0;
_groupAvg = 0;
_groupSum = 0;
}
}
private void groupAvg(double cellValue)
{
_groupSum += cellValue;
_groupAvg = _groupSum / _groupRowNumber;
}
private void overallAvg(double cellValue)
{
_overallSum += cellValue;
_overallAvg = _overallSum / _overallRowNumber;
}
/// <summary>
/// A general method which takes a list of data and calculates its corresponding aggregate value.
/// It will be used to calculate the aggregate value of each pages individually, with considering the previous pages data.
/// </summary>
/// <param name="columnCellsSummaryData">List of data</param>
/// <returns>Aggregate value</returns>
public object ProcessingBoundary(IList<SummaryCellData> columnCellsSummaryData)
{
if (columnCellsSummaryData == null || !columnCellsSummaryData.Any()) return 0;
var list = columnCellsSummaryData;
var lastItem = list.Last();
return lastItem.CellData.PropertyValue;
}
#endregion Methods
} columns.AddColumn(column =>
{
column.PropertyName<VoucherRowPrintViewModel>(x => x.CaclulatedRemains);
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Right);
column.IsVisible(true);
column.Order(5);
column.Width(1.5f);
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.CustomAggregateFunction(new MySampleAggregateFunction());
aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
column.HeaderCell("مانده");
}); 
SQL Server 2022 is on its way and there are a lot of new features that could be of interest. Check out this summary of new features and things to investigate.
The latest version of the NetBeans IDE features a range of new tools for HTML5/JavaScript and supports mixed Java/C++ development. It is now available for download in beta.
