Your current context must have an opened connection to be able to drop the database. The problem is that there can be other opened connections which will block your db initializer. One very nice example is having opened any table from your database in management studio. Another possible problem can be opened connections in the … Read more
I know this is not a recent question, but I’ll post my answer anyway, because I believe someone may find it useful. As probably many others, I followed the steps mentioned in the accepted answer. Yay, it works. HOWEVER, there’s one catch: Methods BeginRequest() and EndRequest() fire each time a request is made, but not … Read more
The DataType Attribute is a Validation Attribute. You need to do that using the ModelBuilder. public class MyContext : DbContext { public DbSet<MyClass> MyClass; protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<MyClass>().Property(x => x.SnachCount).HasPrecision(16, 3); modelBuilder.Entity<MyClass>().Property(x => x.MinimumStock).HasPrecision(16, 3); modelBuilder.Entity<MyClass>().Property(x => x.MaximumStock).HasPrecision(16, 3); } }
[Column(TypeName = “varchar(MAX)”)] Surprisingly the most obvious solution works. The [MaxLength] attribute only creates a varchar column with a max length that isn’t MAX but – in my case (SQL Server Express 2008 R2) – 8000.
you must manually create the view, just like AnatoliiG stated. (Adding index to a table). You add the name of the view as an attribute to your class [Table(“UserDTO”)] public class UserDTO { /* Class code here */ } You can create an empty migration by specifying the -IgnoreChanges attribute at the end Add-Migration MigrationName … Read more
I found it! I can read the return value with an output parameter that has to be used in this way: // define a new output parameter var returnCode = new SqlParameter(); returnCode.ParameterName = “@ReturnCode”; returnCode.SqlDbType = SqlDbType.Int; returnCode.Direction = ParameterDirection.Output; // assign the return code to the new output parameter and pass it to … Read more
The problem boiled down to the query. My original question had this query: var allPartners = DbContext.User .Include(u => u.Businesses) .Where(u => u.Businesses.Any(x => x.Id == currentBusinessId)) .ToList(); Which wasn’t quite accurate, I had in fact removed the error in an attempt to ask my question succinctly. The query was actually: var currentBusiness = GetBusiness(); … Read more
I appreciate the effort that went into the existing answer, but I haven’t found it actually answering the question… so I tested this, and found out that [Column(TypeName = “ntext”)] public string Body { get; set; } (the one from System.ComponentModel.DataAnnotations) will work to create an ntext type column. (My problem with the accepted answer … Read more
Hope this is still on time to help you. I was also having the exact same problem and was troubling with it for almost an hour until I could spot my mistake. The problem is that Course.Venue relationship is optional (as declared on the fluent API), but the Id declaration of Course.VenueId is mandatory, so … Read more
For those of you who would still have this error with all keys properly defined, have a look at your entities and make sure you don’t leave a datetime field with a null value.