//add some random rows to table1
        public void PopulateTable1(string clientCode)
        {
            using (var context = new MigrationDbEntities())
            {

                var table = new Table1();

                table.col2 = RandomString(20) + clientCode;
                table.col2 = RandomString(20) + clientCode;
                table.col3 = RandomString(20) + clientCode;
                table.col4 = RandomString(20);
                table.col5 = RandomString(20);
                table.col6 = RandomString(20);
                table.col7 = RandomString(20);
                table.col8 = RandomString(20);
                table.col9 = RandomString(20);
                table.col10 = RandomString(20);
                table.col11 = RandomString(20);
                table.col12 = DateTime.Now;

                context.AddToTable1(table);
                context.SaveChanges();
            }
        }
 /// <summary>
 /// Create a new Table1 object.
 /// </summary>
 /// <param name="col1">Initial value of the col1 property.</param>
 public static Table1 CreateTable1(global::System.Int32 col1)
 {
     Table1 table1 = new Table1();
     table1.col1 = col1;
     return table1;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the Table1 EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToTable1(Table1 table1)
 {
     base.AddObject("Table1", table1);
 }