以下是一个C#在MySql上执行查询的泛型方法的示例:

using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;

public static class MySqlHelper
{
    private static readonly string connectionString = "your_connection_string_here";

    public static List<T> ExecuteQuery<T>(string sql, Func<IDataReader, T> mapper)
    {
        using (var connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            using (var command = new MySqlCommand(sql, connection))
            {
                using (var reader = command.ExecuteReader())
                {
                    var results = new List<T>();

                    while (reader.Read())
                    {
                        T result = mapper(reader);
                        results.Add(result);
                    }

                    return results;
                }
            }
        }
    }
}

该方法接受一个SQL查询字符串和一个将IDataReader转换为泛型类型的委托作为参数。它使用MySqlConnection和MySqlCommand实现对MySql数据库的查询,并返回一个泛型列表。可以使用它来查询任何类型的数据,只需提供一个将IDataReader转换为该类型的方法即可。以下是一个使用示例:

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

var sql = "SELECT * FROM people";

var people = MySqlHelper.ExecuteQuery(sql, reader =>
{
    var person = new Person();
    person.Id = reader.GetInt32(0);
    person.Name = reader.GetString(1);
    person.Age = reader.GetInt32(2);
    return person;
});

foreach (var person in people)
{
    Console.WriteLine($"Id: {person.Id}, Name: {person.Name}, Age: {person.Age}");
}
``
写一个C#在MySql上执行查询的泛型方法

原文地址: https://www.cveoy.top/t/topic/frhS 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录