Can I use Entity Framework on Windows Phone 8

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

I am using Entity Framework 6 and I am using EntityFramework Extended to perform some batch updates and batch deletes. The batch updates and batch deletes work OK however I also need to know the entities that were updated / deleted (i.e. the current and previous values). I thought that using the AuditLogger provided by EntityFramework.Extended wo...

Entity Framework Core use windows service

Currently in the process of building a multi tired application using EF Core for my data access layer and I feel like I'm running in to a problem and I'm not 100% certain I can use it at the moment....Essentially I'm designing my application into the following components...windows assembly...asp.net mvc core web app...windows service x2...unit test...

Entity Framework, Load multiple entities by primary key in a single query while still using caching

I have a list of primary key ids for a table whose entities I want to pull into EF memory, modify, and then save....With a single id you would do something like...var entity = dbContext.Entity.Find(id); entity.SomeColumn = "something"; dbContext.SaveChanges() ...Currently I'm doing something like this to pull all the entities to be modified in on...

Entity Framework Core not working with Windows Authentication

Whenever I try to connect to the database I get this exception...Unhandled Exception: System.Data.SqlClient.SqlException: Cannot open database "TrackTvDb" requested by the login. The login failed. Login failed for user 'DESKTOP-MTHC289\hristo.kolev'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlCo...

Using T4 template to force PascalCase (TitleCase) for entities in Entity Framework 6

Turns out, simply modifying the default T4 template was actually really easy. Inside ...GetTypeName... there is a ...is StructuralType... check which handles all non-primitive types. That pretty well fixed the majority of my issues. Then it was just a matter of ...Ctrl-F... for keywords. My frustration was just getting the best of me when I origina...

Entity Framework Core on Windows IoT running on a RPi 3 (Console Application)

I successfully deployed a .NET Core Console Application to my Windows IoT running on a Raspberry Pi 3....The application pulls data from a webservice and stores them in a database. I used Entity Framework Core for that....When I start the deployed console application (.exe) through the remote powershell everything works except the access to my data...

Entity framework Code-First in c# interactive window (Oracle)

I finally managed to get it working....First of all I was receiving the message "The underlying provider failed on Open." because EF was not able to get the correct provider and connection factory. It was in fact trying to use the SqlServer connection factory instead than the one from Oracle. In a database-first approach you could have created the ...

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

Using AddRange over Add is already a great improvement. It fixes the part that's slow in the Application....However, the ...SaveChanges... still take a lot of time because one database round-trip is made for every entity you save. So if you have 10k entities to insert, 10,000 database round-trip will be made which is ...INSANELY... slow....Disclaim...

Getting space used by tables using Entity Framework Core

We can definitely make this work, using a Raw SQL Query. ...First things first, when we run this query, it would be better to get the results back in a type of class that Entity Framework can work with. I have tried retrieving arbitrary query results back and found the results to tricky to parse. My advice is to make a class to describe the res...

Entity Framework Core 3.1 is throwing "Include has been used on non entity queryable" exception

I have an ASP.NET Core 3.1 based project where I am using Entity Framework Core 3.1 as an ORM....I have the following two entity models...public class PropertyToList { public int Id { get; set; } public int ListId { get; set; } public int UserId { get; set; } public int PropertyId { get; set; } // ... Other properties removed f...