using the providerbase model

列举可用的Providers

 1using System;
 2using System.Collections.Generic;
 3using System.Linq;
 4using System.Text;
 5using System.Data;
 6using System.Data.Common;
 7
 8namespace 查看数据库
 9{
10    class Program
11    {
12        static void Main(string[] args)
13        {
14            DataTable factoryClassTable = DbProviderFactories.GetFactoryClasses();
15            foreach (DataRow factoryCass in factoryClassTable.Rows)
16            {
17                Console.WriteLine("Name:" + factoryCass["Name"]);
18                Console.WriteLine("Description:" + factoryCass["Description"]);
19                Console.WriteLine("Invariant Name:" + factoryCass["InvariantName"]);
20                Console.WriteLine("\n");
21            }
22        }
23    }
24}

运行结果：