// Dapper

// Doc: https://dapper-tutorial.net/async

​

// @nuget: Dapper -Version 1.60.6

​

using Dapper;

using System;

using System.Data.SqlClient;

using System.Linq;

using System.Threading.Tasks;

using System.Collections.Generic;

public class Program

{   

    public class Customer 

    {

        public string CustomerName  {get;set;}

        public string ContactName   {get;set;}

    }

    public static async Task Main()

    {

        string str = "sa";

        List<Customer> cust = new List<Customer>();

        cust.Add(new Customer{CustomerName ="sam",ContactName = "mmm"});

        cust.Add(new Customer{CustomerName ="mmm",ContactName = "sam"});

        cust = cust.Where(p => p.CustomerName.ToLower().Contains(str.ToLower())).ToList(); //.Union(cust.Where(p => p.ContactName.ToLower().Contains(str.ToLower()))).ToList();

            cust = cust.Where(p => p.ContactName.ToLower().Contains(str.ToLower())).ToList();

        foreach(var item in cust)

        {

            Console.Write($"Customer name : {item.CustomerName}   ", item.CustomerName);

            Console.Write($"Contact name : {item.ContactName}   ", item.ContactName);

            Console.WriteLine();

        }

    }

}