c#:使用任何字符执行sql LIKE搜索的正确方法是什么

using System.Data.SqlClient;

string connectionString = "your_connection_string";
string searchText = "your_search_text";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    using (SqlCommand command = new SqlCommand("SELECT * FROM your_table WHERE your_column LIKE @searchText", connection))
    {
        command.Parameters.AddWithValue("@searchText", $"%{searchText}%");

        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
    }
}

using System.Linq;
using Microsoft.EntityFrameworkCore;

string searchText = "your_search_text";

using (YourDbContext context = new YourDbContext())
{
    var results = context.YourTable
        .Where(x => EF.Functions.Like(x.YourColumn, $"%{searchText}%"))
        .ToList();

    // 处理查询结果
}