在.NET内核的数据库中检查给定值的最佳方法

using System.Data.SqlClient;

public bool CheckValueExists(string valueToCheck)
{
    string connectionString = "your_connection_string_here";
    string query = "SELECT COUNT(*) FROM YourTable WHERE YourColumn = @Value";

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(query, connection);
        command.Parameters.AddWithValue("@Value", valueToCheck);

        connection.Open();
        int count = (int)command.ExecuteScalar();
        return count > 0;
    }
}

using Microsoft.EntityFrameworkCore;

public class YourDbContext : DbContext
{
    public DbSet<YourEntity> YourEntities { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("your_connection_string_here");
    }
}

public bool CheckValueExists(string valueToCheck)
{
    using (YourDbContext context = new YourDbContext())
    {
        return context.YourEntities.Any(entity => entity.YourColumn == valueToCheck);
    }
}