Dapper Tutorial - Knowledge Base (KB)

C# Dapper using JSON_VALUE for SQL Server 2016

I want to query data from my table using ...JSON_VALUE...:...var str = "123"; var value = "Name" using(var conn = GetMyConnection()) { var result = conn.QueryFirstOrDefault<string>( @"SELECT [Id] FROM [dbo].[MyTable] WHERE JSON_VALUE([Js...