<configuration>

   <startup>

     <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />

   </startup>

   <connectionStrings>

     <add name="fb" connectionString="Server=localhost;User=SYSDBA;Password=1234;Database=wms;Dialect=3;ServerType=0;"/>

   </connectionStrings>

   <system.data>

     <DbProviderFactories>

       <remove invariant="FirebirdSql.Data.FirebirdClient" />

       <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient"

            description=".NET Framework Data Provider for Firebird"

            type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient" />

     </DbProviderFactories>

   </system.data>

 </configuration>

     static class JsonHelper

     {

         public static string ToJson(this object obj)

         {

             var str = JsonConvert.SerializeObject(obj, Formatting.Indented, new JsonSerializerSettings

             {

                 NullValueHandling = NullValueHandling.Ignore,

                 DateFormatString = "yyyy-MM-dd HH:mm:ss",

                 ReferenceLoopHandling = ReferenceLoopHandling.Ignore//循环引用

             });

             return str;

         }

         public static T FromJson<T>(this string json) where T : class

         {

             return JsonConvert.DeserializeObject(json, typeof(T), new IsoDateTimeConverter

             {

                 DateTimeFormat = "yyyy-MM-dd HH:mm:ss"

             }) as T;

         }

     }

             var connectionString = ConfigurationManager.ConnectionStrings["fb"].ConnectionString;

             using (var db = new DbContext().ConnectionString(

                 connectionString,

                 new DB2Provider(),

                 FirebirdSql.Data.FirebirdClient.FirebirdClientFactory.Instance))

             {

                 List<dynamic> users = db.Sql(@"SELECT

   M_USER.ID,

   M_USER.CODE,

   M_USER.PWD,

   M_USER.LABEL,

   M_USER.CRE_TIME

 FROM

   M_USER

 where id > @0").Parameters().QueryMany<dynamic>();

                 foreach (var user in users)

                 {

                     var tem = user as IDictionary<string, object>;

                     Console.WriteLine(tem.ToJson());

                 }

             }

             Console.ReadLine();