Base solution for your next web application
Open Closed

Abp.EntityFramework does not work with Core 2.x #7550

User avatar
0
TimMackey created

Abp.EntityFrameworkCore interface does not implement IDbSet interface as specified on this page: https://aspnetboilerplate.com/Pages/Documents/EntityFramework-Integration?searchKey=AbpDbContext

I want to access MS EFCore directly instead of using Repository (which runs 15X slower than ASP.NET EF). My project is Angluar/Core.

When 'Abp.EntityFrameworkCore' is included in my project I keep getting the following error at Web.Host.Startup.cs, line 134: System.TypeLoadException HResult=0x80131522 Message=Method 'get_IsTraceEnabled' in type 'Abp.Castle.Logging.Log4Net.Log4NetLogger' from assembly 'Abp.Castle.Log4Net, Version=4.6.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation. Source=Abp.Castle.Log4Net

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)
Go to accepted answer
19 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    use Abp.EntityFrameworkCore package

    https://aspnetboilerplate.com/Pages/Documents/Entity-Framework-Core

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    Implemented code per the above link.

    Error occurs in Startup.cs at "//Configure Log4Net logging" on "AddFacility" method.

    System.TypeLoadException
  HResult=0x80131522
  Message=Method 'get_IsTraceEnabled' in type 'Abp.Castle.Logging.Log4Net.Log4NetLogger' from assembly 'Abp.Castle.Log4Net, Version=4.6.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation.
  Source=Abp.Castle.Log4Net
  StackTrace:
   at Abp.Castle.Logging.Log4Net.Log4NetLoggerFactory.Create(String name)
   at Castle.Facilities.Logging.LoggingFacility.RegisterDefaultILogger(ILoggerFactory factory)
   at Castle.Facilities.Logging.LoggingFacility.Init()
   at Castle.MicroKernel.DefaultKernel.AddFacility(IFacility facility)
   at Castle.Windsor.WindsorContainer.AddFacility[T](Action`1 onCreate)
   at ngTTM.Web.Startup.Startup.<ConfigureServices>b__4_6(AbpBootstrapperOptions options) in C:\Users\Tim\Documents\__ngTTMv700\aspnet-core\src\ngTTM.Web.Host\Startup\Startup.cs:line 146
   at Abp.AbpBootstrapper..ctor(Type startupModule, Action`1 optionsAction)
   at Abp.AbpBootstrapper.Create[TStartupModule](Action`1 optionsAction)
   at Abp.AspNetCore.AbpServiceCollectionExtensions.AddAbpBootstrapper[TStartupModule](IServiceCollection services, Action`1 optionsAction)
   at Abp.AspNetCore.AbpServiceCollectionExtensions.AddAbp[TStartupModule](IServiceCollection services, Action`1 optionsAction)
   at ngTTM.Web.Startup.Startup.ConfigureServices(IServiceCollection services) in C:\Users\Tim\Documents\__ngTTMv700\aspnet-core\src\ngTTM.Web.Host\Startup\Startup.cs:line 143

    Web.Host/Startup/Startup.c

            public IServiceProvider ConfigureServices(IServiceCollection services)
        {
            //MVC
            services.AddMvc(options =>
            {
                options.Filters.Add(new CorsAuthorizationFilterFactory(DefaultCorsPolicyName));
            }).SetCompatibilityVersion(CompatibilityVersion.Version_2_2);

            services.AddSignalR(options => { options.EnableDetailedErrors = true; });

            //Configure CORS for angular2 UI
            services.AddCors(options =>
            {
                options.AddPolicy(DefaultCorsPolicyName, builder =>
                {
                    //App:CorsOrigins in appsettings.json can contain more than one address with splitted by comma.
                    builder
                        .WithOrigins(
                            // App:CorsOrigins in appsettings.json can contain more than one address separated by comma.
                            _appConfiguration["App:CorsOrigins"]
                                .Split(",", StringSplitOptions.RemoveEmptyEntries)
                                .Select(o => o.RemovePostFix("/"))
                                .ToArray()
                        )
                        .SetIsOriginAllowedToAllowWildcardSubdomains()
                        .AllowAnyHeader()
                        .AllowAnyMethod()
                        .AllowCredentials();
                });
            });

            IdentityRegistrar.Register(services);
            AuthConfigurer.Configure(services, _appConfiguration);

            //Identity server
            if (bool.Parse(_appConfiguration["IdentityServer:IsEnabled"]))
            {
                IdentityServerRegistrar.Register(services, _appConfiguration);
            }

            if (WebConsts.SwaggerUiEnabled)
            {
                //Swagger - Enable this line and the related lines in Configure method to enable swagger UI
                services.AddSwaggerGen(options =>
                {
                    options.SwaggerDoc("v1", new Info { Title = "ngTTM API", Version = "v1" });
                    options.DocInclusionPredicate((docName, description) => true);
                    options.UseReferencedDefinitionsForEnums();
                    options.ParameterFilter<SwaggerEnumParameterFilter>();
                    options.SchemaFilter<SwaggerEnumSchemaFilter>();
                    options.OperationFilter<SwaggerOperationIdFilter>();
                    options.OperationFilter<SwaggerOperationFilter>();
                    options.CustomDefaultSchemaIdSelector();

                    //Note: This is just for showing Authorize button on the UI. 
                    //Authorize button's behaviour is handled in wwwroot/swagger/ui/index.html
                    options.AddSecurityDefinition("Bearer", new BasicAuthScheme());
                });
            }

            //Recaptcha
            services.AddRecaptcha(new RecaptchaOptions
            {
                SiteKey = _appConfiguration["Recaptcha:SiteKey"],
                SecretKey = _appConfiguration["Recaptcha:SecretKey"]
            });

            if (WebConsts.HangfireDashboardEnabled)
            {
                //Hangfire(Enable to use Hangfire instead of default job manager)
                services.AddHangfire(config =>
                {
                    config.UseSqlServerStorage(_appConfiguration.GetConnectionString("Default"));
                });
            }

            if (WebConsts.GraphQL.Enabled)
            {
                services.AddAndConfigureGraphQL();
            }

            // configure NgTtmAbpDbContext context
            services.AddAbpDbContext<NgTtmAbpDbContext>(options =>
            {
                options.DbContextOptions.UseSqlServer(options.ConnectionString);
            });

            //Configure Abp and Dependency Injection
            return services.AddAbp<ngTTMWebHostModule>(options =>
            {
                //Configure Log4Net logging
                options.IocManager.IocContainer.AddFacility<LoggingFacility>(
                    f => f.UseAbpLog4Net().WithConfig("log4net.config")
                );

                options.PlugInSources.AddFolder(Path.Combine(_hostingEnvironment.WebRootPath, "Plugins"), SearchOption.AllDirectories);
            });
        }

    DbContextLibrary/NgTtmAbpDbContext.cs

    using Abp.EntityFrameworkCore;
using Abp.Modules;
using Microsoft.EntityFrameworkCore;
using ngTTM.TtmDataModel;

namespace DbContextLibrary
{
    [DependsOn(typeof(AbpEntityFrameworkCoreModule))]
    public class NgTtmAbpDbContext : AbpDbContext
    {
        public virtual DbSet<AnswerMatch> AnswerMatchs { get; set; }

        public virtual DbSet<Answer> Answers { get; set; }

        public virtual DbSet<Question> Questions { get; set; }

        public virtual DbSet<QuestionBank> QuestionBanks { get; set; }

        public NgTtmAbpDbContext(DbContextOptions<NgTtmAbpDbContext> options)
            : base(options)
        {
        }
    }
}

    Web.Host/Startup/ngTTMWebHostModule.cs

            public override void PreInitialize()
        {
            Configuration.Modules.AbpWebCommon().MultiTenancy.DomainFormat = _appConfiguration["App:ServerRootAddress"] ?? "http://localhost:22742/";
            Configuration.Modules.AspNetZero().LicenseCode = _appConfiguration["AbpZeroLicenseCode"];
            Configuration.DefaultNameOrConnectionString = GetConnectionString("Default");
        }

        private string GetConnectionString(string conn)
        {
            var appsettingsjson = JObject.Parse(File.ReadAllText("appsettings.json"));
            var dbConnectionStrings = (JObject)appsettingsjson["ConnectionStrings"];

            string connStr = dbConnectionStrings.Property("Default").Value.ToString();
            return connStr;
        }
    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    Method 'get_IsTraceEnabled' in type 'Abp.Castle.Logging.Log4Net.Log4NetLogger' from assembly 'Abp.Castle.Log4Net, Version=4.6.0.0, Culture=neutral, PublicKeyToken=null' does not have an implementation.

    https://github.com/aspnetboilerplate/aspnetboilerplate/issues/4445#issuecomment-495637354 https://github.com/aspnetboilerplate/aspnetboilerplate/pull/4539

    Usually you only need to upgrade the ABP package.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    Upgraded Abp.Castle.Log4Net, Abp.RedisCcache, Abp, Abp.ZeroCore from 4.6.0 to 4.8.1. Startup works fine. Using context causes Exception:

    Message: LoadQuestionsXml.cs, ParseQuestionFile
Exception Type: System.InvalidOperationException
Exception: No database provider has been configured for this DbContext. A provider can be configured by overriding the DbContext.OnConfiguring method or by using AddDbContext on the application service provider. If AddDbContext is used, then also ensure that your DbContext type accepts a DbContextOptions<TContext> object in its constructor and passes it to the base constructor for DbContext.
Source: Microsoft.EntityFrameworkCore
Stack Trace: 
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.Initialize(IServiceProvider scopedProvider, IDbContextOptions contextOptions, DbContext context)
   at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
   at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
   at Microsoft.EntityFrameworkCore.DbContext.get_Model()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.get_EntityType()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.get_EntityQueryable()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.System.Linq.IQueryable.get_Provider()
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   at ImportFilesLibrary.LoadQuestionsXml.ParseQuestionFile(MemoryStream FileContent, Int32 QuestionBankId, Nullable`1 userId) in C:\Users\Tim\Documents\__ngTTMv700\aspnet-core\...myfile.cs

    ...at " var data = context.QuestionBanks.FirstOrDefault(b => b.Id == 123);"

    public class myClass
{
        private static DbContextOptions<NgTtmAbpDbContext> dbContextOptions = new DbContextOptions<NgTtmAbpDbContext>();

public void MyFunction()
{
    using (NgTtmAbpDbContext context = new NgTtmAbpDbContext(dbContextOptions))
    {
            var data =  context.QuestionBanks.FirstOrDefault(b => b.Id == 123);
    }

    Tried resolving error message, but Google searched solutions did not work.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    In general you should not use AbpDbContext directly. You should use Repository. https://aspnetboilerplate.com/Pages/Documents/Repositories

    I suggest you first check the abp & abp zero documentation.

    https://aspnetboilerplate.com/Pages/Documents/ https://docs.aspnetzero.com/documents/common/latest/

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    I initially migrated some ASP.NET code to my ANZ app and used injection and IRepository as is used throughout ANZ. However, the performance for db-intensive operations is 15X SLOWER (due I surmise to the transactional nature of the interface). The db-intensive portion of my app is not built on the transaction model. Your first reply in this thread directed me to Enitity-Framework-Core, which I implemented. Now you're telling me that I shouldn't use it. The app I'm migrating from ASP.NET accessed EF directly. ANZ InitialHostDbBuilder class uses EF context directly. I need to access EF directly for performance reasons. Why can't access context directly in my app? Given https://aspnetboilerplate.com/Pages/Documents/Entity-Framework-Core is published documentation, how to I make it work?

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    You can try to get DbContext using IDbContextProvider instead of creating it manually.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    Could you please direct me to the documentation and some sample code?

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    Very simple, inject the IDbContextProvider interface and then call the method to get the DbContext.

    public interface IDbContextProvider<out TDbContext>
	where TDbContext : DbContext
{
	TDbContext GetDbContext();

	TDbContext GetDbContext(MultiTenancySides? multiTenancySide );
}

    https://github.com/aspnetzero/aspnet-zero-core/blob/16582df85fbceba18fe61fdd613d1093ef25921c/aspnet-core/src/MyCompanyName.AbpZeroTemplate.Application/HealthChecks/AbpZeroTemplateDbContextUsersHealthCheck.cs#L14

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    I implemented the changes as described above. My app compiles and runs without encountering Exceptions. The records in the db are as expected. However, the performance of the IDbContextProvider interface is 10X SLOWER than the equivalent MS EntityFramework context db access in ASP.NET, and is transactional. No data is actually written to the db until the thread completes and the IDbContextProvider is Disposed by the task caller. Multiple calls to "context.SaveChanges()" have no effect on the db. Why must I use IDbContextProvider interface? How can I get better performance from this interface? How can I override the transactional nature of this interface (without resorting to more overhead via UnitOfWork)? Why can I not use MS EntityFrameworkCore directly? And if I can, how?

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    Because the entire framework is based on dependency injection.

    No database provider has been configured for this DbContext. ....

    try

    var builder = new DbContextOptionsBuilder<AbpZeroTemplateDbContext>();
builder.UseSqlServer(_appConfiguration.GetConnectionString("Default"));
var db = new AbpZeroTemplateDbContext(builder.Options);
var user = db.Users.FirstOrDefault();
    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    Getting an Exception when the above is implemented:

    Exception Type: System.InvalidOperationException
Exception: Unable to determine the relationship represented by navigation property 'User.DeleterUser' of type 'User'. Either manually configure the relationship, or ignore this property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.
Source: Microsoft.EntityFrameworkCore
Stack Trace: 
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.PropertyMappingValidationConvention.Apply(InternalModelBuilder modelBuilder)
   at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnModelBuilt(InternalModelBuilder modelBuilder)
   at Microsoft.EntityFrameworkCore.ModelBuilder.FinalizeModel()
   at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
--- End of stack trace from previous location where exception was thrown ---
   at System.Lazy`1.CreateValue()
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
   at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
   at lambda_method(Closure , ServiceProviderEngineScope )
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
   at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
   at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
   at Microsoft.EntityFrameworkCore.DbContext.get_Model()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.get_EntityType()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.get_EntityQueryable()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.System.Linq.IQueryable.get_Provider()
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   at ImportFilesLibrary.LoadQuestionsXml.ParseQuestionFile(MemoryStream FileContent, Int32 QuestionBankId, Nullable`1 userId) in C:\Users\Tim\Documents\__ngTTMv700\aspnet-core\ttm\ImportFilesLibrary\LoadQuestionsXml.cs:line 69

    at LoadQuestionsXml.cs:line 69 is fhe following code:

                    QuestionBank questionBank =
                    context.QuestionBanks
                           .FirstOrDefault(b => b.QuestionBankId == QuestionBankId);

    NgTtmAbpDbContext.cs

    using Abp.EntityFrameworkCore;
using Abp.Modules;
using Microsoft.EntityFrameworkCore;
using ngTTM.TtmDataModel;

namespace DbContextLibrary
{
    [DependsOn(typeof(AbpEntityFrameworkCoreModule))]
    public class NgTtmAbpDbContext : AbpDbContext
    {
        public virtual DbSet<AnswerMatch> AnswerMatchs { get; set; }

        public virtual DbSet<Answer> Answers { get; set; }

        public virtual DbSet<Question> Questions { get; set; }

        public virtual DbSet<QuestionBank> QuestionBanks { get; set; }

        public NgTtmAbpDbContext(DbContextOptions<NgTtmAbpDbContext> options)
            : base(options)
        {
        }
    }
}

    Implemented the code fragment you suggested as:

                    var builder = new DbContextOptionsBuilder<NgTtmAbpDbContext>();
                string connStr = _appConfiguration.GetConnectionString("Default");
                builder.UseSqlServer(connStr);
                NgTtmAbpDbContext context = new NgTtmAbpDbContext(builder.Options);
    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    hi @timmackey Can you reproduce your problem using Zero's Demo project? Send to: [email protected]

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    The previously reported Exception has been eliminated by modifying the class as follows:

        public class NgTtmAbpDbContext : AbpZeroDbContext<Tenant, Role, User, NgTtmAbpDbContext>

    No Exceptions occur, however, an earlier created table is not being updated:

                    QuestionBank questionBank =
                    context.QuestionBanks
                           .FirstOrDefault(b => b.QuestionBankId == QuestionBankId);
                if (questionBank == null)
                {
                    status.FailureReason = FailureReason("UnableToOpenQuestionBankId_0", QuestionBankId.ToString());
                    status.Success = false;
                    return status;
                }

                questionBank.ItemsTotal = elementCount * 2;
                questionBank.ItemsProcessed = 0;
                context.SaveChanges();

    "context.SaveChanges();" is not updating QuestionBanks table.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    maliming created
    Support Team

    hi @timmackey

    The code you shared made me unable to determine the problem.

    Can you reproduce your problem using Zero's Demo project? Send to: [email protected]

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    Created a project based on Zero's Demo project.

    Unable to reproduce the error

    Exception: Unable to determine the relationship represented by navigation property 'User.DeleterUser' of type 'User'. Either manually configure the relationship, or ignore this property using the '[NotMapped]' attribute or by using 'EntityTypeBuilder.Ignore' in 'OnModelCreating'.

    in the Demo project due, I suspect, to the specific table/foreign key relationships in my db, which I would be impractical to reproduce in a demo project.

    I will submit a new issue that I need to resolve that may reveal a solution to this issue.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @timmackey

    Your last problem might be related to https://github.com/aspnetboilerplate/aspnetboilerplate/issues/4691

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @timmackey

    Did you have a chance to try this ?

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    TimMackey created

    The above suggested solution was only partially related to my problem. I solved the issue by conditionally compiling out foreign keys (but not the id) in tables that referenced referenced Tenant. i.e.

        [Table("Buildings")]
    public class Building : FullAuditedEntity , IMayHaveTenant
    {
#if !CUSTOM_DB_CONTEXT_LIB
        [ForeignKey("TenantId")]
        public virtual Tenant Tenant { get; set; }
#endif
        public virtual int? TenantId { get; set; }
        
        [Required]
        [StringLength(BuildingConsts.MaxBuildingNameLength, MinimumLength = BuildingConsts.MinBuildingNameLength)]
        public virtual string BuildingName { get; set; }
       ...
    }

    This allows me to use the same table definition files in ANZ-generated context public class AnzAppDbContext : AbpZeroDbContext<Tenant, Role, User, AnzAppDbContext>, IAbpPersistedGrantDbContext and my custom context for .NET Core 2.2, which is...

    using Microsoft.EntityFrameworkCore;

namespace CustomDbContextLibrary
{
    public class CustomDbContext : DbContext
    {
        public virtual DbSet<Building> Buildings { get; set; }
        ...
        public virtual DbSet<Room> Rooms { get; set; }

        public ExamDbContext(DbContextOptions<ExamDbContext> options)
           : base(options)
        {
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
        }
    }
}

    The class constructor is

    using Microsoft.EntityFrameworkCore;
#if CUSTOM_DB_CONTEXT_LIB
using CustomDbContextLibrary;
using DbContext = CustomDbContextLibrary.CustomDbContext;
#else
using  AnzApp.AnzAppDataModel;
using DbContext = AnzApp.EntityFrameworkCore.AnzAppDbContext;
#endif
using Abp.EntityFrameworkCore;
using Abp.Domain.Uow;
using System.Transactions;
using Microsoft.Extensions.Configuration;
using Microsoft.AspNetCore.Hosting;

private readonly IDbContextProvider<DbContext> _dbContextProvider;
private readonly IConfigurationRoot _appConfiguration;
private readonly DbContextOptionsBuilder<DbContext> _dbContextOptionsBuilder;
//-----------------------------------------------------------------------------------------
public CreateSomethingClass(
    IDbContextProvider<DbContext> dbContextProvider,
    IHostingEnvironment hostingEnvironment
    )
{
    _dbContextProvider = dbContextProvider;
    _appConfiguration = hostingEnvironment.GetAppConfiguration();
    _dbContextOptionsBuilder = new DbContextOptionsBuilder<DbContext>();
    string connStr = _appConfiguration.GetConnectionString("Default");
    _dbContextOptionsBuilder.UseSqlServer(connStr);
}

    Usage is

     public virtual bool Create(string guid, string rootFolder)
 {
        using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Suppress))
        {
            DbContext context = new DbContext(_dbContextOptionsBuilder.Options);
            {
                Building bldg = context.Buildings.First(x => x.BuildingName == "Electric Tower") ;
                bldg.BuildingName = "Tower Two";
                context.SaveChanges();
                ...
                // thousands of lines of code not shown
             }
          }
 }

    This provides performance equivalent to ASP.NET EntityFramework when referencing many tables for high frequency bursts of create/read/update rows.

    Making the Create method virtual, as suggested in ticket #7635 eliminates transactional nature of db access. This resolves all issues.

    @maliming and @ismcagdas - Thank you for your all your suggestions.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
Assignee
No one
Labels
None yet