Entity Framework migration: access sql file within ASP.NET

Question

I have a ASP.NET Web API project. I'm using Entity Framework Migrations. Currently, I have a custom script that is to be executed during a migration. I'm using the SqlFile method for this:

SqlFile(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Migrations/Scripts/MyCustomScript.sql"));

This works fine in the integration tests, IF I set the "Copy to Output Directory" of the script to "Copy always".

However, when running the website, the script is copied to <websiteroot>\bin\Migrations\MyCustomScript.sql, while AppDomain.CurrentDomain.BaseDirectory points to the websiteroot. Therefore, an error is thrown stating that the script cannot be found: it resides in the bin folder, not in the root.

How can I load the script so that things work both in the tests and in the actual website?

Peter · Accepted Answer · 2016-09-01 09:34:25Z

2

+50

I would include the script in you dll and than load the script from the dll directly. Than you do not need any if statements and you always know you have the correct scripts included. Set the build action to Embedded resource. Then you can get the script like:

Assembly assembly = Assembly.LoadFile(dll);
using (Stream stream = assembly.GetManifestResourceStream(resourcepath))
using (StreamReader reader = new StreamReader(stream))
{
    string script = reader.ReadToEnd();

answered Sep 1, 2016 at 9:34

Peter

28k8 gold badges69 silver badges85 bronze badges

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

2 Comments

fikkatra Over a year ago

I've made it into this: Assembly.GetExecutingAssembly().GetManifestResourceStream(resourceName) and closed the brackets, but otherwise: good solution!

Peter Over a year ago

Nice, it depends on where you have embedded the files. Good that this helps you!

Matthias Burger · Accepted Answer · 2016-09-01 08:05:24Z

1

I would fix it this way (it's not the best way, but it's a way)

string sqlfilepath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Migrations/Scripts/MyCustomScript.sql");
if (!File.Exists(sqlfilepath))
    sqlfilepath = "your other path where it might exist";

answered Sep 1, 2016 at 8:05

Matthias Burger

5,9747 gold badges58 silver badges110 bronze badges

Collectives™ on Stack Overflow

Entity Framework migration: access sql file within ASP.NET

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related