The API appears to have changed (or at least, it doesn&#39;t work for me).

Running the following in the Package Manager Console works as expected:

    Update-Database -Script -SourceMigration:0

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-Migration -To 20190101021200_Migration-2

https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/#generate-sql-scripts


&gt; There are several options to this command.
&gt;
&gt; The **from** migration should be the last migration applied to the database before running the script. If no migrations have been applied, specify `0` (this is the default).
&gt;
&gt; The **to** migration is the last migration that will be applied to the database after running the script. This defaults to the last migration in your project.
&gt;
&gt; An **idempotent** script can optionally be generated. This script only applies migrations if they haven&#39;t already been applied to the database. This is useful if you don&#39;t exactly know what the last migration applied to the database was or if you are deploying to multiple databases that may each be at a different migration.

To add to Matt wilson&#39;s answer I had a bunch of code-first entity classes but no database as I hadn&#39;t taken a backup.  So I did the following on my Entity Framework project:

Open Package Manager console in Visual Studio and type the following:

    Enable-Migrations

    Add-Migration

Give your migration a name such as &#39;Initial&#39; and then create the migration.  Finally type the following:

    Update-Database

    Update-Database -Script -SourceMigration:0

The final command will create your database tables from your entity classes (provided your entity classes are well formed).

I have a table in `PostgreSQL 8.3` with 2 `timestamp` columns. I would like to get the difference between these `timestamps` in seconds. Could you please help me how to get this done?

    TableA
    (
      timestamp_A timestamp,
      timestamp_B timestamp
    )

I need to get something like `(timestamo_B - timestamp_A)` in seconds *(not just the difference between seconds, it should include hours, minutes etc)*.

Find difference between timestamps in seconds in PostgreSQL

I am currently using the below function to create text that will be displayed using Bootstrap’s tooltip plugin. How come multiline tooltips only work with `&lt;br&gt;` and not `\n`? I prefer that there is not any HTML in my links’ title attributes.

What works

    def tooltip(object)
      tooltip = &quot;&quot;
      object.each do |user|
        tooltip += &quot;#{user.identifier}&quot; + &quot;&lt;br&gt;&quot;
      end
      return tooltip
    end

What I want

    def tooltip(object)
       tooltip = &quot;&quot;
       object.each do |user|
         tooltip += &quot;#{user.identifier}&quot; + &quot;\n&quot;
       end
       return tooltip
     end

How to make Twitter Bootstrap tooltips have multiple lines?

How do I use Entity Framework 5 Code First Migrations to create a full database script from the initial (empty) state to the latest migration?

The blog post at [MSDN Blog][1] suggests to do this, but it seems to create an empty script:

    Update-Database -Script -SourceMigration: $InitialDatabase

  [1]: http://msdn.microsoft.com/en-us/data/jj591621.aspx

Generate full SQL script from EF 5 Code First Migrations

How do I use Entity Framework 5 Code First Migrations to create a full database script from the initial (empty) state to the latest migration?
The blog post at <a href="http://msdn.microsoft.com/en-us/data/jj591621.aspx" target="_blank" rel="noopener noreferrer">MSDN Blog</a> suggests to do this, but it seems to create an empty script:
<pre><code class="hljs language-bash">Update-Database -Script -SourceMigration: $InitialDatabase
</code></pre>

I am trying to run my tests on TeamCity which is currently installed on my machine.

&gt; `System.InvalidOperationException`: 
&gt; 
&gt; The Entity Framework provider type
&gt; &#39;`System.Data.Entity.SqlServer.SqlProviderServices,
&gt; EntityFramework.SqlServer`, `Version=6.0.0.0, Culture=neutral,
&gt; PublicKeyToken=b77a5c561934e089&#39;` for the &#39;`System.Data.SqlClient`&#39;
&gt; ADO.NET provider could not be loaded. Make sure the provider assembly
&gt; is available to the running application. 
&gt; 
&gt; See http://go.microsoft.com/fwlink/?LinkId=260882 for more
&gt; information..

I have no reference to `System.Data.Entity` in any of my projects as was suggested on codeplex for upgrading to EF6.

So, I am not sure why am I getting this exception.
I do not get any such exception when I run the tests from VS.

I did try to set CopyLocal to false then again to true.. but that does not seem to work either.

Update 

My app.config has the following . Does this cause some behavior that I don&#39;t understand ?

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
    &lt;configuration&gt;
      &lt;configSections&gt;
        &lt;section name=&quot;entityFramework&quot; type=&quot;System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&quot; requirePermission=&quot;false&quot; /&gt;
        &lt;!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --&gt;
      &lt;/configSections&gt;
      &lt;entityFramework&gt;
        &lt;defaultConnectionFactory type=&quot;System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework&quot; /&gt;
      &lt;/entityFramework&gt;
    &lt;/configuration&gt;


I get the following stacktrace in teamcity .


    [MSTest] IntegrationTests.CrudTest+QuestionTest.Create
    [03:59:11][IntegrationTests.CrudTest+QuestionTest.Create] Initialization method IntegrationTests.CrudTest+QuestionTest.Initialize threw exception. System.InvalidOperationException: System.InvalidOperationException: The Entity Framework provider type &#39;System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089&#39; for the &#39;System.Data.SqlClient&#39; ADO.NET provider could not be loaded. Make sure the provider assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information..
    [03:59:11]
    [IntegrationTests.CrudTest+QuestionTest.Create]     at System.Data.Entity.Config.ProviderServicesFactory.GetInstance(String providerTypeName, String providerInvariantName)
       at System.Data.Entity.Config.ProviderServicesFactory.GetInstanceByConvention(String providerInvariantName)
       at System.Data.Entity.Config.DefaultProviderServicesResolver.GetService(Type type, Object key)
       at System.Data.Entity.Config.CachingDependencyResolver.&lt;&gt;c__DisplayClass1.&lt;GetService&gt;b__0(Tuple`2 k)
       at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
       at System.Data.Entity.Config.CachingDependencyResolver.GetService(Type type, Object key)
       at System.Data.Entity.Config.ResolverChain.&lt;&gt;c__DisplayClass3.&lt;GetService&gt;b__0(IDbDependencyResolver r)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
       at System.Data.Entity.Config.ResolverChain.GetService(Type type, Object key)
       at System.Data.Entity.Config.RootDependencyResolver.GetService(Type type, Object key)
       at System.Data.Entity.Config.ResolverChain.&lt;&gt;c__DisplayClass3.&lt;GetService&gt;b__0(IDbDependencyResolver r)
       at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
       at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
       at System.Data.Entity.Config.ResolverChain.GetService(Type type, Object key)
       at System.Data.Entity.Config.CompositeResolver`2.GetService(Type type, Object key)
       at System.Data.Entity.Config.IDbDependencyResolverExtensions.GetService[T](IDbDependencyResolver resolver, Object key)
       at System.Data.Entity.Config.InternalConfiguration.GetService[TService](Object key)
       at System.Data.Entity.Config.DbConfiguration.GetService[TService](Object key)
       at System.Data.Entity.Utilities.DbProviderFactoryExtensions.GetProviderServices(DbProviderFactory factory)
       at System.Data.Entity.Infrastructure.DefaultManifestTokenService.GetProviderManifestToken(DbConnection connection)
       at System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest&amp; providerManifest)
       at System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
       at System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
       at System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
       at System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
       at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
       at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
       at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
       at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName)
       at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity)
       at System.Data.Entity.DbSet`1.Add(TEntity entity)
       at EFRepository.Infrastructure.EFRepository`1.Add(T item) in c:\TeamCity\buildAgent\work\da2ea4e72c0e77f0\Repository\Infrastructure\EFRepository.cs:line 22
       at IntegrationTests.CrudTest.Initialize() in c:\TeamCity\buildAgent\work\da2ea4e72c0e77f0\IntegrationTests\CrudTest.cs:line 34

Entity Framework Provider type could not be loaded?

I always used Repository pattern but for my latest project I wanted to see if I could perfect the use of it and my implementation of “Unit Of Work”. The more I started digging I started asking myself the question: **&quot;Do I really need it?&quot;**

Now this all starts with a couple of comments on Stackoverflow with a trace to Ayende Rahien&#39;s post on his blog, with 2 specific,

* &lt;a href=&quot;http://ayende.com/blog/3955/repository-is-the-new-singleton&quot;&gt;repository-is-the-new-singleton&lt;/a&gt;
* &lt;a href=&quot;http://ayende.com/blog/153701/ask-ayende-life-without-repositories-are-they-worth-living&quot;&gt;ask-ayende-life-without-repositories-are-they-worth-living&lt;/a&gt;

This could probably be talked about forever and ever and it depends on different applications. Whats I like to know,

1. would this approach be suited for a Entity Framework project?
2. using this approach is the business logic still going in a service layer, or extension methods (as explained below, I know, the extension method is using NHib session)?



**That&#39;s easily done using extension methods. Clean, simple and reusable.**


    public static IEnumerable GetAll(
        this ISession instance, Expression&lt;Func&lt;T, bool&gt;&gt; where) where T : class
    {
        return instance.QueryOver().Where(where).List();
    }

Using this approach and `Ninject` as DI, do I need to make the `Context` a interface and inject that in my controllers?

NOT using repository pattern, use the ORM as is (EF)

I&#39;ve just started working with the Entity framework and I&#39;m confused about how the classes normally in the business layer fit in with the entities that are created by the Entity Framework.

When working with classic ADO.NET, I would have a class called Customer for example and then another class called DALCustomer to handle database interaction, in this structure I would have put the code to do calculations, filtering and delcare an instance of the DAL withing Customer for saving, updating and deleting in the Customer class.

With the Entity Framework, if you have a table called Customer, the Entity framework creates an entity called Customer and this is where my confusion begins, does this entity remove the need for a Customer in the business layer? So in essence all the fields and methods that normally go in the business layer go in the entity generated by the Entity Framework?  Or should a class still exist in the business layer called CustomerBL for example, that still contains the fields and methods needed to accomplish the business logic required for calculations, filtering and still needs an instance of the EF DAL declared to handle data access?

If there should be a business class, in this case CustomerBL, one other question jumps to mind, should the fields that are created in the customer entity be recreated in CustomerBL or should an instance of the Customer entity be declared in CustomerBL so there would be no need to have the fields declared in 2 locations?


Confusion about where to put business logic when using Entity framework

In my APP I&#39;m using an API of a software that my tool is managing. I&#39;ve DAL that contain 16 classes, 3 of them are singletons. I&#39;ve some logic in the `.cs` files and `XAML`&#39;s off course. 

My question is, I see a lot of comments that an app written in WPF should use MVVM, and this will make the code more usable and readable, can I transform my code to be MVVM? what it the actual meaning of MVVM (not Wikipedia or manual definition)? 

I also use SQL queries and I read a paper about EF (Entity Framework), can MVVM and EF  coexist together in the same project?

WPF Programming Methodology

I have a code-first entity model in EF5. But I want to manage the database changes manually -- I do not want EF to modify my existing database and all its data. But when I make parallel changes in the EF mapping and in the database, EF refuses to operate properly telling me I need to use code first migration.  How do I turn this off?

How can I disable code first migrations

I&#39;ve a table named `EducationTypes` and an Entity named `EducationType`, I renamed one of entity properties, now I&#39;m frequently getting `Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong`. How can I solve this issue?

The generated SQL Script:

    EXECUTE sp_rename @objname = N&#39;dbo.EducationTypes.nvarchar&#39;, @newname = N&#39;EducationTypeTitle&#39;, @objtype = N&#39;COLUMN&#39;

EF CodeFirst: Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong

I am using EF Code First with EF 5 in VS 2012. I use PM `update-database` command and I have a simple seed method to fill some tables with sample data.

I would like to delete and recreate my x.mdb. The update history seems to be out of sync. If I comment out all my DBSets in my context, `update-database` runs with no error but leaves some tables in the DB. As I have no valuable data in the DB it seems to the simplest to reset the all thing.

How can I accomplish this?

How to delete and recreate from scratch an existing EF Code First database

I have 4 projects : 

    Toombu.Entities : all models are there
    Toombu.DataAccess: Mapping, Repository and ToombuContext
    Toombu.Logique : Logic of my application
    Toombu.Web : MVC 4 application. With all others DLL.

I tried to enable migration in **Toombu.Web** but i had this error :

    No context type was found in the assembly

How can I enable migration ?

EF 5 Enable-Migrations : No context type was found in the assembly

Here&#39;s what I am looking at

    PM&gt; Add-Migration AddedSubdivion -StartUpProjectName Data -Verbose
    Using StartUp project &#39;Data&#39;.
    Using NuGet project &#39;Registry&#39;.
    Could not load assembly &#39;Registry&#39;. (If you are using Code First Migrations inside 
    Visual Studio this can happen if the startUp project for your solution does not 
    reference the project that contains your migrations. You can either change the startUp 
    project for your solution or use the -StartUpProjectName parameter.)

I have no idea why it&#39;s trying to reference the `Registry` project. `Registry` depends on `Data`, not the other way around. I am very new to this, so I&#39;d appreciate any help. 

add-migration causing a &quot;Could not load assembly&quot; error

I&#39;m using Entity Framework code first in my website and I&#39;m just wondering if there is any way to debug the migration codes. You know, like setting breakpoints and stuff like this. 

I&#39;m using Package Manager Console to update the database using `Update-Database`.

Thanks

Content Type	Original Author	Original Content on Stackoverflow
Question	Matt Wilson	View Question on Stackoverflow
Solution 1 - Entity Framework	Matt Wilson	View Answer on Stackoverflow
Solution 2 - Entity Framework	Justin Lessard	View Answer on Stackoverflow
Solution 3 - Entity Framework	Trevor	View Answer on Stackoverflow

Generate full SQL script from EF 5 Code First Migrations

Entity Framework Problem Overview

Entity Framework Solutions

Solution 1 - Entity Framework

Solution 2 - Entity Framework

Solution 3 - Entity Framework

How to make Twitter Bootstrap tooltips have multiple lines?

Find difference between timestamps in seconds in PostgreSQL

Attributions