This is the official open channel for RepoDb (.NET) Hybrid ORM Library. This channel will allow the community of .NET to have a fast and efficient way of communication in relation to RepoDb, useful to address the community needs (i.e.: Questions, Issues, Recommendations, Proposals, etc).
System.Exception: DataAccessError
"Failed to load: Can't write CLR type System.DateTime with handler type TextHandler"
at Domain.Location.Queries.SuburbDeltaQuery.clo@81-51.Invoke(IEnumerable`1 msgs) in /Users/swoorup.joshi/work/worktree/gp-suburb-api-2/src/Domain.Location.Queries/SuburbDeltaQuery.fs:line 81
at Domain.Location.Queries.SuburbDeltaQuery.clo@81-53.Invoke(FSharpList`1 arg00) in /Users/swoorup.joshi/work/worktree/gp-suburb-api-2/src/Domain.Location.Queries/SuburbDeltaQuery.fs:line 81
at FsToolkit.ErrorHandling.Result.fold[a,b,c](FSharpFunc`2 onOk, FSharpFunc`2 onError, FSharpResult`2 r)
at Domain.Location.Queries.SuburbDeltaQuery.SuburbDeltaQuery.getDeltasBetweenTwoDates(DateTime startDate, DateTime endDate) in /Users/swoorup.joshi/work/worktree/gp-suburb-api-2/src/Domain.Location.Queries/SuburbDeltaQuery.fs:line 80type EventReadEntity =
{ id: Guid
position: int64
correlation_id: Guid
causation_id: Guid
stream_key: string
version: int
name: string
[<NpgsqlTypeMap(NpgsqlDbType.Jsonb)>]
payload: string
[<NpgsqlTypeMap(NpgsqlDbType.Jsonb)>]
metadata: string
schema_revision: int
[<NpgsqlTypeMap(NpgsqlDbType.TimestampTz)>]
timestamp: DateTime }
@Swoorup
do you know how RepoDb deals with OOM exceptions? does it rethrow exceptions if it can’t be handled.
You have such question that I had not answered, I had overlooked it. RepoDB does not have any try-catch in the code line, except for DbRepository which is only uses the try-finally to ensure the disposal of connection in an ConnectionPersistency.PerCall situation.
Meaning, it has no any error handling and every error will be bubble up to the consumers. Therefore, all exceptions you will get is raw seen from my chair.
Good evening,
First of all sorry for my bad English.
I post here hoping someone can help me :).
I am a junior dotnet developer and I recently discovered RepoDb.
I used at first Entity Framework then Dapper.
I mostly use postgresql in my development because I like this sgbd very much.
So I use repodb with the postgres library.
I currently have two problems in a new api:
are there data annotations like in Dapper or EF to indicate that the field is managed in a database?
(To be ignored when inserting and updating).with DateTimeOffset properties and timestamp with timezone columns I get the following error message:
"Npgsql.PostgresException (0x80004005): 42804: column "created_at" is of type timestamp with time zone but expression is of type text
at Npgsql.NpgsqlConnector.<>cDisplayClass160_0.<<DoReadMessage>gReadMessageLong|0>d.MoveNext()"
I tried to settle the prob with these but without success.FluentMapper .Entity<User>() .Table("public.user") .Primary(c => c.Id) .Column(c => c.Id, "id") .Column(c => c.Ulid, "ulid") .Column(c => c.Firstname, "firstname") .Column(c => c.Lastname, "lastname") .Column(c => c.CreatedAt, "created_at") .Column(c => c.UpdatedAt, "updated_at") .DbType(c => c.CreatedAt, DbType.DateTimeOffset) .DbType(c => c.UpdatedAt, DbType.DateTimeOffset); FluentMapper .Type<DateTimeOffset>() // Define which .NET CLR type .DbType(DbType.DateTimeOffset); // Defines the DatabaseType of the .NET CLR typeFinally for the db update, I would like to update only the modified properties of the entity. (entity patch request sent from the api controller).
I think I'll use the cache of the getAll method for example, check the equality of the 2 objects with the Equals and Gethascode methods and then do some reflection to add the modified properties in a field object.
What do you think about it ? Is there an easier way to do it ?
Thank you in advance for your precious answers.
Jordan