MVC EntityFramework Code-First Migration is executing, but Seed not taking effect?

Question

I've been following the below tutorial in an attempt to set up Code-First EntityFramework Migrations in my MVC5 App and then Seed my database with some sample data for use: http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

My project is now successfully building, and I can go through all of the steps to modify my initial database:

 - update-database -targetmigration:"0" -force -verbose
 - *Delete Current Migrations
 - add-migration InitialCreate
 - update-database

When the last command completes, my Seed method is supposedly being ran (and I can see the tables being created using the -verbose parameter). However, there is no entry in my INV_Assets table where there should be one as specified by my current seeding.

Can anyone offer some input as to why my Seed method does not appear to be taking effect, though it seems to be running?

InventoryTracker.DAL.InventoryInitializer.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using InventoryTracker.Models;
using InventoryTracker.DAL;
using WebMatrix.WebData;

namespace InventoryTracker.DAL
{
    public class InventoryInitializer : System.Data.Entity.DropCreateDatabaseIfModelChanges
    {
        InventoryTrackerContext context = new InventoryTrackerContext();

        protected override void Seed(InventoryTrackerContext context)
        {
            List invLocs = getLocations();
            invLocs.ForEach(s => context.INV_Locations.Add(s));
            List invManufacturers = getManufacturers();
            invManufacturers.ForEach(s => context.INV_Manufacturers.Add(s));
            List invModels = getModels();
            invModels.ForEach(s => context.INV_Models.Add(s));
            List invStatuses = getStatuses();
            invStatuses.ForEach(s => context.INV_Statuses.Add(s));
            List invTypes = getTypes();
            invTypes.ForEach(s => context.INV_Types.Add(s));
            List invVendors = getVendors();
            invVendors.ForEach(s => context.INV_Vendors.Add(s));

            List invAssets = getAssets();
            invAssets.ForEach(s => context.INV_Assets.Add(s));

            context.SaveChanges();
        }

        #region Seed Assets
        private List getAssets()
        {
            List testAssets = new List
            {
                new INV_Assets
                {
                    Id = 1,
                    ip_address = "10.10.135.38",
                    mac_address = "10.10.177.44",
                    note = "",
                    owner = "John Smith",
                    cost = 35,
                    po_number = "G348",
                    invoice_number = 1447,
                    serial_number = "JX14582Y",
                    asset_tag_number = "293548195023",
                    acquired_date = Convert.ToDateTime(10212014),
                    disposed_date = null,
                    created_by = "Admin",
                    created_date = DateTime.Now,
                    location_id = 1,
                    manufacturer_id = 1,
                    model_id = 1,
                    status_id = 2,
                    type_id = 3,
                    vendor_id = 3
                }
            };
            return testAssets;
        }
        #endregion

        [Seed Locations]
        [Seed Manufacturers]

        #region Seed Models
        private List getModels()
        {
            List testModels = new List
            {
                new INV_Models
                {
                    Id = 1,
                    model_description = "XTERAV12",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Models
                {
                    Id = 2,
                    model_description = "5330",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Models
                {
                    Id = 1,
                    model_description = "Sunblade 6000",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testModels;
        }
        #endregion

        [Seed Statuses]
        [Seed Types]
        [Seed Vendors]
     }
   }

InventoryTracker.DAL.InventoryTrackerContext.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using InventoryTracker.Models;
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;

namespace InventoryTracker.DAL
{
    public class InventoryTrackerContext : DbContext
    {
        public InventoryTrackerContext()
            : base("InventoryTrackerContext")
        {

        }

        public DbSet INV_Assets { get; set; }
        public DbSet INV_Models { get;set; }
        public DbSet INV_Manufacturers { get;set; }
        public DbSet INV_Types { get; set; }
        public DbSet INV_Locations { get; set; }
        public DbSet INV_Vendors { get; set; }
        public DbSet INV_Statuses { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
             modelBuilder.Conventions.Remove();
        }
    }
}

Web.config:

EDIT:

Ok, so it seems where I was going wrong was setting up my Seed in the wrong location. It should have all along been in the InventoryTracer.Migrations.Configuration.cs file... which had no seeding coded into it... which is why I was not getting any inserted data after Seed... :/

I've now moved seeding into the proper seed method in the Configuration.cs file, but I'm getting an error: Invalid cast from 'Int32' to 'DateTime'.

The full trace from Package Manager Console is as follows:

Running Seed method.
System.InvalidCastException: Invalid cast from 'Int32' to 'DateTime'.
   at System.Int32.System.IConvertible.ToDateTime(IFormatProvider provider)
   at System.Convert.ToDateTime(Int32 value)
   at InventoryTracker.Migrations.Configuration.getAssets() in c:\James-Projects\InventoryTracker\InventoryTracker\Migrations\Configuration.cs:line 57
   at InventoryTracker.Migrations.Configuration.Seed(InventoryTrackerContext context) in c:\James-Projects\InventoryTracker\InventoryTracker\Migrations\Configuration.cs:line 47
   at System.Data.Entity.Migrations.DbMigrationsConfiguration`1.OnSeed(DbContext context)
   at System.Data.Entity.Migrations.DbMigrator.SeedDatabase()
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.SeedDatabase()
   at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
   at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
   at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.b__b()
   at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
   at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
   at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
   at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.Run()
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   at System.Data.Entity.Migrations.Design.ToolingFacade.Update(String targetMigration, Boolean force)
   at System.Data.Entity.Migrations.UpdateDatabaseCommand.<>c__DisplayClass2.<.ctor>b__0()
   at System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action command)
Invalid cast from 'Int32' to 'DateTime'.

I'm not quite sure where the cast error is occurring though, as Lines 47/57 of my Configuration.cs respectively are:

47 - List invAssets = getAssets();
57 - List testAssets = new List

My guess would be it is revolving around line 71 - acquired_date = Convert.ToDateTime(10212014),.

Anyone have thoughts on how to resolve this?

Configuration.cs:

namespace InventoryTracker.Migrations
{
    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Data.Entity.Migrations;
    using System.Linq;
    using System.Web;
    using InventoryTracker.Models;
    using InventoryTracker.DAL;
    using WebMatrix.WebData;

    internal sealed class Configuration : DbMigrationsConfiguration
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = false;
        }

        protected override void Seed(InventoryTracker.DAL.InventoryTrackerContext context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet.AddOrUpdate() helper extension method 
            //  to avoid creating duplicate seed data. E.g.
            //
            //    context.People.AddOrUpdate(
            //      p => p.FullName,
            //      new Person { FullName = "Andrew Peters" },
            //      new Person { FullName = "Brice Lambson" },
            //      new Person { FullName = "Rowan Miller" }
            //    );
            //
            List invLocs = getLocations();
            invLocs.ForEach(s => context.INV_Locations.Add(s));
            List invManufacturers = getManufacturers();
            invManufacturers.ForEach(s => context.INV_Manufacturers.Add(s));
            List invModels = getModels();
            invModels.ForEach(s => context.INV_Models.Add(s));
            List invStatuses = getStatuses();
            invStatuses.ForEach(s => context.INV_Statuses.Add(s));
            List invTypes = getTypes();
            invTypes.ForEach(s => context.INV_Types.Add(s));
            List invVendors = getVendors();
            invVendors.ForEach(s => context.INV_Vendors.Add(s));

            List invAssets = getAssets();
            invAssets.ForEach(s => context.INV_Assets.Add(s));

            context.SaveChanges();
        }


        #region Seed Assets
        private List getAssets()
        {
            List testAssets = new List
            {
                new INV_Assets
                {
                    Id = 1,
                    ip_address = "10.10.135.38",
                    mac_address = "10.10.177.44",
                    note = "",
                    owner = "John Smith",
                    cost = 35,
                    po_number = "G348",
                    invoice_number = 1447,
                    serial_number = "JX14582Y",
                    asset_tag_number = "293548195023",
                    acquired_date = Convert.ToDateTime(10212014),
                    disposed_date = null,
                    created_by = "Admin",
                    created_date = DateTime.Now,
                    Location_Id = 1,
                    Manufacturer_Id = 1,
                    Model_Id = 1,
                    Status_Id = 2,
                    Type_Id = 3,
                    Vendor_Id = 3
                }
            };
            return testAssets;
        }
        #endregion

        #region Seed Locations
        private List getLocations()
        {
            List testLocations = new List
            {
                new INV_Locations
                {
                    Id = 1,
                    location_dept = "IT",
                    location_room = "Server",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Locations
                {
                    Id = 2,
                    location_dept = "Break Room",
                    location_room = "Kitchen",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Locations
                {
                    Id = 3,
                    location_dept = "Accounting",
                    location_room = "Conference",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testLocations;
        }
        #endregion

        #region Seed Manufacturers
        private List getManufacturers()
        {
            List testManufacturers = new List
            {
                new INV_Manufacturers
                {
                    Id = 1,
                    manufacturer_description = "Samsung",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Manufacturers
                {
                    Id = 2,
                    manufacturer_description = "MITEL",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Manufacturers
                {
                    Id = 1,
                    manufacturer_description = "Oracle",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testManufacturers;
        }
        #endregion

        #region Seed Models
        private List getModels()
        {
            List testModels = new List
            {
                new INV_Models
                {
                    Id = 1,
                    model_description = "XTERAV12",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Models
                {
                    Id = 2,
                    model_description = "5330",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Models
                {
                    Id = 1,
                    model_description = "Sunblade 6000",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testModels;
        }
        #endregion

        #region Seed Statuses
        private List getStatuses()
        {
            List testStatuses = new List
            {
                new INV_Statuses
                {
                    Id = 1,
                    status_description = "AVAILABLE",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Statuses
                {
                    Id = 2,
                    status_description = "SIGNEDOUT",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Statuses
                {
                    Id = 3,
                    status_description = "RECYCLED",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Statuses
                {
                    Id = 4,
                    status_description = "AUCTIONED",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testStatuses;
        }
        #endregion

        #region Seed Types
        private List getTypes()
        {
            List testTypes = new List
            {
                new INV_Types
                {
                    Id = 1,
                    type_description = "Server",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Types
                {
                    Id = 2,
                    type_description = "IP Phone",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Types
                {
                    Id = 1,
                    type_description = "Monitor",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testTypes;
        }
        #endregion

        #region Seed Vendors
        private List getVendors()
        {
            List testVendors = new List
            {
                new INV_Vendors
                {
                    Id = 1,
                    vendor_name = "Oracle",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Vendors
                {
                    Id = 2,
                    vendor_name = "Centriq",
                    created_by = "Admin",
                    created_date = DateTime.Now
                },
                new INV_Vendors
                {
                    Id = 1,
                    vendor_name = "Samsung",
                    created_by = "Admin",
                    created_date = DateTime.Now
                }
            };
            return testVendors;
        }
        #endregion

    }
}

EDIT2:

I think I've got the Invalid cast from 'Int32' to 'DateTime'. taken care of by changing acquired_date = Convert.ToDateTime(10212014) to acquired_date = DateTime.ParseExact("10212014", "MMddyyyy", CultureInfo.InvariantCulture), but now I have a new error.

When I run the update-database command, my Seed method now fails with error Ambiguous match found. By placing the following code at the topmost part of my Seed() I tried to get some more information:

        if (System.Diagnostics.Debugger.IsAttached == false)
        {
            System.Diagnostics.Debugger.Launch();
        }

When the code reaches invAssets.ForEach(s => context.INV_Assets.Add(s)); the Debugger that I launched catches with An exception of type 'System.Reflection.AmbiguousMatchException' occurred in mscorlib.dll but was not handled in user code. Additional information: Ambiguous match found.

Anyone have thoughts on what is causing this? I could see potential of an Ambiguous error were I adding more than one test record, but at this time I only have the one record being seeded for INV_Assets.

Following Soren Gustenhoff suggestions, I changed the Foreach => Add() to use .AddRange() and added a preliminary context.SaveChanges() before the getAssets() is called, but that only resulted in the following when the AddRange(invTypes) is called?

An exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll but was not handled in user code

Additional information: An error occurred while updating the entries. See the inner exception for details.

CODE: context.INV_Types.AddRange(invTypes); // exception of type 'System.Data.Entity.Infrastructure.DbUpdateException //context.SaveChanges(); List invVendors = getVendors(); context.INV_Vendors.AddRange(invVendors); context.SaveChanges(); // Commenting this flags [getVendors()] with the Ambiguous Error?

        List invAssets = getAssets();
        context.INV_Assets.AddRange(invAssets);

        context.SaveChanges();

Going back to only having the one context.SaveChanges() at the end, my getVendors() is flagging with the AmbiguousMatchException first now???

MVC EntityFramework Code-First Migration is executing, but Seed not taking effect?

Answers (1)

Related Questions