Comments (3)
I also had some moments with a similar mistake:
public class Test
{
public virtual NpgsqlDateTime CreationDate { get; set; }
}
modelBuilder.Entity<Test>(
prop =>
{
...
prop.Property(t => t.CreationDate).IsRequired().HasColumnName("creation_date");
...
}
);
DB type:
creation_date timestamp without time zone NOT NULL DEFAULT now()
from efcore.pg.
This turned out to be related to npgsql/npgsql#1074, added some tests and hstore works almost perfectly.
Except when you attempt to put an hstore value in a where clause, in which case I ran into dotnet/efcore#5365.
from efcore.pg.
dotnet/efcore#5365 resolved in EFCore 1.0.0
from efcore.pg.
Related Issues (20)
- [Bug] Connection already open on Database.Migrate() HOT 2
- Migrations references actual enum types which break them HOT 4
- Npgsql.PostgresException:42601 : at or near "schemaname": syntax error. Detail redacted as it may contain sensitive data (Error getting while calling Stored procedure from .Net core 8.0 used Npgsql.EntityframeworkCore.PostgreSQL. HOT 2
- Updgrade from v6 -> v8. TimeZoneInfo.ConvertTimeBySystemTimeZoneId: No coercion operator is defined between types 'NodaTime.LocalDateTime' and 'System.Nullable`1[System.DateTime]' HOT 1
- InvalidCastException with Instant field (using NodaTime) when many database connections are open HOT 2
- Backward compatibility of SQL translation for DateTime.Date HOT 2
- Migration to .NET 8: Period Mapping and IServiceProvider Limit Issue HOT 4
- Migrations applied with one role and queries with another HOT 9
- Npgsql.PostgresException: '42883: function st_distance(point, geometry) does not exist HOT 4
- Cache issue HOT 3
- Error retrieving data when combining TPH and complex types
- Unable to Fetch Data from Stored Procedure with Cursor as return type and getting required column id was not present in the results of a "FromSql" operation.
- Implement migration locking
- Replace type reloading mechanism with the new EF migration extensibility mechanism
- DateOnly - en_GB date flipped from October to April. HOT 2
- LTree column type doens worked with migration
- Errors on mapping enum types to SQL and storing into database
- Is there way to translate EF Core query to WITH Queries (Common Table Expressions) ? HOT 3
- Select or filter Length of string contained in JsonB column
- Value Conversion Not Applied when using DbFunction in EF Core HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from efcore.pg.