[GH-ISSUE #88] Chinese sentences in error info / ORM library #1990

Closed
opened 2026-03-01 17:16:38 +03:00 by kerem · 4 comments
Owner

Originally created by @majkinetor on GitHub (Feb 20, 2021).
Original GitHub issue: https://github.com/1Remote/1Remote/issues/88

Originally assigned to: @VShawn on GitHub.

English should be the only allowed language in entire project.

## Error Info
【主库】状态不可用,等待后台检查程序恢复方可使用。连接字符串错误,或者检查项目属性 > 生成 > 目标平台:x86 | x64

Mentioned on #85, this is due to FreeSql ORM

github.com/dotnetcore/FreeSql@c12c552352/Providers/FreeSql.Provider.Sqlite/SqliteAdo/SqliteConnectionPool.cs (L193)

Originally created by @majkinetor on GitHub (Feb 20, 2021). Original GitHub issue: https://github.com/1Remote/1Remote/issues/88 Originally assigned to: @VShawn on GitHub. English should be the only allowed language in entire project. ``` ## Error Info 【主库】状态不可用,等待后台检查程序恢复方可使用。连接字符串错误,或者检查项目属性 > 生成 > 目标平台:x86 | x64 ``` Mentioned on #85, this is due to FreeSql ORM https://github.com/dotnetcore/FreeSql/blob/c12c5523525818abaa05b03d2dfd6ae70b6e7964/Providers/FreeSql.Provider.Sqlite/SqliteAdo/SqliteConnectionPool.cs#L193
kerem 2026-03-01 17:16:38 +03:00
Author
Owner

@majkinetor commented on GitHub (Feb 20, 2021):

Daper is minimal ORM: https://stackexchange.github.io/Dapper/

We tested it extensively and it works great with only around 20% slowdown compared to direct access. There are few limitations but nothing serious and it obviously is recommended by MS.

<!-- gh-comment-id:782595548 --> @majkinetor commented on GitHub (Feb 20, 2021): Daper is minimal ORM: https://stackexchange.github.io/Dapper/ We tested it extensively and it works great with only around 20% slowdown compared to direct access. There are few [limitations](https://docs.microsoft.com/en-us/dotnet/standard/data/sqlite/dapper-limitations) but nothing serious and it obviously is recommended by MS.
Author
Owner

@VShawn commented on GitHub (Feb 27, 2021):

question, can Daper auto update table structure when I add new properties to the model?

freesql can auto sync structure when the model change.

github.com/VShawn/PRemoteM@a64edac606/PRM.Core/DB/freesql/FreeSqlDb.cs (L75-L80)

<!-- gh-comment-id:786988585 --> @VShawn commented on GitHub (Feb 27, 2021): question, can Daper auto update table structure when I add new properties to the model? freesql can auto sync structure when the model change. https://github.com/VShawn/PRemoteM/blob/a64edac60627a21abc993f4918289982dbb7e8cf/PRM.Core/DB/freesql/FreeSqlDb.cs#L75-L80
Author
Owner

@majkinetor commented on GitHub (Feb 27, 2021):

As far as I know, no.

In my projects we use entity framework only for that (just DDL, not even seeding data, Powershell does that) and dapper for everything else, and also do it externally. Entity can autodoit via the code similar to what you show. We have a db model project that the main project depends on for models and create and apply db migrations within it with one command. Making this work OTB is like ... 10 minutes work ? We also use it to reset migrations later. Devs can then use it fom VS itself or via CLI. Here is entire CLI code for that for example (code first approach)


image

Like I said, dapper is minimal ORM with performance in mind and doesn't have all bells and whistles. This is not database heavy project, quite contrary. I don't think that is a deal breaker and you can go with proposed alternative that will not bloat main project if you want to go that route.

<!-- gh-comment-id:787029567 --> @majkinetor commented on GitHub (Feb 27, 2021): As far as I know, no. In my projects we use entity framework only for that (just DDL, not even seeding data, Powershell does that) and dapper for everything else, and also do it externally. Entity can autodoit via the code similar to what you show. We have a db model project that the main project depends on for models and create and apply db migrations within it with one command. Making this work OTB is like ... 10 minutes work ? We also use it to reset migrations later. Devs can then use it fom VS itself or via CLI. Here is entire CLI code for that for example (code first approach)<details> ![image](https://user-images.githubusercontent.com/85767/109378766-fcad4a80-7889-11eb-9c5f-e18bb4e96771.png) </details> Like I said, dapper is minimal ORM with performance in mind and doesn't have all bells and whistles. This is not database heavy project, quite contrary. I don't think that is a deal breaker and you can go with proposed alternative that will not bloat main project if you want to go that route.
Author
Owner

@majkinetor commented on GitHub (Mar 17, 2021):

Nice, I see u are using dapper now :)

This is nice info :)

<!-- gh-comment-id:800997354 --> @majkinetor commented on GitHub (Mar 17, 2021): Nice, I see u are using dapper now :) This is [nice info](https://stackexchange.com/performance) :)
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/1Remote#1990
No description provided.