Data not populating database with test class DBInitializerRSS

• • Reply
  TopTony

  None

  0 Points

  1 Post

  Data not populating database with test class DBInitializer

  May 06, 2018 07:36 AM|TopTony|LINK

  <div class="votecell post-layout--left"> <div class="vote">0down votefavorite <div class="favoritecount"></div> </div> </div> <div class="postcell post-layout--right"> <div class="post-text" itemprop="text">

  Hi I am creating a database for use with EntityFramework using code first approach. I can get the database to create itself but my Dbinitializer is not populating the MSSQL database with test data. I have run through the debugger and am not finding any exceptions thrown.

  This one of the DB table classes.

  namespace FlightBooking.Models
  
  {
   public enum State { SA, WA, VIC, NSW, QLD, NT, TAS, ACT }
  
  public class Customer
  {
      public int ID { get; set; }
      public string FirstName { get; set; }
      public string LastName { get; set; }
      public string LoginID { get; set; }
      public string LoginPassword { get; set; }
  
      public string ContactNumber { get; set; }
      public string PassPortNum { get; set; }
      public string StreetNumber { get; set; }
      public string StreetName { get; set; }
      public string Suburb { get; set; }
      public State? State { get; set; }
  
  
  
      public ICollection<Booking> Bookings { get; set; }
  }

  }

  This is part of the test data class.

      public class DbInitializer
  {
      public static void Initialize(FlightSystemContext context)
      {
          context.Database.EnsureCreated();
  
          //Look for any customers
          if (context.Customers.Any())
          {
              return;
          }
  
          var customers = new Customer[]
          {
              new Customer {ID=1,FirstName="Robert", LastName="Peters", LoginID="RPeters", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000001", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.SA},
              new Customer { ID=2,FirstName="Sam", LastName="Alexander", LoginID="SamAlexander", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000002", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.NSW},
              new Customer { ID=3, FirstName="Tom", LastName="Alexander", LoginID="TAlexander", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000003", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.TAS}
          };
  
          foreach (Customer c in customers)
          {
              context.Customers.Add(c);
          }
          context.SaveChanges();

  I am finding that the EntityFrameworkcore is throwing an error some how . But can not work out why?

  </div> </div>
• • Reply
  Brando ZWZ

  Star

  8931 Points

  2723 Posts

  Re: Data not populating database with test class DBInitializer

  May 07, 2018 05:35 AM|Brando ZWZ|LINK

  Hi TopTony,

  TopTony

  Hi I am creating a database for use with EntityFramework using code first approach. I can get the database to create itself but my Dbinitializer is not populating the MSSQL database with test data. I have run through the debugger and am not finding any exceptions thrown.

  According to your codes, I have created a test demo  on my side.

  I have below error when running Initialize method.

  SqlException: Cannot insert explicit value for identity column in table 'Customers' when IDENTITY_INSERT is set to OFF.

  As far as I know, the ef core will enable IDENTITY_INSERT for the id column.

  I suggest you could try below codes:

      public class DbInitializer
      {
          public static void Initialize(FlightSystemContext context)
          {
              context.Database.EnsureCreated();//if db is not exist ,it will create database .but ,do nothing .
  
              //Look for any customers
              if (context.Customers.Any())
              {
                  return;
              }
  
              var customers = new Customer[]
              {
              new Customer {FirstName="Robert", LastName="Peters", LoginID="RPeters", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000001", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.SA},
              new Customer { FirstName="Sam", LastName="Alexander", LoginID="SamAlexander", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000002", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.NSW},
              new Customer {  FirstName="Tom", LastName="Alexander", LoginID="TAlexander", LoginPassword="Test1234",
              ContactNumber="0404123123", PassPortNum="PPN000003", StreetNumber="12", StreetName="Smith Street", Suburb="Boowhap", State=State.TAS}
              };
  
              foreach (Customer c in customers)
              {
                  context.Customers.Add(c);
              }
              context.SaveChanges();
          }
      }

  Best Regards,

  Brando