搜索.Net核心应用程序中的输入字符串并将其与多个SQL列进行比较

SELECT * FROM table_name WHERE column1 LIKE '%search_string%' OR column2 LIKE '%search_string%' OR column3 LIKE '%search_string%';

using System;
using System.Data;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "your_connection_string";
        string searchQuery = "search_string";

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

            string sqlQuery = "SELECT * FROM table_name WHERE column1 LIKE '%' + @searchString + '%' OR column2 LIKE '%' + @searchString + '%' OR column3 LIKE '%' + @searchString + '%'";
            SqlCommand command = new SqlCommand(sqlQuery, connection);
            command.Parameters.AddWithValue("@searchString", searchQuery);

            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable dataTable = new DataTable();
            adapter.Fill(dataTable);

            // 处理查询结果
            foreach (DataRow row in dataTable.Rows)
            {
                // 处理每一行的数据
            }
        }
    }
}