Entity Frame Work always return null

app-config asp.net-mvc c# entity-framework entity-framework-6

Question

I'm created windows service where I have problem in calling query using entity frame-work inside this service, its always return null.

I tried to reinstall entity-framework package from NuGet but nothing happend.

this is my app.config file part:

<add name="GPSContext" connectionString="data source=server_name;initial catalog=dbName;user id=username;password=****;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.SqlClient" />

and (

The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded.

) run time error returned when I configured my entity-framework: 

   <configSections>

    <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.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="mssqllocaldb" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
1
0
7/16/2018 11:55:05 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You can do a couple of things...

Make sure you have both EntityFramework and EntityFramework.SqlServer added to the references of the calling assembly.

If this will not fix your problem you can delete the BIN folder and try again.

If this still isn't working add the following code somewhere in your calling assembly

internal static class MissingDllHack
{
   // Must reference a type in EntityFramework.SqlServer.dll so that this dll will be
   // included in the output folder of referencing projects without requiring a direct 
   // dependency on Entity Framework. See http://stackoverflow.com/a/22315164/1141360.
   private static SqlProviderServices instance = SqlProviderServices.Instance;
}

the compiler sometimes removes the entityFramework.SqlServer.dll if its not referenced! You do not need to do anything with this code!

0
7/16/2018 12:08:31 PM

Related Questions

Entity Framework ApplicationUser child entities return null

We have an ApplicationUser class which inherits from IdentityUser. An ApplicationUser can have many devices.... public class ApplicationUser : IdentityUser { public virtual ICollection<Device> Devices { get; set; } } ...A Device is defined as... public partial class Device { [Key] public int DeviceID { get; set; } public strin...
asp.net-core asp.net-core-mvc asp.net-identity-3 entity-framework-core
asked by Vague

Entity Framework Core (EF 7) many-to-many results always null

Turns out it's a Lazy Loading issue. You have to "Include" the joining entity and then "ThenInclude" the other entity....var organizations = _context.Organizations .Include(o => o.OrganizationSubscriptionPlans) .ThenInclude(s => s.SubscriptionPlan);
entity-framework-core
asked by Josh Bula

EF return null for some but EF Core return 0

I migrate a site ASP.NET MVC to ASP.NET MVC core, with EF to EF Core....I make a request with empty value :... var q = bd.Prod .Where(o => o.xxx == yyy) .GroupBy(o => o.sss) .Select(g => new { ccc = g.Key, vvv = g.Sum(i => i.qqq), bbb = g.Sum(i => i.fff), ...
asp.net-core-mvc asp.net-mvc c# entity-framework entity-framework-core
asked by perret nicolas

Entity frame work Remove, RemoveRange and EntityState Deleted

What is the difference between these three lines...var courses = _context.Courses .Include("AssignedCustomers") .Include("PricingSchedule") .Include("Licenses") .Include("GroupCourses") ...
c# entity-framework entity-framework-6
asked by Haseeb Khan

Queries to the database return empty or null but saving data does work

The problem is ...Expression.NotEqual... here:...var parameter = Expression.Parameter(entity.ClrType, "e"); var body = Expression.NotEqual( Expression.Call(typeof(EF), nameof(EF.Property), new[] { typeof(DateTime?) }, parameter, Expression.Constant("DeletedAt")), Expression.Constant(null)); modelBuilder.Entity(entity.ClrType).HasQueryFilter...
asp.net-core c# entity-framework-core sql-server
asked by Ivan Stoev

I get error: Value cannot be null, Why is my ICollection always null?

this is OrganizationPhoto module ...public class OrganizationPhoto { public int Id { get; set; } public string Url { get; set; } public string Description { get; set; } public DateTime DateAdded { get; set; } public bool IsMain { get; set; } public string PublicID { get; set; } public Organization Organization { get; set...
asp.net asp.net-core c# entity-framework-core
asked by Luka Tarkhnishvili

Entity Framework Core always returns an empty list of foreign rows

Ok I found finally an answer. By reading this post:...https://www.learnentityframeworkcore.com/lazy-loading...I enabled Lazy-Loading ( is enabled by default ) but the foreign key ...must be virtual...:...public class Author { public int AuthorId { get; set; } public string FirstName { get; set; } public string LastName { get; set; } ...
asp.net-core entity-framework-core
asked by Gaetano Lenoci

why does FindByNameAsync always return null?

trying to authenticate a token through a post request, user always returns null when i check via the username. ... public async Task<IActionResult> Login([FromBody] LoginModel model) { var user = await _userManager.FindByNameAsync(model.UserName); // user always equals null here if (user !=null && await _userManager.CheckPass...
.net-core asp.net-core authentication c# entity-framework-core
asked by Andy Stav

Not able to save data in teacher table in entity frame work core

I have define this one to many relation in academy and teacher table ...modelBuilder.Entity<Teacher>().HasKey(x => x.Id); modelBuilder.Entity<Teacher>().Property(x => x.Id).ValueGeneratedOnAdd(); modelBuilder.Entity<Teacher>().Property(x => x.FirstName).HasMaxLength(100).IsRequired(); modelBuilder.Entity<Teacher>().Property(x => x.LastName).HasMax...
asp.net asp.net-core entity-framework-core
asked by khalid

Returning ViewModel works fine in EF query returning list of entities but not while returning single entity

I have a method in my Asp.Net Core Api for insert new entity which get a ViewModel as an argument and returns another ViewModel as result....I have added Set() method as one of its properties to return list of CreditUserViewModel and it's working fine.... public async Task<IEnumerable<CreditUserViewModel>> GetAll() { return await Tas...
asp.net-core c# entity-framework-core
asked by Mehdi

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow