Gushwell's C# Dev Notes

   mixiチェック Tweet

using (var db = new NorthwindContext()) {
    db.Configuration.ValidateOnSaveEnabled = false;
    ...
}

using (var db = new NorthwindContext()) {
    db.Configuration.AutoDetectChangesEnabled = false;
    ...
}

using (var db = new NorthwindContext()) {
    db.Database.CommandTimeout = 180;
    ...
}

using (var db = new NorthwindContext()) {
    var query = db.Products.AsNoTracking()
                  .Where(p => p.UnitPrice < 10);
    foreach (var p in query) {
        Console.WriteLine(p.ProductName);
    }
}

   mixiチェック Tweet

public partial class Customer : IValidatableObject {
    public IEnumerable<ValidationResult> Validate(ValidationContext validationContext) {
        if (!string.IsNullOrWhiteSpace(ContactTitle) && string.IsNullOrWhiteSpace(ContactName) ) {
            var msg = "ContactTitleに値が設定されている時は、ContactNameにも値を設定する必要があります。";
            var members = new[] { "ContactName" }; 
            yield return new ValidationResult(msg,members);

        }
    }
}

using (var db = new NorthwindContext()) {
    try {
        Customer cust = new Customer {
            CustomerID = "CSFM",
            CompanyName = "CSharp Food Market",
            ContactTitle = "Manager"
        };
        db.Customers.Add(cust);
        db.SaveChanges();
    } catch (DbEntityValidationException ex) {
        PrintEntityValidationErrors(ex.EntityValidationErrors);
    }
}

   mixiチェック Tweet

[AttributeUsage(AttributeTargets.Property, AllowMultiple = false)]
 public sealed class HiraganaAttribute : ValidationAttribute {
     private static Regex _regex = new Regex(@"^[\p{IsHiragana}\u30FC]+$");

     public override bool IsValid(object value) {
         if (value == null) {
             return true;
         }

         string valueAsString = value as string;
         if (valueAsString != null) {
             var m = _regex.Match(valueAsString);
             return m.Success;
         } else {
             return true;
         }
     }

     public override string FormatErrorMessage(string name) {
         return $"{name}はひらがなを指定してください";
     }
 }

[Hiragana]
public string KanaName { get; set; }

[MetadataType(typeof(Category.Metadata))]
public partial class Category {
    class Metadata {
        [ConcurrencyCheck]
        public string CategoryName { get; set; }

        [ConcurrencyCheck]
        [Hiragana]
        public string Description { get; set; }

        [ConcurrencyCheck]
        public byte[] Picture { get; set; }
    }
}