Is there any sample code out there implementing a sequential order number generator? I'm particularly looking for code which could create a custom table on demand and then load and save a single record.
I guess this question could also be "how to do custom database access from Vendr".
I think for the DB lookups, I might be tempted to run raw SQL commands to keep things as fast as possible, but if you know the site won't be under a lot of preasure, you could use NPoco for that too.
I have implemented a sequential order number generator using code in the link you gave me. This will serve our purpose for the time being (migrating from TeaCommerce). Maybe one day we will have enough business for this generator to become a performance bottleneck, and will then review and maybe revert to Vendr's built in solution :-)
Implementing a sequential order number generator
Is there any sample code out there implementing a sequential order number generator? I'm particularly looking for code which could create a custom table on demand and then load and save a single record.
I guess this question could also be "how to do custom database access from Vendr".
Disclaimer, I have read https://our.umbraco.com/packages/website-utilities/vendr/vendr-support/102060-changing-order-number-format and understand this.
Hi Tor,
I don't have any specific code, but you could use Umbraco migrations to setup the database table (maybe take a look at https://docs.umbraco.com/umbraco-cms/extending/database)
I think for the DB lookups, I might be tempted to run raw SQL commands to keep things as fast as possible, but if you know the site won't be under a lot of preasure, you could use NPoco for that too.
Hope this helps a little
Thanks Matt!
I have implemented a sequential order number generator using code in the link you gave me. This will serve our purpose for the time being (migrating from TeaCommerce). Maybe one day we will have enough business for this generator to become a performance bottleneck, and will then review and maybe revert to Vendr's built in solution :-)
is working on a reply...