using System;

using System.Data.SqlClient;

using DBSearch;

using Newtonsoft.Json;

using Dapper;

public class Program

{    

    public static void Main()

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools()))

        {   

            var searchText = "%Maria Anders%";

            var result = connection.Search(searchText,column=> {

                var sql = string.Format("select * from {0} where {1} like '{2}'",column.TableName,column.ColumnName,searchText);

                var data = connection.Query(sql);   

                Console.WriteLine(JsonConvert.SerializeObject(data));   

            });

        }

    }

}

​