直接上代码了
static void Main(string[] args)
{
string conn = @"Initial Catalog=aaa;Data Source = 192.168.1.1; Integrated Security = False; User ID = sa; Password=123;MultipleActiveResultSets=True;Encrypt=False;TrustServerCertificate=False";
SqlBulkCopyByDatatable(conn, "Permission", GetTableSchema());
}
static void Main(string[]