在ASP.Net内核中访问SQL数据库外的UserID

using System;
using System.Data.SqlClient;

namespace YourNamespace
{
    public class YourClass
    {
        public int GetUserID()
        {
            string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

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

                string sqlQuery = "SELECT UserID FROM YourTable"; // 替换为实际的查询语句

                using (SqlCommand command = new SqlCommand(sqlQuery, connection))
                {
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        if (reader.Read())
                        {
                            int userID = reader.GetInt32(0); // 假设UserID是整数类型，可以根据实际情况调整
                            return userID;
                        }
                    }
                }
            }

            return 0; // 如果未找到UserID，返回默认值
        }
    }
}