You&#39;ve removed the wrong convention (*PluralizingEntitySetNameConvention*) for this purpose. Just replace your *OnModelCreating* method with the below and you will be good to go.
    
    using System.Data.Entity.ModelConfiguration.Conventions.Edm.Db;
    ...
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {    
        modelBuilder.Conventions.Remove&lt;PluralizingTableNameConvention&gt;();
    }

With Entity Framework 6, on your file that inherit from DbContext:

    using System.Data.Entity.ModelConfiguration.Conventions;

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove&lt;PluralizingTableNameConvention&gt;();
    }



You can also change the property value:

On the Tools menu, click Options.
In the Options dialog box, expand Database Tools.
Click O/R Designer.
Set Pluralization of names to Enabled = False to set the O/R Designer so that it does not change class names.
Set Pluralization of names to Enabled = True to apply pluralization rules to the class names of objects added to the O/R Designer.

The location of the definition of PluralizingTableNameConvention has moved to:


&gt;    `using System.Data.Entity.ModelConfiguration.Conventions;`
&gt;

I&#39;ve seen numerous examples on how to take a CSV file and then create an associative array with the headers as the keys.

For example:

    Brand,Model,Part,Test
    Honda,Civic,123,244
    Honda,Civic,135,434
    Toyota,Supra,511,664

Where it would create an Array such as     `Array[$num][$key]` where `$key` would be Brand, Model, Part, Test.

So If I wanted to access the test value &quot;434&quot; I would have to loop every index in the array and then ignore any Brands that were not honda, and any models that were not Civic

---------

What I need to do is access the value most directly, instead of running through a for loop going through each $num index. I want to be able to access the value test &quot;434&quot; with:

`Array[&#39;Honda&#39;][&#39;Civic&#39;][&#39;135&#39;]`

or control a for statement with looping through every model Honda has... something like

`foreach $model in Array[&#39;Honda&#39;]`

At the very least I need to be able to go through every model given a known Brand and access all the relative info for each.

Edit:

Just to confirm I was setting this up an example. My actually data has headers like:


`brand	model	part price	shipping	description	footnote`

Of which I need to access all the information tied to the part (price, shipping,desc, footnote)


CSV to Associative Array

I would like to export a single Postgres table&#39;s data into a .csv file. Can anyone give me an example of how to do that?

How to export table data to file

I prefer using singular nouns when naming my database tables.  In EF code first however, the generated tables always are plural.  My DbSets are pluralized which I believe is where EF is generating the names but I don&#39;t want to singularize these names as I believe it is more pratical to have them plural in code.  I also tried overriding the setting but to no avail.

Any ideas?  Here is my code and thanks.

MyObjectContext.cs

    public class MyObjectContext : DbContext, IDbContext
    {
         public MyObjectContext(string connString) : base(connString)
         {
         }
         public DbSet&lt;Product&gt; Products {get;set;}
         public DbSet&lt;Category&gt; Categories {get;set;}
         //etc.
    
         protected override void OnModelCreating(ModelBuilder modelBuilder)
         {
            modelBuilder.Conventions.Remove&lt;PluralizingEntitySetNameConvention&gt;();
         }
    }

How do I singularize my tables in EF Code First?

I prefer using singular nouns when naming my database tables. In EF code first however, the generated tables always are plural. My DbSets are pluralized which I believe is where EF is generating the names but I don't want to singularize these names as I believe it is more pratical to have them plural in code. I also tried overriding the setting but to no avail.
Any ideas? Here is my code and thanks.
MyObjectContext.cs
<pre><code class="hljs language-csharp">public class MyObjectContext : DbContext, IDbContext
{
 public MyObjectContext(string connString) : base(connString)
 {
 }
 public DbSet&#x3C;Product> Products {get;set;}
 public DbSet&#x3C;Category> Categories {get;set;}
 //etc.

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
 modelBuilder.Conventions.Remove&#x3C;PluralizingEntitySetNameConvention>();
 }
}
</code></pre>

How do I pass a connection string to entity framework&#39;s code-first DbContext? My database generation works correctly when both DbContext and the connection string in web.config is in the same project and named the same way. But now I need to move the DbContext to another project so I&#39;m testing passing a connection string to it as follows:


**Model &amp; Context**

    public class Dinner
    {
        public int DinnerId { get; set; }
        public string Title { get; set; }
    }

    public class NerdDinners : DbContext
    {
        public NerdDinners(string connString)
            : base(connString)
        {
        }
        public DbSet&lt;Dinner&gt; Dinners { get; set; }
    }

**Action**

        public ActionResult Index()
        {
            var db = new NerdDinners(ConfigurationManager.ConnectionStrings[&quot;NerdDinnerDb&quot;].ConnectionString);

            var dinners = (from d in db.Dinners
                          select d).ToList();
            return View(dinners);
        }

**Web.Config**

    &lt;connectionStrings&gt;
      &lt;add name=&quot;NerdDinnerDb&quot; connectionString=&quot;Data Source=|DataDirectory|NerdDinners.sdf&quot; providerName=&quot;System.Data.SqlServerCe.4.0&quot;/&gt;    
    &lt;/connectionStrings&gt;

If I set a breakpoint in the action an analyze the `db`, the connection string is there, but it does not create or find the database or anything.

&gt; A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Pass connection string to code-first DbContext

I&#39;ve watched several presentations of EF Code First and haven&#39;t seen how EFCF works with stored procedures.

How can I declare a method that will use some sp? Can I pass an entity to a method that calls sp without manually mapping entity properties to sp parameters?

Also, what happens if I change my model? Would it drop my sp while recreating table from model? And what about triggers?

If these things are not supported, are there any plans to support them in future?

Does Entity Framework Code First support stored procedures?

I am using Entity Framework and occasionally i will get this error. 

    EntityCommandExecutionException
    {&quot;There is already an open DataReader associated with this Command which must be closed first.&quot;}
       at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands...

Even though i am not doing any manual connection management. 

this error happens intermittently.

code that triggers the error (shortened for ease of reading):

            if (critera.FromDate &gt; x) {
                t= _tEntitites.T.Where(predicate).ToList();
            }
            else {
                t= new List&lt;T&gt;(_tEntitites.TA.Where(historicPredicate).ToList());
            }


using Dispose pattern in order to open new connection every time.


    using (_tEntitites = new TEntities(GetEntityConnection())) {
    
        if (critera.FromDate &gt; x) {
            t= _tEntitites.T.Where(predicate).ToList();
        }
        else {
            t= new List&lt;T&gt;(_tEntitites.TA.Where(historicPredicate).ToList());
        }
    
    }

still problematic 

why wouldn&#39;t EF reuse a connection if it is already open. 

Entity Framework: There is already an open DataReader associated with this Command

I&#39;m working with the Code First feature of Entity Framework and I&#39;m trying to figure out how I can specify the column data types that should be created when the database is auto-generated.

I have a simple model:

    public class Article
    {
        public int ArticleID { get; set; }

        public string Title { get; set; }
        public string Author { get; set; }
        public string Summary { get; set; }
        public string SummaryHtml { get; set; }
        public string Body { get; set; }
        public string BodyHtml { get; set; }
        public string Slug { get; set; }

        public DateTime Published { get; set; }
        public DateTime Updated { get; set; }

        public virtual ICollection&lt;Comment&gt; Comments { get; set; }
    }

When I run my application, a SQL CE 4.0 database is automatically created with the following schema:

![DB Schema][1]

So far, so good! However, the data I will be inserting into the `Body` and `BodyHtml` properties is routinely larger than the maximum allowed length for the `NVarChar` column type, so I want EF to generate `Text` columns for these properties.

However, I cannot seem to find a way to do this! After quite a bit of Googling and reading, I tried to specify the column type using `DataAnnotations`, from information found in [this answer][2]:

    using System.ComponentModel.DataAnnotations;

    ...

    [Column(TypeName = &quot;Text&quot;)]
    public string Body { get; set; }

This throws the following exception (when the database is deleted and the app is re-run):

    Schema specified is not valid. Errors: (12,6) : error 0040: The Type text is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.

But I have no idea what namespace or alias I should be specifying, and I couldn&#39;t find anything that would tell me.

I also tried changing the annotation as per [this reference][3]:

    using System.Data.Linq.Mapping;

    ...

    [Column(DbType = &quot;Text&quot;)]
    public string Body { get; set; }

In this case a database _is_ created, but the `Body` column is still an `NVarChar(4000)`, so it seems that annotation is ignored.

Can anyone help? This seems like it should be a fairly common requirement, yet my searching has been fruitless!


  [1]: http://i.stack.imgur.com/A4OI9.gif
  [2]: https://stackoverflow.com/questions/4829776/generate-money-type-fields-using-code-first-ef-ctp5/4833477#4833477
  [3]: http://msdn.microsoft.com/en-us/library/system.data.linq.mapping.columnattribute.dbtype.aspx

How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)

I&#39;m creating a POCO model to use with entity framework code first CTP5.  I&#39;m using the &lt;key()&gt; decoration to make a property map to a PK column.  But how can I define a PK on more then one column, and specifically, how can I control order of the columns in the index?  Is it a result of the order of properties in the class?

Thanks!

in entity framework code first, how to use KeyAttribute on multiple columns

Following on the heels of my other [question about mocking DbContext.Set&lt;T&gt;][1] I&#39;ve got another question about mocking EF Code First.

I now have a method for my update that looks like:

    if (entity == null)
        throw new ArgumentNullException(&quot;entity&quot;);
    
    Context.GetIDbSet&lt;T&gt;().Attach(entity);
    Context.Entry(entity).State = EntityState.Modified;
    Context.CommitChanges();
    
    return entity;

Context is an interface of my own DbContext.

The problem I&#39;m running in to is, how do I handle the

 `Context.Entry(entity).State`.

I&#39;ve stepped through this code and it works when I have a real live DbContext as the implementation of my Context interface.  But when I put my fake context there, I don&#39;t know how to handle it.

There is no constructor for a DbEntityEntry class, so I can&#39;t just create a new one in my fake context.

Has anyone had any success with either mocking or faking DbEntityEntry in your CodeFirst solutions?

Or is there a better way to handle the state changes?

  [1]: https://stackoverflow.com/questions/5007100/mocking-dbcontext-sett

Mocking or faking DbEntityEntry or creating a new DbEntityEntry

I have an MVC3 and EF 4 Code First application, which is configured to change the DB when the model changes, by setting the DB Initializer to a `DropCreateDatabaseIfModelChanges&lt;TocratesDb&gt;`, where `TocratesDb` is my derived `DbContext`.

I have now made a change to the model, by adding properties to a class, but when EF tries to drop and recreate the DB, I get the following error:

    Cannot drop database &quot;Tocrates&quot; because it is currently in use.

I have absolutely no other connections anywhere open on this database.  I assume that my cDbContext still has an open connection to the database, but what can I do about this?

**NEW:** Now my problem is how to re-create the database based on the model.  By using the more general IDatabaseInitializer, I lose that and have to implement it myself.  

Database in use error with Entity Framework 4 Code First

I have the situation where I&#39;m initializing my model in DatabaseInitializer() for EF 4.1 and get this annoying error `&quot;Validation failed for one or more entities. See &#39;EntityValidationErrors&#39; property for more details.&quot;` So, I go to this EntityValidationErrors and there is a field `{System.Data.Entity.Validation.DbEntityValidationResult}` which gives me no information at all about what field it was unable to initialize. 
Is there a way to get more info about this error?

**To clear things out:**

I know how to fix the string length problem. What I&#39;m asking is how do I get the exact field name that is breaking the model. 

Getting exact error type in from DbValidationException

How do I tell EF what to name the database and where to put it?

If there is no connection string in the Web.Config, it tries to put it in the local SQLEXPRESS Server, but I want to put it out on a known SQL Server and name it what I want. Any suggestions?

Content Type	Original Author	Original Content on Stackoverflow
Question	trevorc	View Question on Stackoverflow
Solution 1 - Entity Framework	Morteza Manavi	View Answer on Stackoverflow
Solution 2 - Entity Framework	Francisco	View Answer on Stackoverflow
Solution 3 - Entity Framework	Mythlandia	View Answer on Stackoverflow

How do I singularize my tables in EF Code First?

Entity Framework Problem Overview

Entity Framework Solutions

Solution 1 - Entity Framework

Solution 2 - Entity Framework

Solution 3 - Entity Framework

How to export table data to file

CSV to Associative Array

Attributions