File Upload feature request

[bgiromini]

The general idea is I have a file (excel or CSV if need be) and I can upload it and the records will automatically be inserted into a db table with matching columns. Use case is your users need to mass upload data into the database to be used for whatever reason. Similar to the AutoQuery CRUD Api, you would decorate a class with an interface like IUploadDB:

public class CreateRockstar : IUploadDb<Rockstar>, IReturn<CreateRockstarResponse> 
{
 public Int CustomerId{get;set;}
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public int? Age { get; set; }
    public DateTime DateOfBirth { get; set; }
}

Validation, etc would work the same way. For instance, every line requires a CustomerId, even better if we could provide some method that would validate the CustomerId is validate for our use case. This is a very common practice in our line of business where users need to upload data in a specific format, we validate it and then insert into some table to do mass updates against our ERP system. This way we could create the entire workflow in a much faster manner, wire up a ui to an file upload component, and then focus on the difficult details and not the upload pipeline of getting the data into our system.

[mythz]

This couldn't be a generic feature that could be declaratively defined, it requires far too much bespoke and opinionated behavior and custom validation that only one generic solution could be able to cater for.

It wouldn't be an AutoQuery API, just a custom API that reads the uploaded file in Request.Files[0] before attempting the import which you might want to do with OrmLite's Bulk Inserts.

We also have Auto Batched Requests where you should be able to send a batch of AutoQuery Create DTOs in a single request where it would execute them one-by-one:

var requests = [
  new CreateRockstar { ... },
  new CreateRockstar { ... },
]
var responses = client.SendAll(rockstars);