For a few of us, we are constrained with having to use mongodb or other nosql databases instead of an RDBMS.

It would be good if we have a some sort of native mongodb support or at least a few examples/patterns of how to go about a full mongodb/servicestack solution. I understand that we have examples of redis usage but, we do not have authentication and other similar aspects as examples.

Love the tooling still! yet hate to work with anything else now (you spoiled us!) that I have to work with mongodb.

Cheers!
-Simo

Support of HStores when using Dictionary<string,string> or as a new field attribute.

HStores (key values) are very good in certain scenarios (logging/auditing) and complex parsing is easier to do in .NET than in SQL.

Custom SQL that SELECT's data is easy, but not easy to insert/save hstore in custom sql.

Also Npgsql already supports them.

More info here:
https://forums.servicestack.net/t/cannot-insert-idictionary-string-string-into-hstore-column/6894

Trying to UpdateOnly, when onlyField is typed as SqlExpression and the query has a Join an error will be thrown that says "The multi-part identifier "DepartmentJobCode.DepartmentId" could not be bound."

Example:
var jobsQuery = _db.From<dev.ScheduleEvent>()
.Join<dev.DepartmentJobCode>((se,jc)=> se.Job == jc.JobTitleId)
.Where<dev.DepartmentJobCode>(e => Sql.In(e.DepartmentId, departments))
.Update(x => new { x.Published, x.ModifiedBy});
db.UpdateOnly(new dev.ScheduleEvent { Published = false, ModifiedBy = userId}, onlyFields: jobsQuery);

When an error occurs processing a batch of requests, the responses for the successful requests are lost. It would be helpful if these successful response are returned along with the error that stopped further processing.

1h
https://aws.amazon.com/blogs/aws/new-amazon-dynamodb-transactions/

Add Transactions to IPocoDynamo

I'd like to be able to incorporate my Cognito User Pool as an authentication and role provider.

At the moment, the *OAuth2 Providers for ServiceStack* library does not support .net core, as explained by mythz in this StackOverflow answer:

> ServiceStack's OAuth2 depends on DotNetOpenAuth which unfortunately doesn't support .NET Core so there's currently no support for OAuth2 - https://stackoverflow.com/a/42344183/969613

Google Authentication is a feature requirement on my current project, so this one thing is preventing us from moving to .net core, support for this would be great.

The AutoQuery plugin is great especially for use with many front end grids/tables, however it lacks the ability to Group By. Can you implement it to have feature parity to work with many of the front end grid components (ie kendo grid/devexpress/etc)?

Two Factor Authentication is a pretty standard thing nowadays, it even comes baked into the typical ASP.NET Core Identity system. It would be nice if Service Stack had this feature as well. We are working on porting a legacy application from ASP.NET to ServiceStack and this is a requirement for government applications (some form of TFA).

Right now, bools are serialized uppercase since that's the default ToString behavior of .NET.

Consider changing this behavior by checking for bool when serializing and using .ToString().ToLower(), or introduce a setting to control this. It's web standard to use lowercase bools in query strings.

More info/discussion:
https://github.com/ServiceStack/Issues/issues/586

In order to improve security it would be beneficial to change cookie names from const to a configurable option. It would help mask the presence of service stack and improve security in accordance with OWASP recommendations - https://www.owasp.org/index.php/Session_Management_Cheat_Sheet#Session_ID_Name_Fingerprinting

It would be a good idea for users when using Service Stack Authentication to have functionality like Asp.net Identity to Verify their account, reset their password.

The c# SDK is seriously lagging in documentation. By that I mean IntelliSense documentation: it would be awsome with some "in line" documentation for methods and properties in the SDK

I've just stumbled upon Facebook's GraphQL and it's pretty slick.
The ability to query a ServiceStack endpoint using GraphQL would be a great addition (maybe similar to AutoQuery?) If ORMLite could also populate an object graph using a GraphQL query...

Support to automatically update a db schema based on changes such as: adding/renaming and possibly removing a property or class.

Currently to send in an integer array as a parameter, I have to use format.

var ids = "ARRAY[1,2,3]";
var sql = "SELECT 1 = ANY[{0}]".Fmt(ids);
Db.Query<Model>(sql);

I would rather use syntax like this:
var ids = new int[] {1, 2, 3};
var sql = "SELECT 1 = ANY(@ids)";
Db.Query<Model>(sql, new { ids });

While being able to offload to statsd/graphite/raygun/... is great, a "state of the nation" dashboard would be really handy.

This could show requests/sec, wait times, "slow" requests, auth failures, live access map, recent exceptions, known issues (e.g. can't connect to redisX/mssqlY)

Currently Oracle is not a supported OrmLite provider that's listed on:
http://servicestack.net/download

Vote for this feature request if you would like to see the OrmLite Oracle provider officially supported.