PetaPoco

var sql = @"SELECT TOP 1000 [Id]
      ,[UserName]
      ,[Name]
      ,[HeadimgUrl]
      ,[PasswordHash]
      ,[Email]
      ,[Enable]
      ,[LoginTimes]
      ,[LastLoginTime]
      ,[CreatedTime]
      ,[NickName]
      ,[UserType]
      ,[ParentUserId]
      ,[Money]
      ,[SecurityStamp]
      ,[PhoneNumber]
      ,[PhoneNumberConfirmed]
      ,[TwoFactorEnabled]
      ,[LockoutEndDateUtc]
      ,[LockoutEnabled]
      ,[AccessFailedCount]
  FROM [Candoo.Zero].[dbo].[sys_User]";
            PetaPoco.Database db = new PetaPoco.Database("mssql_default");
            var list = db.Fetch<dynamic>(sql);
            foreach (var item in list)
            {
                Response.Write(item.UserName);
            }