You&#39;re missing the following piece of code after the `connectionString` attribute (assuming that you&#39;re using SQL):

`providerName=&quot;System.Data.SqlClient&quot;`

Sometime in the future. the complete code
  

    &lt;add name=&quot;YouContext&quot; connectionString=&quot;Integrated Security=True;Persist Security Info=False;Initial Catalog=YourDatabaseName;Data Source=YourPCName;&quot; providerName=&quot;System.Data.SqlClient&quot;/&gt;
    

Go down in your web.config until you reach the `providers` tag. 
For instance, here&#39;s my providers statement:
```
&lt;providers&gt;&lt;provider invariantName=&quot;System.Data.SqlClient&quot; ... /&gt;&lt;/providers&gt;
```

you should add this `System.Data.SqlClient` as a provider name in your connection string
so your connection string should look like this:
```
  &lt;connectionStrings&gt;
 &lt;add name=&quot;ApplicationServices&quot; providerName=&quot;System.Data.SqlClient&quot; connectionString=&quot;Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True&quot;/&gt;
  &lt;/connectionStrings&gt;

```

In my case the problem was with an incorrect StartUp project target. In the PM console the target migration assembly project was correct.

I have a multiproject solution and the target was on some web-service project.

So I changed the StartUp to the main WebSite project and the migration have complited without errors.

This article sounds interesting, but I&#39;m pretty sure the diagrams are wrong.
http://guides.beanstalkapp.com/version-control/branching-best-practices.html

Shouldn&#39;t it be `DEVELOPMENT` &gt; `STAGING` &gt; `PRODUCTION`?

&gt; Merges should only flow in one direction: from feature and bug-fixes
&gt; done in their own branch or in development into staging for testing.
&gt; Once tested, you can merge those changes from development into
&gt; production.

Here I get a bit confused. So I merge Staging to Master or Master to Staging?

I&#39;m using a client called SmartGit and I get confused about this point. Normally I make a branch for a feature, commit to it, then switch to master and merge it to the branch (forward). So in this new workflow with Staging and Production, I create these two extra branches, then create a branch from master (aka dev) for my feature. Commit to it, then switch to Staging and merge (forward) to my feature branch? Does that sound correct?

---
Actually what made this so confusing is that the Beanstalk people stand behind their very non-standard use of Staging (it comes before development in their diagram, and it&#39;s not a mistake! 
https://twitter.com/Beanstalkapp/status/306129447885631488

Have decided to forget about Beanstalk and just go with Github.

---
Since I posted this, the Beanstalk people took my hint and renamed their stages, now calling Development &quot;Stable&quot;. 

git with development, staging and production branches

I have two files `index.html` and `template.html`. I moved most of `index.html` into `template.html` and now git thinks that I did a rename when I add both files. Is it possible to prevent this in specific cases?

How can I prevent git from thinking I did a rename

I use `Entity Framework Code First`,

My connection string is in a configuration file:

    &lt;connectionStrings&gt;
        &lt;clear/&gt;
        &lt;add name=&quot;ApplicationServices&quot; connectionString=&quot;Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True&quot;/&gt;
      &lt;/connectionStrings&gt;

When I try to access the data (something that should create the DB) is falling with the following error:

    

&gt; The connection string &#39;ApplicationServices&#39; in the application&#39;s
&gt; configuration file does not contain the required providerName
&gt; attribute.&quot;

What am I missing?

The connection string &#39;MyConnection&#39; in the application&#39;s configuration file does not contain the required providerName attribute.&quot;

I use <code>Entity Framework Code First</code>,
My connection string is in a configuration file:
<pre><code class="hljs language-php-template">&#x3C;connectionStrings>
 &#x3C;clear/>
 &#x3C;add name="ApplicationServices" connectionString="Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True"/>
 &#x3C;/connectionStrings>
</code></pre>
When I try to access the data (something that should create the DB) is falling with the following error:
> The connection string 'ApplicationServices' in the application's
> configuration file does not contain the required providerName
> attribute."
What am I missing?

How can I quickly remove all rows in the table using Entity Framework?

I am currently using:

```c#
var rows = from o in dataDb.Table
		   select o;
foreach (var row in rows)
{
	dataDb.Table.Remove(row);
}
dataDb.SaveChanges();
```

However, it takes a long time to execute.

Are there any alternatives?


Entity Framework. Delete all rows in table

I&#39;m using EF in my application.

I try to save\insert a new record to a mapping table

and get the following error:

`Unable to update the EntitySet &#39;UsersLimitationToCountry&#39; because it has a DefiningQuery and no &lt;InsertFunction&gt; element exists in the &lt;ModificationFunctionMapping&gt; element to support the current operation.`


Should I define it in the edmx myself? How?



because it has a DefiningQuery and no &lt;InsertFunction&gt; element exists in the &lt;ModificationFunctionMapping&gt; element

I am trying to get something like the following to work:

    _dbmsParentSections = FactoryTools.Factory.PdfSections
                            .Include(x =&gt; x.Children.OrderBy(y =&gt; y.Order).ToList())
                            .Include(x =&gt; x.Hint).Include(x =&gt; x.Fields)
                            .Where(x =&gt; x.FormId == FormId &amp;&amp; x.Parent == null)
                            .OrderBy(o =&gt; o.Order)
                            .ToList();

The part that causes the exception is:

    .Include(x =&gt; x.Children.OrderBy(y =&gt; y.Order).ToList())


**EDIT:**

 Upon further observation,

    _dbmsParentSections.ForEach(x =&gt; x.Children = x.Children.OrderBy(y =&gt; y.Order).ToList());


did the job for me (after the initial `Factory` call and without the `Children.OrderBy`).

Entity Framework (.NET Full Framework) Ordering Includes

***These are my simplified domain classes.***

```c#
public class ProductCategory
{
	public int ProductId { get; set; }
	public int CategoryId { get; set; }

	public virtual Product Product { get; set; }
	public virtual Category Category { get; set; }
}

public class Product
{
	public int Id { get; set; }
	public string Name { get; set; }
} 

public class Category
{
	public int Id { get; set; }
	public string Name { get; set; }
	public int? ParentCategoryId { get; set;} 
} 
```


***This is my mapping class. But it doesn&#39;t work.***

```c#
public class ProductCategoryMap : EntityTypeConfiguration&lt;ProductCategory&gt;
{
	public ProductCategoryMap()
	{
		ToTable(&quot;ProductCategory&quot;);
		HasKey(pc =&gt; pc.ProductId);
		HasKey(pc =&gt; pc.CategoryId);
	}
}
```

***How should I map these classes to provide, so that one product can be seen in multiple categories?***

Entity Framework Multiple Column as Primary Key by Fluent Api

What is actually the difference between:

    this.HasRequired(a =&gt; a.Something)
        .WithMany()
        .Map(a =&gt; a.MapKey(&quot;SomethingId&quot;));


and


    this.HasRequired(a =&gt; a.Something)
        .WithMany()
        .HasForeignKey(a =&gt; a.SomethingId);


MapKey vs HasForeignKey Difference - Fluent Api

I need to have one column in my database calculated by database as (sum of rows) - (sum of rowsb). I&#39;m using code-first model to create my database.

Here is what I mean:

    public class Income {
          [Key]
          public int UserID { get; set; }
          public double inSum { get; set; }
    }

    public class Outcome {
          [Key]
          public int UserID { get; set; }
          public double outSum { get; set; }
    }

    public class FirstTable {
          [Key]
          public int UserID { get; set; }
          public double Sum { get; set; } 
          // This needs to be calculated by DB as 
          // ( Select sum(inSum) FROM Income WHERE UserID = this.UserID) 
          // - (Select sum(outSum) FROM Outcome WHERE UserID = this.UserID)
    }

How can I achieve this in EF CodeFirst?

Calculated column in EF Code First

I&#39;m seeing some really strange perf related to a very simple query using Entity Framework Code-First with .NET framework version 4. The LINQ2Entities query looks like this:

     context.MyTables.Where(m =&gt; m.SomeStringProp == stringVar);

This takes over 3000 milliseconds to execute. The generated SQL looks very simple:

     SELECT [Extent1].[ID], [Extent1].[SomeStringProp], [Extent1].[SomeOtherProp],
     ...
     FROM [MyTable] as [Extent1]
     WHERE [Extent1].[SomeStringProp] = &#39;1234567890&#39;

This query runs almost instantaneously when run through Management Studio. When I change the C# code to use the SqlQuery function, it runs in 5-10 milliseconds:

     context.MyTables.SqlQuery(&quot;SELECT [Extent1].[ID] ... WHERE [Extent1].[SomeStringProp] = @param&quot;, stringVar);

So, exact same SQL, the resulting entities are change-tracked in both cases, but wild perf difference between the two. What gives?

Entity Framework query slow, but same SQL in SqlQuery is fast

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&#39;ve been wrestling with this for a while and can&#39;t quite figure out what&#39;s happening.  I have a Card entity which contains Sides (usually 2) - and both Cards and Sides have a Stage.  I&#39;m using EF Codefirst migrations and the migrations are failing with this error: 

&gt; Introducing FOREIGN KEY constraint &#39;FK_dbo.Sides_dbo.Cards_CardId&#39; on
&gt; table &#39;Sides&#39; may cause cycles or multiple cascade paths. Specify ON
&gt; DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY
&gt; constraints.

Here&#39;s my **Card** entity: 

    public class Card
    {
        public Card()
        {
            Sides = new Collection&lt;Side&gt;();
            Stage = Stage.ONE;
        }
     
        [Key]
        [Required]
        public virtual int CardId { get; set; }

        [Required]
        public virtual Stage Stage { get; set; }

        [Required]
        [ForeignKey(&quot;CardId&quot;)]
        public virtual ICollection&lt;Side&gt; Sides { get; set; }
    }

Here&#39;s my **Side** entity: 

    public class Side
    {
        public Side()
        {
            Stage = Stage.ONE;
        }

        [Key]
        [Required]     
        public virtual int SideId { get; set; } 

        [Required]
        public virtual Stage Stage { get; set; }

        [Required]
        public int CardId { get; set; }

        [ForeignKey(&quot;CardId&quot;)]
        public virtual Card Card { get; set; }

    }

And here&#39;s my **Stage** entity: 

    public class Stage
    {
        // Zero
        public static readonly Stage ONE = new Stage(new TimeSpan(0, 0, 0), &quot;ONE&quot;);
        // Ten seconds
        public static readonly Stage TWO = new Stage(new TimeSpan(0, 0, 10), &quot;TWO&quot;);

        public static IEnumerable&lt;Stage&gt; Values
        {
            get
            {
                yield return ONE;
                yield return TWO;
            }

        }

        public int StageId { get; set; }
        private readonly TimeSpan span;
        public string Title { get; set; }

        Stage(TimeSpan span, string title)
        {
            this.span = span;
            this.Title = title;
        }

        public TimeSpan Span { get { return span; } }
    }

What&#39;s odd is that if I add the following to my Stage class: 

        public int? SideId { get; set; }
        [ForeignKey(&quot;SideId&quot;)]
        public virtual Side Side { get; set; }

The migration runs successfully.  If I open up SSMS and look at the tables, I can see that `Stage_StageId` has been added to `Cards` (as expected/desired), however `Sides` contains no reference to `Stage` (not expected).  

If I then add 

        [Required]
        [ForeignKey(&quot;StageId&quot;)]
        public virtual Stage Stage { get; set; }
        public int StageId { get; set; }

To my Side class, I see `StageId` column added to my `Side` table.  

This is working, but now throughout my application, any reference to `Stage` contains a `SideId`, which is in some cases totally irrelevant.  **I&#39;d like to just give my `Card` and `Side` entities a `Stage` property based on the above Stage class without polluting the stage class with reference properties if possible**... what am I doing wrong?  

Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths - why?

I&#39;m developing a simple C# application, and I&#39;d like to know this: When I connect my application to SQL Server on my PC, I know the connection string (server name, password, etc.), but when I connect it to another PC, the SQL Server connection string is different. Is there a common account in SQL Server that comes with a default account that can connect?

I have heard about the `sa` account in SQL Server. What is `sa`?


How can I set an SQL Server connection string?

I have a web API project which references my model and DAL assemblies. The user is presented with a login screen, where he can select different databases.

I build the connection string as follows:

        public void Connect(Database database)
        {
            //Build an SQL connection string
            SqlConnectionStringBuilder sqlString = new SqlConnectionStringBuilder()
            {
                DataSource = database.Server,
                InitialCatalog = database.Catalog,
                UserID = database.Username,
                Password = database.Password,
            };

            //Build an entity framework connection string
            EntityConnectionStringBuilder entityString = new EntityConnectionStringBuilder()
            {
                Provider = database.Provider,
                Metadata = Settings.Default.Metadata,
                ProviderConnectionString = sqlString.ToString()
            };
        }

First of all, how do I actually change the connection of the data context?

And secondly, as this is a web API project, is the connection string (set at login per above) persistent throughout the user&#39;s interaction or should it be passed every time to my data context?

Entity Framework change connection at runtime

I can invoke `psql` like this:

    psql postgres://...

How can I use `pg_dump` with a connection string in the format `postgres://...`?  
Would be more convenient than breaking URI&#39;s into host, post, username, password.

Is there syntax for this?

How to use pg_dump with a connection uri / url?

For the properties:

    Persist Security Info=true

and

    Persist Security Info=false

Can you tell me what is the difference between them, and if I don&#39;t put it in my connection what will happen?

    connect.ConnectionString = &quot;Provider=Microsoft.ACE.OLEDB.12.0;
                                Data Source=C:/Users/Nourah/Downloads 
                                /Phase3/Salary.accdb; 
                                Persist Security Info=False;&quot;;

Persist Security Info Property=true and Persist Security Info Property=false

I want to read just a connection string from a configuration file and for this add a file with the name &quot;appsettings.json&quot; to my project and add this content on it:

    {
    &quot;ConnectionStrings&quot;: {
      &quot;DefaultConnection&quot;: &quot;Server=(localdb)\\mssqllocaldb;Database=aspnet-

     WebApplica71d622;Trusted_Connection=True;MultipleActiveResultSets=true&quot;
      },
        &quot;Logging&quot;: {
        &quot;IncludeScopes&quot;: false,
        &quot;LogLevel&quot;: {
        &quot;Default&quot;: &quot;Debug&quot;,
        &quot;System&quot;: &quot;Information&quot;,
        &quot;Microsoft&quot;: &quot;Information&quot;
       }
     }
    }

On ASP.NET I used this:

     var temp=ConfigurationManager.ConnectionStrings[&quot;DefaultConnection&quot;].ConnectionString;

Now how can I read &quot;DefaultConnection&quot; in C# and store it on a string variable in .NET Core?


Content Type	Original Author	Original Content on Stackoverflow
Question	Hodaya Shalom	View Question on Stackoverflow
Solution 1 - Entity Framework	Corey Adler	View Answer on Stackoverflow
Solution 2 - Entity Framework	Krishneil	View Answer on Stackoverflow
Solution 3 - Entity Framework	Ahmad Hamed	View Answer on Stackoverflow
Solution 4 - Entity Framework	Kamerton	View Answer on Stackoverflow

The connection string 'MyConnection' in the application's configuration file does not contain the required providerName attribute."

Entity Framework Problem Overview

Entity Framework Solutions

Solution 1 - Entity Framework

Solution 2 - Entity Framework

Solution 3 - Entity Framework

Solution 4 - Entity Framework

How can I prevent git from thinking I did a rename

git with development, staging and production branches

Attributions