写一个C#在MySql上执行查询的泛型方法
以下是一个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}");
}
``
原文地址: https://www.cveoy.top/t/topic/frhS 著作权归作者所有。请勿转载和采集!