NPoco

NPoco copied to clipboard

multiple primary keys, one is autoIncrement -- is this possible?

1

... "It might, however I need to look at the implications of that...not just for Sql Server as well." _Originally posted by @schotime in https://github.com/schotime/NPoco/issues/1#issuecomment-9463816_

erict-powersoft

Combine ToPage with ProjectTo

2

Whilst making heavy use of ToPageAsync(), most of the time I only need a cut-down list of fields from the model. I use ProjectToAsync() in other places where I'm not...

PeterN

Correct bracket type used around nvarchar/varchar when formatting the command

2

The current formatting code puts brackets around varchar/nvarchar size instead of parenthesis

tbasallo

ORA-00933: SQL command not properly ended

6

oracle 19c and Oracle.ManagedDataAccess.Core 3.21.3, call InsertBatch throw exception "ORA-00933: SQL command not properly ended"

ikvm

For "legacy application" reasons our database primarily uses CHAR column types with a "Y" or "N" to represent boolean values. We created a `BooleanMapper` class that appropriately handles the conversion...

bryanboettcher

BulkCopyBatchSize added to insertBulkOptions

1

For tables with very few columns the default batchsize of 4096 rows is actually not a lot. Added the parameter, nothing else. Gives the end user a bit of extra...

IvoTops

C# DateOnly does not work with SQLServer date field

4

If a C# variable is defined as the new DateOnly type and the database column is Date using the column in a NPOCO Query will throw the error that the...

IvoTops

ExecuteScalar map strings to Guid

1

Commit f5e3d745ae026e81b373f7f57a5af3cacab9a0ac adds support for converting strings to guids, but only as part of an entity mapping. It would be useful to support this for ExecuteScalar too

mattbrailsford

With this update, rather than just trying to convert an ExecuteScalar result type using `Converter.ChangeType` it uses the mappers registered with the database to allow more fine grained conversions. This...

mattbrailsford

NPoco and Datetime Kind

3

Hi I am using NPoco (4.0.2) in an asp.net core website with Umbraco CMS 9. My poco has a Datetime property and before I insert it into the database I...

shearer3000