Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Depends on the version of EF you are using. Even with migrations the result that you will see is something like:</p> <p>"drop column Id " and "add column TeamId".</p> <p>With this you will lose all values and "child connections"...... </p> <p>The only "secure" solution I am seeing at this point is a mix of Migrations and "hand SQL operations".</p> <p>EASY solution:</p> <p>1- taking in consideration that you already have a "base" migration creating the table with ID, now create the new migration with the "update". Now do NOT run it yet. </p> <p>2- Open that file and write a new line BEFORE the generated lines and use a SQL command, something like this:</p> <pre><code> SQL("ALTER TABLE table_name RENAME COLUMN old_name to new_name;"); </code></pre> <p>This will change the name BEFORE the migration deletes the column and create a new one, what will happen is: you change the name before the delete, then the delete is executed but it will "fail" but it will not hurt nothing. </p> <p>But now you ask: why do I do this? well if you are using migrations even if you delete the lines to delete the column and create a new one, the next time you create automatically a new migration file this new lines will be there...... this is why.</p> <p><strong>UPDATED ANSWERS #1</strong></p> <p>When I talk about Entity Framework Migrations I am referring to this: <a href="http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx" rel="noreferrer">http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx</a> When you Run the ‘Add-Migration AddBlogUrl’ command in Package Manager Console, a new file (*.cs) is created.</p> <p>Example of this file migration file with SQL commands:</p> <pre><code>public partial class AddAbsencesTypesAndCategories : DbMigration { public override void Up() { CreateTable( "pvw_AbsenceType", c =&gt; new { Id = c.Int(nullable: false, identity: true), Name = c.String(nullable: false), CountAsVacation = c.Boolean(nullable: false), IsIncremental = c.Boolean(nullable: false), }) .PrimaryKey(t =&gt; t.Id); ..... AddColumn("pvw_Absence", "CategoryId", c =&gt; c.Int(nullable: false)); AddForeignKey("pvw_Absence", "StatusId", "pvw_AbsenceStatusType", "Id"); AddForeignKey("pvw_Absence", "CategoryId", "pvw_AbsenceType", "Id"); CreateIndex("pvw_Absence", "StatusId"); CreateIndex("pvw_Absence", "CategoryId"); DropColumn("pvw_Absence", "MainCategoryId"); DropColumn("pvw_Absence", "SubCategoryId"); ...... Sql(@" SET IDENTITY_INSERT [dbo].[pvw_AbsenceStatusType] ON INSERT pvw_AbsenceStatusType (Id, Name) VALUES (1, N'Entwurf') SET IDENTITY_INSERT [dbo].[pvw_AbsenceStatusType] OFF "); ..... } public override void Down() { ........ } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to Change the name of a primary key in EF Code First?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDryadwoods
    1. USDryadwoods
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to Change the name of a primary key in EF Code First?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI can get this idea to work, in statement 2 when you say open that file, what file are you referring to? Nomarlly i would run that SQL statement in SQL Server Management Studio but it doesn't seem to find my intended database.
      singulars
      1. PO
      1. USKomengem
    2. COWhen I talk about Entity Framework Migrations I am referring to this: http://blogs.msdn.com/b/adonet/archive/2012/02/09/ef-4-3-code-based-migrations-walkthrough.aspx When you Run the ‘Add-Migration AddBlogUrl’ command in Package Manager Console, a new file (*.cs) is created.
      singulars
      1. PO
      1. USDryadwoods
    3. CONot sure EF5 creates this file because i can't find, unless i am supposed to create it myself. EF5 creates a Configuration.cs in the Migration folder. This file has an internal sealed class which has its pconstructor and a seed method.
      singulars
      1. PO
      1. USKomengem
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload