❔ Mixing EF Core and another SQL library - C#

barcode

B

barcodeOP•2/8/23, 11:16 PM

I checked ADO.NET and it seems like what I'm looking for, is it a bad idea to have multiple db libs like this?

Angius

A

Angius•2/8/23, 11:17 PM

Dapper if anything

Angius

A

Angius•2/8/23, 11:17 PM

But EF does let you execute raw queries

Angius

AAngius Dapper if anything

barcode

B

barcodeOP•2/8/23, 11:18 PM

I saw Database.SqlQuery but it doesn't let me return objects

barcode

B

barcodeOP•2/8/23, 11:18 PM

only 1 scalar value

barcode

B

barcodeOP•2/8/23, 11:18 PM

as it says on docs

barcode

B

barcodeOP•2/8/23, 11:18 PM

Is there another way?

Angius

A

Angius•2/8/23, 11:20 PM

https://learn.microsoft.com/en-us/ef/core/modeling/keyless-entity-types?tabs=fluent-api

Keyless Entity Types - EF Core

How to configure keyless entity types using Entity Framework Core

Angius

A

Angius•2/8/23, 11:20 PM

keyless entities

Angius

AAngius https://learn.microsoft.com/en-us/ef/core/modeling/keyless-entity-types?tabs=flu...

barcode

B

barcodeOP•2/8/23, 11:22 PM

thx

Angius

AAngius https://learn.microsoft.com/en-us/ef/core/modeling/keyless-entity-types?tabs=flu...

barcode

B

barcodeOP•2/8/23, 11:39 PM

Hmm seems like [Keyless] creates the table, is this intended behavior?

Angius

A

Angius•2/8/23, 11:39 PM

It shouldn't be creating one

barcode

B

barcodeOP•2/8/23, 11:46 PM

seems like adding Keyless annotation did nothing,

this is the result I get in my modelsnapshot and this is from msdn

barcode

B

barcodeOP•2/9/23, 12:06 AM

seems like this issue exists for a while.. found github issues from 2018-2022

Angius

A

Angius•2/9/23, 12:09 AM

I guess it creates a view, then, huh

Angius

A

Angius•2/9/23, 12:09 AM

I'd say go with Dapper, then

Angius

AAngius I'd say go with Dapper, then

barcode

B

barcodeOP•2/9/23, 12:47 AM

is it ok to mix ef core and dapper? no possible issues to arise?

Angius

A

Angius•2/9/23, 12:48 AM

Ideally, don't use them to query for the same things, but it should be fine

barcode

B

barcodeOP•2/9/23, 12:49 AM

ty, using ef core to get and update 'simple' queries but I have some 60 liners that dapper will handle

barcode

B

barcodeOP•2/9/23, 1:13 AM

dapper works, gonna use it for selection and EF core for everything else, just feels wrong having 2 orms

BananaPie

B

BananaPie•2/9/23, 1:32 AM

I used 2 ORMs back in the old EF 4~6 days. The old EF was pretty slow on large reads. So I used dapper for that and EF for updating.

barcode

B

barcodeOP•2/9/23, 2:10 AM

ty for info

Accord

A

Accord•2/10/23, 2:22 AM

Was this issue resolved? If so, run

/close

/close

otherwise I will mark this as stale and this post will be archived until there is new activity.

         modelBuilder.Entity("rgm_api.Models.Keyless.Lala", b =>
                {
                    b.Property<uint>("Lala1")
                        .HasColumnType("int unsigned");

                    b.Property<string>("Lala2")
                        .IsRequired()
                        .HasColumnType("longtext");

                    b.ToTable("Lalas");
                });

         modelBuilder.Entity("rgm_api.Models.Keyless.Lala", b =>
                {
                    b.Property<uint>("Lala1")
                        .HasColumnType("int unsigned");

                    b.Property<string>("Lala2")
                        .IsRequired()
                        .HasColumnType("longtext");

                    b.ToTable("Lalas");
                });

   modelBuilder
        .Entity<BlogPostsCount>(
            eb =>
            {
                eb.HasNoKey();
                eb.ToView("View_BlogPostCounts");
                eb.Property(v => v.BlogName).HasColumnName("Name");
            });

   modelBuilder
        .Entity<BlogPostsCount>(
            eb =>
            {
                eb.HasNoKey();
                eb.ToView("View_BlogPostCounts");
                eb.Property(v => v.BlogName).HasColumnName("Name");
            });