public void WriteServer() { var session = new DataSession("Tracker").Log(Console.WriteLine); session.Should().NotBeNull(); string email = "*****@*****.**"; string sql = "select * from [User] where EmailAddress like @EmailAddress"; var users = session.Sql(sql) .Parameter("@EmailAddress", email) .Query(r => new User { Id = r.GetInt32("Id"), EmailAddress = r.GetString("EmailAddress"), FirstName = r.GetString("FirstName"), LastName = r.GetString("LastName"), Avatar = (Byte[])r.GetValue("Avatar"), CreatedDate = r.GetDateTime("CreatedDate"), ModifiedDate = r.GetDateTime("ModifiedDate"), RowVersion = (Byte[])r.GetValue("RowVersion"), PasswordHash = r.GetStringNull("PasswordHash"), PasswordSalt = r.GetStringNull("PasswordSalt"), Comment = r.GetStringNull("Comment"), IsApproved = r.GetBoolean("IsApproved"), LastLoginDate = r.GetDateTimeNull("LastLoginDate"), LastActivityDate = r.GetDateTime("LastActivityDate"), LastPasswordChangeDate = r.GetDateTimeNull("LastPasswordChangeDate"), AvatarType = r.GetStringNull("AvatarType"), }) .ToList(); users.Should().NotBeNull(); users.Should().NotBeEmpty(); long ticks = DateTime.Now.Ticks; foreach (var u in users) { u.EmailAddress = u.EmailAddress.Replace("@battlestar", "@u" + ticks); } session.BulkCopy("[User]") .Mapping("EmailAddress", "EmailAddress") .Mapping("FirstName", "FirstName") .Mapping("LastName", "LastName") .Mapping("CreatedDate", "CreatedDate") .Mapping("ModifiedDate", "ModifiedDate") .Mapping("PasswordHash", "PasswordHash") .Mapping("PasswordSalt", "PasswordSalt") .Mapping("Comment", "Comment") .Mapping("IsApproved", "IsApproved") .Mapping("LastLoginDate", "LastLoginDate") .Mapping("LastActivityDate", "LastActivityDate") .Mapping("LastPasswordChangeDate", "LastPasswordChangeDate") .Mapping("AvatarType", "AvatarType") .WriteToServer(users); }
public void WriteServerAutoMap() { var session = new DataSession("Tracker").Log(Console.WriteLine); session.Should().NotBeNull(); string email = "*****@*****.**"; string sql = "select * from [User] where EmailAddress like @EmailAddress"; var users = session.Sql(sql) .Parameter("@EmailAddress", email) .Query(r => new User { Id = r.GetInt32("Id"), EmailAddress = r.GetString("EmailAddress"), FirstName = r.GetString("FirstName"), LastName = r.GetString("LastName"), Avatar = (Byte[])r.GetValue("Avatar"), CreatedDate = r.GetDateTime("CreatedDate"), ModifiedDate = r.GetDateTime("ModifiedDate"), RowVersion = (Byte[])r.GetValue("RowVersion"), PasswordHash = r.GetStringNull("PasswordHash"), PasswordSalt = r.GetStringNull("PasswordSalt"), Comment = r.GetStringNull("Comment"), IsApproved = r.GetBoolean("IsApproved"), LastLoginDate = r.GetDateTimeNull("LastLoginDate"), LastActivityDate = r.GetDateTime("LastActivityDate"), LastPasswordChangeDate = r.GetDateTimeNull("LastPasswordChangeDate"), AvatarType = r.GetStringNull("AvatarType"), }) .ToList(); users.Should().NotBeNull(); long ticks = DateTime.Now.Ticks; foreach (var u in users) u.EmailAddress = u.EmailAddress.Replace("@battlestar", "@u" + ticks); session.BulkCopy("[User]") .AutoMap() .Ignore("AvatarType") .Ignore("Audits") .Ignore("AssignedTasks") .Ignore("CreatedTasks") .Ignore("Roles") .WriteToServer(users); }