logo
down
shadow

How can you migrate an entity framework project to .NET standard when the fluent configuration is using HasDatabaseGener


How can you migrate an entity framework project to .NET standard when the fluent configuration is using HasDatabaseGener

Content Index :

How can you migrate an entity framework project to .NET standard when the fluent configuration is using HasDatabaseGener
Tag : chash , By : algoRhythm99
Date : November 24 2020, 05:49 AM

Hope that helps The solution was that I used a .NET Framework class library (I am using v4.7.2 as the Target Framework Version) for my EF 6.2 repository layer. EF 6.2 doesn't work in netstandard2.0 class libraries due to missing .NET Framework dependencies (System.Configuration.ConfigurationManager and migrations).
A .NET Core app can reference a .NET Framework class library if you set its target framework to .net framework (net472 for example), although you lose cross platform capability. If you need cross platform, you can use EF Core, although this won't work for us in the short term.

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Entity Framework Code First Fluent API configuration for one to one identifying relationship


Tag : chash , By : Doug
Date : March 29 2020, 07:55 AM
this one helps. The way EF implements one-to-one is to make the dependent entity have a primary key that's also a foreign key to the principle entity. So the dependent's PK is naturally constrained to existing principle PK values.
So using your classes, slightly modified:
public class Customer
{
    public int CustomerId { get; private set; }
    public virtual Card Card { get; set; }
}

public abstract class Card
{
    public int CustomerId { get; private set; }
}

public class Visa : Card { }

public class Amex : Card { }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<Customer>().HasRequired(c => c.Card)
                                   .WithRequiredPrincipal();
    modelBuilder.Entity<Card>().HasKey(c => c.CustomerId);
}
using (var db = new TempModelsContext())
{
    var cst = new Customer { Name = "Customer1", 
                             Card = new Amex { Number = "Amex" } };
    db.Customers.Add(cst);
    db.SaveChanges();
}

using (var db = new TempModelsContext())
{
    var cst = db.Customers.Include(c => c.Card).Single(c => c.CustomerId == 1);
    cst.Card = new Visa { Number = "Visa" };
    db.SaveChanges();
}
var cst = db.Customers.Include(c => c.Card).Single(c => c.CustomerId == 1);
db.Cards.Remove(cst.Card);
db.SaveChanges();

cst.Card = new Visa { Number = "Visa" };
db.SaveChanges();

Fluent configuration for base entity in Entity Framework


Tag : chash , By : obijywk
Date : March 29 2020, 07:55 AM
I wish did fix the issue.
Do I really have to configure the MaxLength of the two string properties in every single DbModelBuilder configuration?
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<BaseEntity>().Property(x => x.CreateUserId).HasMaxLength(36);
    modelBuilder.Entity<BaseEntity>().Property(x => x.ModifyUserId).HasMaxLength(36);

    base.OnModelCreating(modelBuilder);
}
modelBuilder.Properties().Where(x => x.Name == "CreateUserId").Configure(x => x.HasMaxLength(36));
modelBuilder.Properties().Where(x => x.Name == "ModifyUserId").Configure(x => x.HasMaxLength(36));

How to use use same configuration between .NET Framework, .NET Standard, and .NET Core project?


Tag : asp.net , By : user155548
Date : March 29 2020, 07:55 AM
I wish this help you You should read the value from configuration before calling your library, and pass it by parameter, either into a method or constructor.
In general, library code shouldn't depend on side effects from the configuration of its host environment. Doing so makes it very difficult to reuse code, or to test effectively.

Port existing code first models, and fluent aPI configuration from Entity Framework 6 to Entity Framework Core 2.0


Tag : chash , By : Anonymous
Date : March 29 2020, 07:55 AM
around this issue
In EF Core 2.0 the Car model changes because of the need to specify the CarOwner foreign key in the Model as a nullable integer property
public class CarConfiguration : IEntityTypeConfiguration<Car>
{
    public void Configure(EntityTypeBuilder<Car> builder)
    {
        builder.HasKey(a => a.Id);
        builder.Property(a => a.Id).ValueGeneratedOnAdd().IsRequired();
        builder.HasOne(x => x.CarOwner)
            .WithMany(x => x.Cars)
            .HasForeignKey("CarOwner_Id") // <--
            .IsRequired(false);
    }
}

public class CarOwnerConfiguration : IEntityTypeConfiguration<CarOwner>
{
    public void Configure(EntityTypeBuilder<CarOwner> builder)
    {
        builder.HasKey(a => a.Id);
        builder.Property(a => a.Id).ValueGeneratedOnAdd().IsRequired();
    }
}
modelBuilder.Entity<Car>()
    .HasOne(x => x.CarOwner)
    .WithMany(x => x.Cars)
    .HasForeignKey("CarOwner_Id");

Cannot use Entity Framework in .NET standard 2 project


Tag : chash , By : Murali Ravipudi
Date : March 29 2020, 07:55 AM
it helps some times It looks like the actual question is "How can I create models and reverse engineer a database using EF Core like I could with EF 6" ?
The tooling is separate from the NuGet package. Visual Studio 2017 doesn't include modelling or reverse engineer tools for EF Core. Those are available through EF Core Power Tools an open source addon. You can find the code and documentation here
Related Posts Related QUESTIONS :
  • How to require a property using JsonSchema.NET?
  • C# XDocument Element/Elements returns null
  • Autofac keyed service with IEnumerable relationship type
  • Installing EntityFramework via NuGet manager
  • Always Check if there is Internet Connection Xamarin forms
  • WCF OneWay service slows down when aspNetCompatibilityEnabled is set to false
  • Can we use JsonRequestBehavior.AllowGet with [HttpPost] attribute?
  • How to customize the Setup wizard with custom forms in Visual Studio setup project
  • C# ASP.NET - Use method from another class to create labels
  • C# List IList or IEnumerable as argument
  • Parsing File with C# And Replace method
  • Losing special unicode characters in encryption (C#)
  • Getting stored procedure returned value instead of row affected
  • How can I construct HTML using NameValuePair in android?
  • Loading a pop up page in ASP.net through a js file
  • How to pass alert or notification message from controller to View?
  • C# to pause, turn on ssas server, backup cube.... how to?
  • How to execute DataTable.Select() for a column of custom class type for a particular element in that C#
  • how to connect mysql8.0 with C#
  • Passing incorrect values into MultiValueConverter by MultiBinding
  • Can i use IEnumerator as Update func?
  • How to convert API Json response to C# Array?
  • Blazor Textfield Oninput User Typing Delay
  • Performing both layout and render transform results in wrong output
  • uwp beforetextchanged cursor moving in front of text
  • How to keep duplicates from a string[] exclude words from a List and print them out
  • .Net Core Strings.Asc/Mid/Chr/Len missing even after importing Microsoft.VisualBasic
  • How to return to previous search page without being asked to Confirm Form Re-submission and keeping the results on ASP.N
  • How set a identity scaffolding item/page how initial page in asp.net MVC core?
  • LINQ isn't calling Dispose on my IEnumerator when using Union and Select, expected behavior or bug?
  • What is "ByteArray.uncompress()" in AS3 equivalent to in C#?
  • Getting a specific letter from a string variable for my simple guessing game for clues
  • Send an email with Outlook without a subject --- dialog box issue
  • passing List<MyModel> from my controller in the "WebInterfaceProject" to the processor method in "D
  • How to convert Word document created from template by OpenXML into MemoryStream?
  • How can I make a single slider that changes the color of an object?
  • Remap JSON parameter in c#
  • What is the difference between "this ref" and "ref this" when talking about C# 7.2 ref extension met
  • Convert OpenSSL encryption into native C#
  • Accessing Properties in Razor Pages
  • How to get SOAP element value
  • Projection after Group
  • C# error cannot convert sytem.text.regularexpressions.match to string
  • Issues with Save/Load System in a Text Based Adventure game made with ScriptableObjects in Unity
  • VS2019 MSBuild.exe - ASP .Net MVC project fails to publish when using PublishProfile, but works when using OutDir parame
  • Does <pages validateRequest="false" /> in Web.config still matter?
  • How to send new request to redirect URL with new access token
  • Attempt to invoke virtual method on a null object reference Xamarin LockScreen
  • "The attribute names could not be inferred from bind attribute 'bind-value'" exception in Blazor
  • How to fix ''System.ArgumentException" in c#?
  • C#. Ref returning delegate for ref extension method
  • Swashbuckle Swagger generate an actual guid
  • Trying to make thousands of database calls simultaneously - they stack instead of running concurently
  • run mstest from cmd using testcontainer
  • How to make M:N (many-to-many) relationship where both M and N are the same entities?
  • Consume COM DLL from multiple clients
  • Convert json string response representing UCHAR array to Byte array
  • Why does this LinqPad program produce different results on the second run?
  • ServiceStack how to use MaxLoginAttempts feature
  • What does "late-bound access to the destination object" mean?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com