efcore 2.2 turn off proxy creation for a specific query when Using LazyLoadedProxies

Cant Disable Lazy Loading and Proxy Creation on DbContext EFCore

Is there a way to disable lazy Loading on EntityFramework.Core...In my previous code I have done the following :... public DataContext(string nameOrConnectionString) : base(nameOrConnectionString) { Configuration.LazyLoadingEnabled = false; Configuration.ProxyCreationEnabled = false; } ...but now using the new ef 7 i cant ...

Entity Framework Core - how to programmability turn off auto increment?

If you add DataAnnotations "Key" a new key will be created when you execute "SaveChanges". But if you wanted to bootstrap records into your database, how do you turn off the auto-generate a key feature?...public class Item { [Key] [Required] public Guid Id { get; set; } public string Name { get; set; } }

Publish to azure - turn off scheme update is terminating because data loss could occur

I am using EF6 code first, with automatic migrations disabled. All is fine on my local PC, but when I publish from Visual Studio to Azure I get the error message telling me that the schema update is terminating because data loss might occur. ...I know that the changes I'm running will mean that a data loss will occur but that is fine. But I can'...

Using EntityFramework Core 2.2 to seed data that has a database generated key

I'm using EF Core 2.2, using a code first approach. ...I have my entity class:...public class Client { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] [Key] public int ClientID { get; set; } public string Name { get; set; } } ...and I'm seeding my data like so:...var client = new Client { Name = "TestClient"}; modelBuilder.Ent...

Converting EF Core queries from 2.2 to 3.0 - async await

In EF Core 2.2 I had:... var data = await _ArticleTranslationRepository.DbSet .Include(arttrans => arttrans.Article) .ThenInclude(art => art.Category) .Where(trans => trans.Article != null && trans.Article.Category != null && trans.Article.Category.Id == categoryId.Value) .GroupBy(trans => trans.ArticleId) ...

Using EF Core 2.2 to decrypt a string using SQL Server DECRYPTBYKEY

Basically I have a POCO model that has a encrypted string. Using EF core 2.2....We use DECRYPTBYKEY to decrypt strings using SYMMETRIC KEY....I am using DBSet.FromSQL to pass in SQL query which calls open symmetric key, get the data including the decrypted value, close symmetric key....FromSQL only allows you to bring back an entity rather than a s...

How do I make a raw sql query in EF Core 2.2?

I'm working with a dotnet core 2.x application....We've got a bunch of "code first" entities, and a DBSet for each in the DBContext....EXAMPLE:...public class MyContext : DBContext { public MyContext(DBContextOptions<MyContext> options) : base (options) {} public DbSet<Models.MyTable> MyTable { get; set; } ... ...So far, so good. Now I'd li...

Owned Entities when updating efCore from 2.2 to 3.1

I'm migrating an existing project based on DDD design principles from efcore 2.2 to efcore 3.1. Database setup is based on the series of articles that Julie Lerman wrote a few years ago....Generally this has been fine but I'm struggle to resolve an issued with owned entities and in particular this error message:...InvalidOperationException: The typ...

Unable to hit oracle stored proc using .Net EF(2.2) Core repository pattern

ORA-00900: invalid SQL statement...This is the error i get when i am trying to hit a stored procedure(in Oracle) from my API....I am using Repository pattern with Entity framework.(EF Core 2.2)...This is my call,...return FetchWithStoredProcedure("PROC_GETMYPROC", new OracleParameter("PARAM1", OracleDbType.Int32, ParameterDirection.Input) { Va...

Best way of using/querying many databases with the same model with EF Core 2.2

I'm currently working on a project and for some strange reason I have to use 32 different SQL Server databases with the same model. These databases have different information but the same exact design. ...For some stupid requirement I can't unify these databases. My problem is that I have to implement some Rest services in C# using EF Core 2.2 that...