Raw query to add/alter column of table using Entity Framework without migration

Question

I have restricted access to SQL server database & I have to alter table from my MVC project. I have tried:

var db = MyDbContext.Create();
try
{
    var res =
    db.Speakers.SqlQuery("ALTER TABLE [dbo].[Speakers] ADD [LastName] [nvarchar](256) NULL");
}
catch (Exception exception)
{
    Console.WriteLine(exception);
}

its not throwing exception but not updating table. I have no idea whether Raw query allow alteration or not. But I just gave a try. Can any one tell how can I alter database?

Slava Utesinov · Accepted Answer · 2016-05-23 16:48:45Z

1

Try this approach:

    db.Database
.ExecuteSqlCommand("ALTER TABLE [dbo].[Speakers] ADD [LastName] [nvarchar](256) NULL");

edited May 23, 2016 at 16:48

answered May 23, 2016 at 9:35

Slava Utesinov

13.5k2 gold badges22 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul · Accepted Answer · 2016-05-23 09:33:49Z

1

Non-query commands can be sent to the database using the ExecuteSqlCommand method on Database. For example:
using (var context = new BloggingContext()) 
{ 
    context.Database.ExecuteSqlCommand( 
        "UPDATE dbo.Blogs SET Name = 'Another Name' WHERE BlogId = 1"); 
}
Note that any changes made to data in the database using ExecuteSqlCommand are opaque to the context until entities are loaded or reloaded from the database.

Entity Framework Raw SQL Queries https://msdn.microsoft.com/en-gb/data/jj592907.aspx

answered May 23, 2016 at 9:33

Paul

4,2991 gold badge19 silver badges15 bronze badges

Collectives™ on Stack Overflow

Raw query to add/alter column of table using Entity Framework without migration

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related