bgrainger

using System;
using MySql.Data.MySqlClient;

namespace MySqlCompressBlob
{
	class Program
	{
		static void Main(string[] args)
		{
			var csb = new MySqlConnectionStringBuilder

bgrainger

public class CpuTimer
{
	public void Start()
	{
		m_sw = Stopwatch.StartNew();
		using (var process = Process.GetCurrentProcess())
		{
			m_total = process.TotalProcessorTime;
			m_user = process.UserProcessorTime;
			m_kernel = process.PrivilegedProcessorTime;

bgrainger

BenchmarkDotNet=v0.10.3.0, OS=Microsoft Windows 10.0.14393
Processor=Intel(R) Xeon(R) CPU E5-1650 v3 3.50GHz, ProcessorCount=12
Frequency=3410069 Hz, Resolution=293.2492 ns, Timer=TSC
dotnet cli version=1.0.1
  [Host]     : .NET Core 4.6.25009.03, 64bit RyuJIT
  DefaultJob : .NET Core 4.6.25009.03, 64bit RyuJIT

Method | Mean | StdDev | Gen 0 | Allocated

bgrainger

async Task Main()
{
	var httpClient = new HttpClient();
	var html57 = await (await httpClient.GetAsync("https://dev.mysql.com/doc/mysql-errors/5.7/en/server-error-reference.html")).Content.ReadAsStringAsync();
	var html8 = await (await httpClient.GetAsync("https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html")).Content.ReadAsStringAsync();

	var valueNames = new Dictionary<int, string>();
	foreach (MySqlErrorCode value in Enum.GetValues(typeof(MySqlErrorCode)))
	{
		var intValue = (int)value;

bgrainger

void Main()
{
	var name = "test";
	var state = "WA";
	var cmd = new MySqlConnection().CreateCommand($"SELECT * FROM Customers WHERE Name = {name} AND State = {state};");
	// cmd.CommandText == "SELECT * FROM Customers WHERE Name = @p0 AND State = @p1;"
}

public static class DbExtensions
{

bgrainger

// Make sure to set AllowUserVariables=true in connection string

private string SqlLogUpdate => _sqlLogUpdate ?? (_sqlLogUpdate = $@"
Update {_tableName} 
Set DuplicateCount = DuplicateCount + @DuplicateCount,
   GUID = (@newGUID := GUID) -- set the variable here
Where ErrorHash = @ErrorHash; -- AND ...
Select @newGUID; -- still have to select it to get it back";

protected override bool LogError(Error error)

bgrainger

void Main()
{
	using (var writer = new StreamWriter(@"GetValueConversionTestBase.g.cs"))
	{
		writer.WriteLine("using System;");
		writer.WriteLine("using System.CodeDom.Compiler;");
		writer.WriteLine("using System.Data;");
		writer.WriteLine("using System.Threading.Tasks;");
		writer.WriteLine("using Xunit;");
		writer.WriteLine("");

bgrainger

Mapping from BibleWorks Hebrew (BWHEBB) to Unicode

Mapping based on The BibleWorks Hebrew Keyboard Map (BWHEBB) and The BibleWorks Hebrew Accent Character Codes.

Table referenced from Converting BibleWorks Hebrew blog post.

(Note: alephs for combining characters are used for illustrative purposes only.)

8-bit (dec) | 8-bit (hex) | Win-1252 | Unicode | Untransliteration | Output

bgrainger

var reservedWords = new[]
{
  "ACCESSIBLE",
  "ADD",
  "ALL",
  "ALTER",
  "ANALYZE",
  "AND",
  "AS",
  "ASC",

bgrainger

HRESULT FontFileStream::ReadFileFragment(const void ** fragmentStart, UINT64 fileOffset, UINT64 fragmentSize, void ** fragmentContext)
{
	if (fragmentStart != nullptr)
		*fragmentStart = nullptr;
	if (fragmentContext != nullptr)
		*fragmentContext = nullptr;
	if (fragmentStart == nullptr || fragmentContext == nullptr)
		return E_POINTER;
	if (fileOffset >= m_length || fileOffset + fragmentSize > m_length)
		return E_INVALIDARG;