CODEWITHSUNDEEP
c#entity-frameworkweb-configmdf
guisantogui
guisantogui

Reputation: 4136

Entity Framework returns empty list

When I try to select All items in a list I got an empty list.

This is my Business.Classification class, where I call ToList()

public class Classification
{
    private DatabaseContext db;

    public Classification()
    {
        if (db == null)
            db = new DatabaseContext();
    }

    public int getClassification()
    {

        using (db)
        {
            List<Classification> a = db.ClassificationContext.ToList();

            return a.Count;
        }
    }

}

This is My Model class:

[Table("Classification")]
public class Classification
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.None)]
    [Column]
    public Guid ClassificationId { get; set; }

    [Column]
    public string ClassificationName { get; set; }

}

Here goes my Context class:

public class DatabaseContext : DbContext
{
    public DbSet<Classification> ClassificationContext { get; set; }

}

Here is the app Config file of my Business project:

<configuration>
  <connectionStrings>
    <add name="Conection" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Guilherme\Documents\Database.mdf;Integrated Security=True;Connect Timeout=30" providerName="System.Data.EntityClient"/>
  </connectionStrings>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Upvotes: 1

Views: 2842

Answers (2)

Nitin
Nitin

Reputation: 45

I spent almost half day fixing the similar issue. Turns out I didn't run the commit on the oracle database. This link helped me.

Upvotes: -1

user3754008
user3754008

Reputation: 285

your connection string might cost this issue.

<connectionStrings>
<add name="DatabaseContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Guilherme\Documents\Database.mdf;Integrated Security=True;Connect Timeout=30" providerName="System.Data.EntityClient"/>
</connectionStrings>

Upvotes: 0

Related Questions