According to [Relationships/Associations with the EF Designer][1], the steps to create a foreign key association are:

&gt; 1. Right-click an empty area of the design surface, point to Add New, and select Association….
&gt; 2. Fill in the settings for the association in the Add Association dialog.

...being sure to check the *Add foreign key properties to the &lt;entity type name&gt; Entity* checkbox when filling in the relationship details.

See also: [Relationships, Navigation Properties, and Foreign Keys][2]


  [1]: https://msdn.microsoft.com/en-us/data/jj713299.aspx
  [2]: http://msdn.microsoft.com/en-us/data/jj713564.aspx

If you are using the database first approach, it&#39;s better to create the foreign key on the database and update the model. Of course, this is true if you can modify the database; if not, you&#39;re stuck with the option of creating the referential constraint on the model.

To answer the bonus question: 

If you have SQL Management Studio installed then you can very easily use the Database Migration wizard (right click on a database, &quot;Tasks&quot;, &quot;Deploy Database to SQL Azure&quot;) and from there fill the textboxes with the required information that you get from Azure.

Also, make sure to add your IP to the ignore list in Azure or else you won&#39;t be able to upload. This can be done in the Azure webportal.


If a variable of reference type is captured in a lambda by value, is the referenced object copied or is it captured by reference?

Small sample with question:

    #include &lt;iostream&gt;
    
    struct Test {
      int a;
    };
    
    void testFunc(const Test &amp;test) {
      auto a = [=] {
        // is &#39;test&#39; passed to closure object as a copy
        // or as a reference?
        return test.a;
      } ();
      std::cout &lt;&lt; a;
    }
    
    int main() {
      Test test{1};
      testFunc(test);
    }


In a lambda, does a by-value capture of a reference copy the underlying object?

(ASP.NET MVC 5, EF6, VS2013)

I&#39;m trying to figure out how to **change the type of the &quot;Id&quot; field from string to int** in the type:

    Microsoft.AspNet.Identity.EntityFramework.IdentityUser

in order to have new user accounts be associated with an integer ID rather than a GUID. But it seems like this will be more complicated than simply adding a new Id property with type int in my derived user class. Take a look at this method signature:

(from Assembly Microsoft.AspNet.Identity.Core.dll)

    public class UserManager&lt;TUser&gt; : IDisposable where TUser : global::Microsoft.AspNet.Identity.IUser
      {
      ...
      public virtual Task&lt;IdentityResult&gt; AddLoginAsync(string userId, UserLoginInfo login);
      ...
      }

So it seems that there are other methods baked into the ASP.NET identity framework which require the userId to be a string. Would I need to reimplement these classes as well?

**An explanation of why I don&#39;t want to store GUIDs for ids in the user table:**

-There will be other tables that relate data to the users table via a foreign key. (When users save content on the site.) I see no reason to use the larger field type and spend extra database space with no clear advantages. (I know that there are other posts about using GUIDs vs int ids, but it seems like many suggest that int ids are faster and use less space, which still leaves me wondering.)

-I plan to expose a restful endpoint to allow users to retrieve data about a particular user. I think:

    /users/123/name

is cleaner than

    /users/{af54c891-69ba-4ddf-8cb6-00d368e58d77}/name

Does anyone know why the ASP.NET team decided to implement IDs this way? Am I being short sighted in trying to change this to an int type? (Perhaps there are benefits I&#39;m missing.)

Thanks...

-Ben

How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser

[Click here](https://stackoverflow.com/questions/5542864/how-should-i-declare-foreign-key-relationships-using-code-first-entity-framework#5543702) to see how to do it while using a code first approach. Below the original database first approach question and answer.

I am using Entity Designer to create a database first model. Now I want to create a foreign key relationship between ProductId and ProductId (see below). I looked at the &quot;add new association&quot; but I cannot connect the two items. Can someone more experienced tell me how to accomplish this?

![foreign key](http://i.imgur.com/DxkdFij.png)


How to add foreign key relationship in Entity Framework?

<a href="https://stackoverflow.com/questions/5542864/how-should-i-declare-foreign-key-relationships-using-code-first-entity-framework#5543702" target="_blank" rel="noopener noreferrer">Click here</a> to see how to do it while using a code first approach. Below the original database first approach question and answer.
I am using Entity Designer to create a database first model. Now I want to create a foreign key relationship between ProductId and ProductId (see below). I looked at the "add new association" but I cannot connect the two items. Can someone more experienced tell me how to accomplish this?
<img src="http://i.imgur.com/DxkdFij.png" alt="foreign key">

Sql server table:

    SomeId PK varchar(50) not null 
    OtherId PK int not null


How should I map this in EF 6 code first?


    public class MyTable
    {
        [Key]
        public string SomeId { get; set; }
    
    	[Key]
        public int OtherId { get; set; }
    }


I&#39;ve seen some examples where you have to set the order for each column, is that required?

Is there official documentation on this somewhere?

Mapping composite keys using EF code first

A default MVC 5 App comes with this piece of code in IdentityModels.cs - this piece of code is for all the ASP.NET Identity operations for the default templates:

    public class ApplicationDbContext : IdentityDbContext&lt;ApplicationUser&gt;
    {
        public ApplicationDbContext()
            : base(&quot;DefaultConnection&quot;)
        {
        }
    }

If I scaffold a new controller using views with Entity Framework and create a &quot;New data context...&quot; in the dialog, I get this generated for me:

    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    
    namespace WebApplication1.Models
    {
        public class AllTheOtherStuffDbContext : DbContext
        {
            // You can add custom code to this file. Changes will not be overwritten.
            // 
            // If you want Entity Framework to drop and regenerate your database
            // automatically whenever you change your model schema, please use data migrations.
            // For more information refer to the documentation:
            // http://msdn.microsoft.com/en-us/data/jj591621.aspx
        
            public AllTheOtherStuffDbContext() : base(&quot;name=AllTheOtherStuffDbContext&quot;)
            {
            }
    
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }
        
        }
    } 

If I scaffold another controller + view using EF, say for instance for an Animal model, this new line would get autogenerated right under `public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }` - like this:

    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    
    namespace WebApplication1.Models
    {
        public class AllTheOtherStuffDbContext : DbContext
        {
            // You can add custom code to this file. Changes will not be overwritten.
            // 
            // If you want Entity Framework to drop and regenerate your database
            // automatically whenever you change your model schema, please use data migrations.
            // For more information refer to the documentation:
            // http://msdn.microsoft.com/en-us/data/jj591621.aspx
    
            public AllTheOtherStuffDbContext() : base(&quot;name=AllTheOtherStuffDbContext&quot;)
            {
            }
    
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Animal&gt; Animals { get; set; }
    
        }
    } 


`ApplicationDbContext` (for all the ASP.NET Identity stuff) inherits from `IdentityDbContext` which in turn inherits from `DbContext`.
`AllOtherStuffDbContext` (for my own stuff) inherits from `DbContext`.

So my question is:

Which of these two (`ApplicationDbContext` and `AllOtherStuffDbContext`) should I use for all my other own models? Or should I just use the default autogenerated `ApplicationDbContext` since it shouldn&#39;t be a problem using it since it derives from the base class `DbContext`, or will there be some overhead? You should use only one `DbContext` object in your app for all your models (I&#39;ve read this somewhere) so I should not even consider using both `ApplicationDbContext` and `AllOtherStuffDbContext` in a single app? Or what is best practice in MVC 5 with ASP.NET Identity?


ASP.NET Identity DbContext confusion

I am creating an application that searches the database and allows the user to  dynamically add any criteria (around 50 possible), much like the following SO question: https://stackoverflow.com/q/5541234/810850. I currently have working a search that checks each criteria, and if it is not blank it adds it to the query. 

**C#**
  

    var query = Db.Names.AsQueryable();
      if (!string.IsNullOrWhiteSpace(first))
          query = query.Where(q =&gt; q.first.Contains(first));
      if (!string.IsNullOrWhiteSpace(last))
          query = query.Where(q =&gt; q.last.Contains(last));
      //.. around 50 additional criteria
      return query.ToList();

This code produces something similar to the following in sql server (I simplified for easier understanding)

**SQL**

    SELECT
        [Id],
        [FirstName],
        [LastName],
        ...etc
    FROM [dbo].[Names]
    WHERE [FirstName] LIKE &#39;%first%&#39;
      AND [LastName] LIKE &#39;%last%&#39;
I am now trying to add a way to generate the following SQL with C# through entity framework but with an **OR** instead of an **AND**, while still keeping the ability to add criteria dynamically.

**SQL**

    SELECT
        [Id],
        [FirstName],
        [LastName],
        ...etc
      FROM [dbo].[Names]
    WHERE [FirstName] LIKE &#39;%first%&#39;
      OR [LastName] LIKE &#39;%last%&#39; &lt;-- NOTICE THE &quot;OR&quot;

Usually the criteria wont be larger than two or three items for a query but combining them into one gigantic query is not an option. I have tried concat, union, and intersect and they just all duplicate the query and join them with UNION.

Is there a simple and clean way to add &quot;OR&quot; conditions to a dynamically generated query using entity framework?

**Edit with my solution - 9/29/2015**

Since posting this, I have noticed this has received a little attention, so I decided to post my solution

    // Make sure to add required nuget
    // PM&gt; Install-Package LinqKit
    
    var searchCriteria = new 
    {
    	FirstName = &quot;sha&quot;,
    	LastName = &quot;hill&quot;,
    	Address = string.Empty,
    	Dob = (DateTime?)new DateTime(1970, 1, 1),
    	MaritalStatus = &quot;S&quot;,
    	HireDate = (DateTime?)null,
    	LoginId = string.Empty,
    };
    
    var predicate = PredicateBuilder.False&lt;Person&gt;();
    if (!string.IsNullOrWhiteSpace(searchCriteria.FirstName))
    {
    	predicate = predicate.Or(p =&gt; p.FirstName.Contains(searchCriteria.FirstName));
    }
    
    if (!string.IsNullOrWhiteSpace(searchCriteria.LastName))
    {
    	predicate = predicate.Or(p =&gt; p.LastName.Contains(searchCriteria.LastName));
    }
    
    // Quite a few more conditions...
    
    foreach(var person in this.Persons.Where(predicate.Compile()))
    {
    	Console.WriteLine(&quot;First: {0} Last: {1}&quot;, person.FirstName, person.LastName);
    }

Dynamic query with OR conditions in Entity Framework

This line:

    WebSecurity.InitializeDatabaseConnection(connectionStringName: &quot;DefaultConnection&quot;, userTableName: &quot;UserProfile&quot;, userIdColumn: &quot;UserID&quot;, userNameColumn: &quot;UserName&quot;, autoCreateTables: true);
 
Is throwing:

&#39;System.ArgumentException&#39; occurred in System.Data.dll but was not handled in user code

Additional information: Keyword not supported: &#39;metadata&#39;.

My connection string is:

    add name=&quot;DefaultConnection&quot; connectionString=&quot;metadata=res://*/TalyllynModel.csdl|res://*/TalyllynModel.ssdl|res://*/TalyllynModel.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=***********;initial catalog=********;persist security info=True;user id=*********;password=********;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;&quot; providerName=&quot;System.Data.SqlClient&quot; /&gt;&lt;/connectionStrings&gt;

Not sure where it is im going wrong.


  
    

Keyword Not Supported: Metadata

I have an Entity and I am to configure Entity Framework to map it to a database table with different name.

I can easily do this with **[Code First DataAnnotations][1]** (**DataAnnotations.Schema.TableAttribute**).

But due to limitations now I have to use **[Code First Fluent API][2]** (my domain objects will be used by external clients, so they shouldn&#39;t be technology-specific - e.g. have any references to DataAnnotations)

I&#39;ve searched on MSDN but found nothing. So is it possible and how?

Thank you.

  [1]: https://docs.microsoft.com/en-us/ef/ef6/modeling/code-first/data-annotations
  [2]: http://msdn.microsoft.com/en-us/data/jj591620.aspx

How to specify table name with Entity Framework Code First Fluent API

I&#39;m running Visual Studio 2013 Pro (RTM version) on my formatted PC (Windows 8.1 fresh install).

I don&#39;t know why, but Visual Studio 2013 Pro is very very slow! Slow for building, debugging, navigating in the IDE... my hard disk drive LED is not lighting up at all!

I&#39;m on a little [MFC][1] (C++) project using the [Boost][2] library.

Any ideas?

  [1]: http://en.wikipedia.org/wiki/Microsoft_Foundation_Class_Library
  [2]: http://en.wikipedia.org/wiki/Boost_%28C%2B%2B_libraries%29




Why is Visual Studio 2013 very slow?

Using visual studio 2012 on windows 8 x64
aparantly this is caused by msbuild being moved into .net but I havn&#39;t seen how to fix it yet.

    4&gt;C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V110\Microsoft.Cpp.Platform.targets(44,5): error MSB8020: The builds tools for v120 (Platform Toolset = &#39;v120&#39;) cannot be found. To build using the v120 build tools, either click the Project menu or right-click the solution, and then select &quot;Update VC++ Projects...&quot;. Install v120 to build using the v120 build tools.    
    2&gt;C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V110\Microsoft.Cpp.Platform.targets(44,5):
    error MSB8020: The builds tools for v120 (Platform Toolset = &#39;v120&#39;) cannot be found. To build using the v120 build tools, either click the Project menu or right-click the solution, and then select &quot;Update VC++ Projects...&quot;. Install v120 to build using the v120 build tools.    
    5&gt;C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V110\Microsoft.Cpp.Platform.targets(44,5): error MSB8020: The builds tools for v120 (Platform Toolset = &#39;v120&#39;) cannot be found. To build using the v120 build tools, either click the Project menu or right-click the solution, and then select &quot;Update VC++ Projects...&quot;. Install v120 to build using the v120 build tools.



The builds tools for v120 (Platform Toolset = &#39;v120&#39;) cannot be found

When using `BundleConfig` is it possible to include all files of a folder including all the files of the childfolders (and their childfolders etc.)?

I found `.IncludeDirectory()` but it seems to only include the files of the folder itself, not the files of the subfolders.

Include all files in a folder in a single bundle

When I want to search files I use &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;,&lt;/kbd&gt;. The search box pops up and then I start typing. But the built-in preview just grabs whatever I have typed and opens the file. Even though I am still typing. 

I am trying to open a file called `report_vaccine`, but I only get as far as `report` when the preview opens the first selected report. This has rendered this form of quick file searching pretty much useless, which is frustrating because we have hundreds of procs, and scrolling through and manually finding the file is a huge pain. 

If there is a way to turn off preview, I would be fine with that. This command working properly is waaay more important to me than a preview of the file to be opened.

I don&#39;t have resharper. I think the command was like &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;t&lt;/kbd&gt;.  



How can I turn off Visual Studio 2013 Preview?

How can you find the unused NuGet packages in a solution?

I&#39;ve got a number of solutions where there are a lot of installed packages, and a large number of them are flagged as having updates.

However, I&#39;m concerned there may be breaking changes, so I first want to clean up by removing any unused packages. 

Content Type	Original Author	Original Content on Stackoverflow
Question	Erwin Rooijakkers	View Question on Stackoverflow
Solution 1 - Entity Framework	Mikhail Timofeev	View Answer on Stackoverflow
Solution 2 - Entity Framework	Carles Company	View Answer on Stackoverflow
Solution 3 - Entity Framework	neo112	View Answer on Stackoverflow

How to add foreign key relationship in Entity Framework?

Entity Framework Problem Overview

Entity Framework Solutions

Solution 1 - Entity Framework

Solution 2 - Entity Framework

Solution 3 - Entity Framework

How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser

In a lambda, does a by-value capture of a reference copy the underlying object?

Attributions