logo
down
shadow

Is it possible in Entity Framework MVC application to run .sql scripts on a different database


Is it possible in Entity Framework MVC application to run .sql scripts on a different database

Content Index :

Is it possible in Entity Framework MVC application to run .sql scripts on a different database
Tag : chash , By : Henry Fatino
Date : November 22 2020, 03:01 PM

I hope this helps . Is it possible that from within my Asp.net MVC (EF) application i connect to another database, run some scripts and then close the connection. , Ok. So This is what i simply did in my controller
public class AdminController : Controller
{
    public ActionResult Install()
    {
        foreach (ConnectionStringSettings c in System.Configuration.ConfigurationManager.ConnectionStrings)
        {


                //get all files from this folder except insert and mysql create scripts and then run each of them
                string script = System.IO.File.ReadAllText(@"C:\Test.sql");
                MySqlConnection conn = new MySqlConnection(c.ConnectionString);
                try
                {
                    conn.Open();
                    MySqlScript m = new MySqlScript(conn, script);
                    m.Delimiter = "$$";
                    m.Execute();
                    conn.Close();
                }
                catch { }

        }

        return View();
    }
}

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Is Entity Framework 4.1 is the best solution for a web application that is using almost 400 database tables?


Tag : performance , By : pad
Date : March 29 2020, 07:55 AM
This might help you The number of tables only affects EF initialization where "views" must be compiled when the context is used first time in the application - 400 is a lot and it will take a lot of time. This can be speed up by generating source code for views and adding these source codes to the project - views will not be compiled at runtime because compiled code will be part of your application but you must manually do this each time you change the model. For EFv4.1 this feature is offered in EF Power Tools CTP1. For EDMX the feature is offered in EdmGen command line tool.
Another impact on such number of tables in on development. Using 400 tables in single EDMX seems impossible so you will need multiple contexts with different sets of mapped entities. This can be complex task for application architecture because working with multiple contexts makes everything harder.

.net Desktop application deployment with database in entity framework


Tag : chash , By : gcomstock
Date : March 29 2020, 07:55 AM
seems to work fine I think this is related to the connection to the database. Entity Framework checks for an existing database that you defined in the context class that inherits from DbContext. If it does not exist Entity Framework will create it locally for you in development. But when your ready to deploy your application you need to define the connection string to the database. Since your are using Entity Framework Code First I would also recommend using the Entity Framework Power tools that you can download from NuGet. You can read more on the DbContext, and setting up the models here. Entity Framework Code First Context
I would inspect this aspect of the article:
public class BloggingContext : DbContext 
{ 
    public BloggingContext() 
        : base("BloggingCompactDatabase") 
    { 
    } 
}

ASP.NET application with Oracle Database and Entity Framework 6 - Compatible Entity Framework database provider couldn't


Tag : asp.net , By : T11M
Date : March 29 2020, 07:55 AM
hop of those help? After trying all these, I recreated the solution which I used to keep model classes and now I am able to add model. Problem solved.

Entity Framework Database Connection in Single-Threaded Application


Tag : chash , By : user158193
Date : March 29 2020, 07:55 AM
this will help I have a unique (or so I think) problem - we have an ASP.NET web app using MVC principles. The project will be at most single threaded (our business requires single point of control). We are using Entity Framework to connect to the database ,
How would you recommend connecting to the database?

Entity Framework - Migrate Database from Code in ASP.NET Web Application


Tag : chash , By : Henry Fatino
Date : March 29 2020, 07:55 AM
around this issue I figured it out. The MigrationsNamespace isn't the same as the namespace of ApplicationDbContext. I had to explicitly put the namespace where all the migration files reside. Also, when instantiating the configuration, I had to include the proper context key. It works now and looks something like this:
var database = new ApplicationDbContext().Database;
        var configuration = new DbMigrationsConfiguration
        {
            TargetDatabase =
                                        new DbConnectionInfo(
                                            database.Connection.ConnectionString,
                                            "System.Data.SqlClient"),
            ContextType = typeof(ApplicationDbContext),
            MigrationsAssembly = Assembly.GetAssembly(typeof(ApplicationDbContext)),
            MigrationsNamespace = "Prom.Database.Migrations",
            ContextKey = "Prom.Database.Migrations.Configuration"
        };
Related Posts Related QUESTIONS :
  • Losing special unicode characters in encryption (C#)
  • Getting stored procedure returned value instead of row affected
  • How can I construct HTML using NameValuePair in android?
  • Loading a pop up page in ASP.net through a js file
  • How to pass alert or notification message from controller to View?
  • C# to pause, turn on ssas server, backup cube.... how to?
  • How to execute DataTable.Select() for a column of custom class type for a particular element in that C#
  • how to connect mysql8.0 with C#
  • Passing incorrect values into MultiValueConverter by MultiBinding
  • Can i use IEnumerator as Update func?
  • How to convert API Json response to C# Array?
  • Blazor Textfield Oninput User Typing Delay
  • Performing both layout and render transform results in wrong output
  • uwp beforetextchanged cursor moving in front of text
  • How to keep duplicates from a string[] exclude words from a List and print them out
  • .Net Core Strings.Asc/Mid/Chr/Len missing even after importing Microsoft.VisualBasic
  • How to return to previous search page without being asked to Confirm Form Re-submission and keeping the results on ASP.N
  • How set a identity scaffolding item/page how initial page in asp.net MVC core?
  • LINQ isn't calling Dispose on my IEnumerator when using Union and Select, expected behavior or bug?
  • What is "ByteArray.uncompress()" in AS3 equivalent to in C#?
  • Getting a specific letter from a string variable for my simple guessing game for clues
  • Send an email with Outlook without a subject --- dialog box issue
  • passing List<MyModel> from my controller in the "WebInterfaceProject" to the processor method in "D
  • How to convert Word document created from template by OpenXML into MemoryStream?
  • How can I make a single slider that changes the color of an object?
  • Remap JSON parameter in c#
  • What is the difference between "this ref" and "ref this" when talking about C# 7.2 ref extension met
  • Convert OpenSSL encryption into native C#
  • Accessing Properties in Razor Pages
  • How to get SOAP element value
  • Projection after Group
  • C# error cannot convert sytem.text.regularexpressions.match to string
  • Issues with Save/Load System in a Text Based Adventure game made with ScriptableObjects in Unity
  • VS2019 MSBuild.exe - ASP .Net MVC project fails to publish when using PublishProfile, but works when using OutDir parame
  • Does <pages validateRequest="false" /> in Web.config still matter?
  • How to send new request to redirect URL with new access token
  • Attempt to invoke virtual method on a null object reference Xamarin LockScreen
  • "The attribute names could not be inferred from bind attribute 'bind-value'" exception in Blazor
  • How to fix ''System.ArgumentException" in c#?
  • C#. Ref returning delegate for ref extension method
  • Swashbuckle Swagger generate an actual guid
  • Trying to make thousands of database calls simultaneously - they stack instead of running concurently
  • run mstest from cmd using testcontainer
  • How to make M:N (many-to-many) relationship where both M and N are the same entities?
  • Consume COM DLL from multiple clients
  • Convert json string response representing UCHAR array to Byte array
  • Why does this LinqPad program produce different results on the second run?
  • ServiceStack how to use MaxLoginAttempts feature
  • What does "late-bound access to the destination object" mean?
  • How to load appsettings.json inside a Static class based on deploy environment so that I can use in other class librarie
  • dynamically add images to view
  • Are static extension methods on User object safe?
  • Process thousands of database calls simultaneously
  • Trying to decrypt a string with public key(not private) using bouncycastle in .net
  • How to retrieve the name of an usb device
  • Query many-to-many related data using Entity Framework Core
  • ASP.NET MVC : how to find the view from a controller?
  • Inconsistent behaviour using Entity Framework for ASP.NET MVC app vs windows service
  • AutoFixture Customize vs Build
  • How to change textbox location at the click of a mouse in live mode?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com