C# scripting in Excel

by bill-s, 2017-11-12T09:39:33.000Z

Being a modern language with access to a rich ecosystem of libraries, C# can be immensely helpful both for automation and data processing in Excel. The goal of QueryStorm in this regard is to make C# easily available in Excel in order to help developers, db professionals and data scientists make better use of Excel. The C# scripting engine in QueryStorm is powered by the Roslyn compiler.

Deploying a .NET Core 2 app to a Raspberry Pi with Cake and PuTTY saved sessions

by bill-s, 2017-11-12T09:34:13.000Z

This post shows how to use your PuTTY saved sessions to deploy from a Windows machine to your Raspberry Pi instead of specifying IP address and username.

devart .NET Core 2.0 and Entity Framework Core 2.0 Support

by bill-s, 2017-11-12T09:37:05.000Z

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers for databases, LinqConnect - LINQ to SQL-compatible ORM solution, and Entity Developer - our ORM designer.

Lightweight bundling, minifying, and compression, for CSS and JavaScript with ASP.NET Core and Smidge

by bill-s, 2017-11-09T18:23:28.000Z

Yesterday I blogged about WebOptimizer, a minifier that Mads Kristensen wrote for ASP.NET Core. A few people mentioned that Shannon Deminick also had a great minifier for ASP.NET Core.

Tricky Questions about C#

by bill-s, 2017-11-12T09:34:38.000Z

Here is an interesting article with the questions about C# language that may be tricky to the developers. This article may be useful for junior and middle developers.

Live Unit Testing | ASP.NET Monsters

by bill-s, 2017-11-09T17:01:10.000Z

The new live unit testing capabilities of Visual Studio 2017 are a real timesaver. In this video, we take a poke around at them.

Rigging up Roslyn Analyzers in .NET Core

by bill-s, 2017-11-12T09:38:54.000Z

I love Live Code Analyzers in VS2017. The analyzers help identify bad coding patterns, resource leaks and just generally aid one be a better developer by alerting when things are not done optimally.

Using ASP.NET ModelState With Vue.js

by bill-s, 2017-11-09T18:24:59.000Z

Recently I've been using more and more Vue.js in the client code for my ASP.NET MVC websites. It provides a great balance between modern interactive client functionality and server logic. However, one area that's been troubling me is how to integrate the powerful built-in ModelState server-side validation framework with the client, particularly in WebAPI or other service-based scenarios. Ideally, I'd like to display server-side validation errors on the client when data fails to validate due to validation attributes like [Required]. This article shows one way to do that.

Track and remediate potential database vulnerabilities with SQL Vulnerability Assessment

by bill-s, 2017-11-09T18:24:01.000Z

Vulnerability Assessment is a scanning service built into Azure SQL Database. The service employs a knowledge base of rules that identify security vulnerabilities and deviations from best practices, such as misconfigurations, excessive permissions, and exposed sensitive data.

Microsoft/YamUI: Reusable component framework for Yammer.com

by bill-s, 2017-11-12T16:46:37.000Z

Microsoft has open sourced the UI component framework used for Yammer.com