Can we run SQL script using code first migrations?

asp.net-mvc asp.net-mvc-4 c# entity-framework sql-server

Question

Can we run sql script using code first migrations?

I am new to code first and if I want to save my changes to a SQL script file before update-database command of migration, is it possible?

If possible then please provide steps to get it done. Also if script is generated then is it possible that I can run that script using migration?

1
47
9/21/2018 1:04:24 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

First you need to create a migration.

Add-Migration RunSqlScript

Then in the generated migration file you can write your SQL.

// PLAIN SQL
Sql("UPDATE dbo.Table SET Created = GETDATE()");

// FROM FILE
var sqlFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Custom.sql"); 
Sql(File.ReadAllText(sqlFile));

Then you run

Update-Database
76
8/20/2015 8:05:15 PM

Related Questions

Generate full SQL script from EF 5 Code First Migrations

For anyone using entity framework core ending up here. This is how you do it....# Powershell / Package manager console Script-Migration # Cli dotnet ef migrations script ...You can use the ...-From... and ...-To... parameter to generate an update script to update a database to a specific version. ...Script-Migration -From 20190101011200_Initial-M...
ef-migrations entity-framework
asked by Justin Lessard

Error deploying to SQL Azure using EF 6 alpha3 Code First and Migrations creating __MigrationHistory table

This is a ...bug... in Alpha 3 - Sorry for the inconvenience....There is a pretty easy workaround:...1) Create a custom migration SQL generator:...public class AzureSqlGenerator : SqlServerMigrationSqlGenerator { protected override void Generate(CreateTableOperation createTableOperation) { if ((createTableOperation.PrimaryKey != nul...
azure-sql-database entity-framework entity-framework-6
asked by Andrew Peters

EF 5, Code First - Create a new database and run all migrations programatically

Just remove the "create database" step and use the migrations on their own. I put a sample project on ...GitHub..., but the important bit is...Configuration config = new Configuration(); DbMigrator migrator = new DbMigrator(config); foreach (string s in migrator.GetPendingMigrations()) { migrator.Update(s); }
c# ef-migrations entity-framework
asked by mike mckechnie

EF Code Frirst: Before you update your database using Code First Migrations,

Bool param throwIfV1Schema throws exception that asp.net Identity model has been changed (updated to new version 2)....Change your IdentityDbContext constructor for one time migration:...public YourDbContext() : base("YourConnectionString", throwIfV1Schema:false){}
asp.net-identity entity-framework
asked by Arvis

Can't run code first migrations using migrate.exe

Those of us just starting to use this tool might find this PowerShell script useful - it contains some default values for some common use cases:...Param( [string]$DbConnectionString, [string]$StartUpDirectory, [string]$DataModelDllName, [string]$StartUpConfigurationFile = "$StartUpDirectory\$DataModelDllName.config", [string]$Co...
c# code-first entity-framework
asked by Ash Saf

Run Code First Migration Seed Method without a migration

If you just need to run ...Seed()... again, and nothing has changed that would cause a new migration to be added, just call ...Update-Database... again with no flags and it will say 'No pending migrations', and run ...Seed()... again for you. ...Seed()... is called every time the DB is updated, regardless if there are new migrations or not.
ef-code-first entity-framework
asked by DrewJordan

How to use EF code first migration to generate scripts from powershell

Figured out that migrate.exe is wrapping the ...toolingfacade... class So I created the object passing in the required variables as well as setting the verbosedelegate. The nice thing about this is that I could run the updatescript function instead if I just wanted to get the sql scripts...[Reflection.Assembly]::LoadFrom("EntityFramework.dll") | Ou...
entity-framework-6
asked by Tarig

Entity Framework Code-First: Generate SQL script with 'Update-Database' produces XML error while parsing

I normally use a command like:...Update-Database -Script -SourceMigration:"201502201618119_Migrations17" -TargetMigration:"201503031134340_Migrations18" ...and then run the resultant script on the server. ...SourceMigration... is the last entry in the ...__MigrationHistory... table on the server....The other 'trick' I use with mig...
c# ef-code-first ef-migrations entity-framework
asked by Peter Smith

Generate SQL script to Seed initial data with Entity Framework v6.1 Code First

Assuming you have a database that is already seeded, there is an export capability (data only) in SSMS that allows you to create a script of seed data. There is a good article here. (...https://keyholesoftware.com/2016/12/12/creating-a-sql-database-project-for-isolated-development/...)...The premise is to use a pre-seeded database as a model. Thi...
deployment ef-code-first entity-framework-6 sql-server
asked by Jamie

Using multiple SQL statements in EF migration - how to use GO to run in SSMS?

I found an odd fix to this problem:...GO --any arbitrary comment here GO ...My guess is that EF will remove ...GO... from the end of a ...Sql()... call:...Sql(@" --actual SQL here GO"); ...Including the arbitrary comment seems to mean that only the final ...GO... is removed, but the initial one is kept. This works for me regardless of whether I run...
ef-migrations entity-framework-6 sql-server
asked by Tim

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow