Code: Select all
ctx.Users.Where(z => z.Userid == "abc").Count();
Code: Select all
SELECT COUNT(*)
FROM USERS "z"
WHERE "z".USERID LIKE 'abc'
Code: Select all
ctx.Users.Where(z => z.Userid == "abc").Count();
Code: Select all
SELECT COUNT(*)
FROM USERS "z"
WHERE "z".USERID LIKE 'abc'
Code: Select all
modelBuilder.Entity<User>().Property<string>(x => x.USERID).HasColumnName(@"USERID").HasColumnType(@"NVARCHAR2").IsRequired().ValueGeneratedNever().HasMaxLength(50);
Code: Select all
modelBuilder.Entity<User>().Property<string>(x => x.USERID).HasColumnName(@"USERID").IsRequired().ValueGeneratedNever();
modelBuilder.Entity<User>().HasKey(@"USERID");
Code: Select all
SELECT COUNT(*)
FROM C##SCOTT."user" "z"
WHERE "z".USERID = N'abc'
Code: Select all
modelBuilder.Entity<User>().Property<string>(x => x.USERID).HasColumnName(@"USERID").IsRequired().ValueGeneratedNever();
modelBuilder.Entity<User>().HasKey(@"other_than_USERID_column");
Code: Select all
SELECT COUNT(*)
FROM C##SCOTT."user" "z"
WHERE "z".USERID LIKE 'abc'
We will investigate the question and notify you about the result.Wain123 wrote:That fixes my issue with the Userid, but what should I do with columns that are actual CLOBs? Using "like" gives me wrong results when the string contains a '%'.