Why does DB2 put my UserId from the connection string as my table name?
I'm trying to us Entity Framework Core to query my DB2 database. Here's how I register it:
services.AddDbContext<DB2Contexte>(options =>
options.UseDb2(Configuration.GetConnectionString("DB2"),
builder =>
{
builder.SetServerInfo(IBMDBServerType.AS400, IBMDBServerVersion.AS400_07_01);
builder.UseRowNumberForPaging();
builder.MaxBatchSize(1);
}));
That's the class the is use as a DbSet:
And there's my connection string:
Server=something;UserID=U_SERVTI;Password=something;Database=something; LibraryList=something;CurrentFunctionPath=*LIBL
Than when I try to query the database using simple LINQ:
_dbContext.PersonneRessource.FirstOrDefault()
I get this error:
ERROR [42704] [IBM][AS] SQL0204N "U_SERVTI.DX37PERE" is an undefined name.
Why is the UserId in the name? Shouldn't it just query the table and leave out the UserID?
I use IBM.EntityFrameworkCore-lnx version 3.1.0.500.
Db2 for IBM i, for historical reasons, supports two naming conventions; SYS and SQL.
By default, external connections will use SQL naming and like the rest of the Db2 family, unqualified table references will be implicitly qualified with the "run-time authorization identifier"; normally the user id used to connect.
With SYS naming, unqualified table references are qualified with *LIBL and the library list is used to find the table.
On your connection string, you're going to want to add Naming=SYS (or maybe Naming=*SYS )
Note that SYS vs. SQL naming affects just about every unqualified reference. Be sure to look at the documentation.
- How do I separate SQL from code while using parametrised queries?
- EF Core: Add custom LINQ in Up method of Migration class
- EF Core 8 code-first : join entity with custom differentiation property
- Does EF optimize projections to named types like it does for anonymous types?
- LINQ to SQLite could not be translated but works on SQL Server
- EF Core 8 does not merge entities
- How do I run EF Core ExecuteUpdateAsync and add a new entity as part of that update?
- Should EFCore migrations be committed to version control?
- EF Core one-to-one relation returns one-to-many relation
- Change the default name of EF Core generated join columns
- Entity Framework Core 8.0.6 Isn't Generating Properly Model Throught Foreing Key
- EF Core disconnected update of collection navigation properties via full replacement
- ASP.NET Entity Framework Core - one-to-many relationship foreign key constraint blocking PUT request
- How to transform "Types" a List<string> foo class property into a SQL Server table [Types](FooID int, name nvarchar) with Entity Framework Core
- ef core unique constraint for 2 different entities
- What is the culprit? Singleton failure with WebApplicationFactory
- Blazor two-way binding with readonly data types
- Exception when trying to make a dynamic database call
- Return entity and its parent (if exists)
- Optional table splitting in Entity Framework Core
- Including navigation properties in EF Core when calling a stored procedure
- Can I generate script of a migration with EF code first and .net core
- Avoid or control circular references in Entity Framework Core
- A Possible Object Cycle was detected error
- EF Core 8: execute a query and map it to a non-entity
- ef core doesn't use ASPNETCORE_ENVIRONMENT during update-database
- How to select distinct items from table by a variable and then join another table in LINQ
- Why do I get the SpecialityName as null here?
- 'no such table: Blog' -error while table "Blog" does exist
- Complex queries in Entity Framework Core