{"catalogRevision":"cat_f13ab9a494120b5e","recipeId":"page:recipes:csv-import-tool:asp-net-core:relational-workflow","recipeRevision":"r1","canonicalPath":"/recipes/csv-import-tool/asp-net-core/relational-workflow","label":"Host csv import tool with ASP.NET Core: relational workflow state","family":"Workload recipe","summary":"Deploy a csv import tool built with ASP.NET Core on Ample using the transactional workflows pattern. Compute runs the app in an isolated microVM behind a public HTTPS URL, a managed PostgreSQL 16 database is auto-provisioned and injected as DATABASE_URL. Verified on ASP.NET Core: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected). Not separately tested: your domain records, validation rules and concurrency policy; treat the csv import tool-specific behavior as your application code.","representativeQueries":["Host csv import tool with ASP.NET Core: relational workflow state","Where can I host CSV import tool built with ASP.NET Core?","I need a domain record schema, validation rules and concurrency behavior."],"breadcrumbIds":["discovery","workload","workload:scheduling-and-data","workload:csv-import-tool","page:recipes:csv-import-tool:asp-net-core:relational-workflow"],"breadcrumbs":[{"id":"discovery","label":"Agent hosting discovery","canonicalPath":"/discover/discovery","kind":"root"},{"id":"workload","label":"Applications and workloads","canonicalPath":"/discover/workload","kind":"facet"},{"id":"workload:scheduling-and-data","label":"Scheduling and data","canonicalPath":"/discover/workload/scheduling-and-data","kind":"group"},{"id":"workload:csv-import-tool","label":"CSV import tool","canonicalPath":"/discover/workload/csv-import-tool","kind":"atom"},{"id":"page:recipes:csv-import-tool:asp-net-core:relational-workflow","label":"Host csv import tool with ASP.NET Core: relational workflow state","canonicalPath":"/recipes/csv-import-tool/asp-net-core/relational-workflow","kind":"recipe"}],"parentIds":["workload:csv-import-tool","stack:framework-asp-net-core","pattern:transactional-workflows","intent:deploy-web-app"],"parents":[{"id":"workload:csv-import-tool","label":"CSV import tool","canonicalPath":"/discover/workload/csv-import-tool","kind":"atom"},{"id":"stack:framework-asp-net-core","label":"ASP.NET Core","canonicalPath":"/discover/stack/framework-asp-net-core","kind":"atom"},{"id":"pattern:transactional-workflows","label":"Transactional workflows","canonicalPath":"/discover/pattern/transactional-workflows","kind":"atom"},{"id":"intent:deploy-web-app","label":"Deploy web app","canonicalPath":"/discover/intent/deploy-web-app","kind":"atom"}],"resourceRequirements":["primitive:compute","primitive:postgres"],"infrastructureRequirements":[{"primitiveId":"primitive:compute","label":"Compute","canonicalPath":"/discover/primitive/compute","status":"verified","summary":"Apps run in isolated x86_64 Firecracker microVMs that auto-pause when idle and wake on request; sizes are the priced VM sizes."},{"primitiveId":"primitive:postgres","label":"Postgres","canonicalPath":"/discover/primitive/postgres","status":"verified","summary":"Managed PostgreSQL 16 runs in its own microVM and is auto-provisioned when an app needs a database and no DATABASE_URL is supplied."}],"framework":"ASP.NET Core","workload":"CSV import tool","releaseStatus":"published","supportStatus":"verified","executionStatus":"ready","docsOnly":false,"prerequisites":["An ASP.NET Core project that builds and starts with the documented commands (dotnet publish -c Release -o out in the builder, then dotnet <entry>.dll on the dotnet-10 template with ASPNETCORE_URLS bound to PORT)","A PostgreSQL driver reading DATABASE_URL at runtime (auto-provisioned when omitted, or supplied with --env)","An Ample account token with servers:write, databases:read"],"testedConfiguration":{"template":"dotnet-10","runtime":"dotnet","size":"s-1vcpu-1gb","build":"dotnet publish -c Release -o out","start":"ASPNETCORE_URLS=http://0.0.0.0:$PORT dotnet out/$(basename $(ls out/*.runtimeconfig.json | head -n 1) .runtimeconfig.json).dll"},"inputSchema":{"additionalProperties":false,"properties":{"env":{"description":"Encrypted environment variables (bucket credentials, secrets)","items":{"pattern":"^[A-Z][A-Z0-9_]*=.*$","type":"string"},"maxItems":50,"type":"array"},"name":{"description":"App name","maxLength":63,"minLength":1,"pattern":"^[a-z0-9-]+$","type":"string"},"path":{"description":"Project directory or ample.toml service","maxLength":512,"minLength":1,"type":"string"},"release_command":{"description":"Migration command run before activation","maxLength":512,"type":"string"}},"required":["name","path"],"type":"object"},"outputSchema":null,"workflowSteps":[{"title":"Build and start","body":"dotnet publish -c Release -o out in the builder, then dotnet <entry>.dll on the dotnet-10 template with ASPNETCORE_URLS bound to PORT. The server must bind 0.0.0.0 on PORT."},{"title":"Implement the pattern on PostgreSQL","body":"The fixture's module implements transactional workflows: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected). Copy the approach into your schema; keep migrations idempotent and run them with --release-command."},{"title":"Deploy","body":"Run the synchronous deploy once and read the result (exit 0 live, 1 failed, 2 blocked). Re-running with no change is a no-op.","command":"ample deploy . --name <app-name> --public"},{"title":"Verify","body":"Fetch the live URL and the pattern self-test route(s) (/p/transactional-workflows) from the example; then run your own checks. On failure read `ample logs <deployment_id> --kind build` then `--kind runtime`.","command":"ample logs <deployment_id> --kind build"}],"examples":[{"title":"ASP.NET Core pattern fixture","description":"Multi-pattern ASP.NET Core app whose transactional workflows module was checked live; the module is under tests/deploy-canaries/_pattern-modules.","sourceRef":"tests/deploy-canaries/asp-net-core-patterns"}],"successChecks":[{"description":"app responds on its public URL","kind":"http_get","path":"/","expect":"ample canary asp net core patterns"},{"description":"transactional-workflows self-test","kind":"http_get","path":"/p/transactional-workflows","expect":"tx=ok history=2 conflict=rejected"}],"limitations":["Verified on the dotnet-10 template at s-1vcpu-1gb with the example fixture; other sizes, templates and ASP.NET Core major versions are not verified.","The csv import tool itself (your domain records, validation rules and concurrency policy) is application code and was not separately tested; the pattern checks are what was verified.","Region, compliance attestations and request-duration limits are unknown and not claimed.","Apps auto-pause when idle and wake on the next request; always-on is an operator setting, not a plan feature.","Managed PostgreSQL 16 only; extensions, connection limits and backup or restore procedures are not verified; apps and their databases are placed together."],"costEstimate":{"currency":"USD","monthlyAmount":10.0,"authoritative":true,"basis":"size prices from pricing.toml (loaded by the API) at build revision 8c2bc240db59dd421050b971318ffa57d28ea3ec","components":[{"name":"app server","size":"s-1vcpu-1gb","quantity":1.0,"monthlyAmount":5.0},{"name":"managed PostgreSQL database","size":"s-1vcpu-1gb","quantity":1.0,"monthlyAmount":5.0}],"note":"Always-on monthly price of the tested sizes; apps and databases auto-pause when idle. Buckets are allocation-priced per quota and not included."},"evidenceSummary":[{"kind":"canary_run","summary":"ASP.NET Core pattern fixture deployed on Ample (dotnet publish -c Release -o out in the builder, then dotnet <entry>.dll on the dotnet-10 template with ASPNETCORE_URLS bound to PORT); checks passed for transactional-workflows and configuration-secrets. Pattern proof: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected).","observedAt":"2026-09-21T01:15:54Z","implementationRevision":"50dbac567d2c5cc8e55e6c748a646be0025d9cfb (CLI 0.1.21)","expiresAt":"2027-03-20T01:15:54Z","scope":{"checks":["/p/transactional-workflows"],"pattern":"pattern:transactional-workflows","template":"dotnet-10"}},{"kind":"canary_run","summary":"The same ASP.NET Core app deployed with a --release-command migration; the marker it created was readable after activation.","observedAt":"2026-09-20T23:34:47Z","implementationRevision":"4d1511e574302f3904b75088bd4048a0975218b3 (CLI 0.1.21)","expiresAt":"2027-03-19T23:34:47Z","scope":{"pattern":"pattern:transactional-workflows"}}],"lastVerifiedAt":"2026-09-21T01:15:54Z","mcpBinding":{"registryRef":"mcp:ample_deploy","toolName":"ample_deploy","schemaHash":"876465fce906da0c224d62961d3343064108ebe30af80cf1b87094974e948853","observedAt":"2026-09-22T00:31:22.774679+00:00","implementationRevision":"e6446ceea69b","requiredScopes":["servers:write","databases:read"],"bindingState":"current"},"unknowns":["region availability is unknown until a verified region fact is recorded","compliance attestations are unknown; none are claimed"],"formats":{"html":"https://ample.computer/recipes/csv-import-tool/asp-net-core/relational-workflow","markdown":"https://ample.computer/recipes/csv-import-tool/asp-net-core/relational-workflow.md","json":"https://api.ample.computer/v1/catalog/recipes/page%3Arecipes%3Acsv-import-tool%3Aasp-net-core%3Arelational-workflow"},"nextActions":[{"actionId":"browse-catalog","label":"Browse the catalog index","operationId":"catalog_index","method":"GET","relativePath":"/v1/catalog","origin":"api","parameters":{},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"search-recipes","label":"Search published recipes by intent, stack and constraints","operationId":"search_recipes","method":"POST","relativePath":"/v1/catalog/search","origin":"api","parameters":{"body":{"limit":5,"query":"Host csv import tool with ASP.NET Core: relational workflow state"}},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"plan:page:recipes:csv-import-tool:asp-net-core:relational-workflow","label":"Prepare a side-effect-free deployment plan for an authorized project","operationId":"plan_deployment","method":"POST","relativePath":"/v1/catalog/plan","origin":"api","parameters":{"body":{"inputs":{},"projectId":"<workspace or server id you own>","recipeId":"page:recipes:csv-import-tool:asp-net-core:relational-workflow","recipeRevision":"r1"}},"requiresAuthentication":true,"requiresApproval":false},{"actionId":"auth-setup","label":"Read the existing agent authentication setup","operationId":"existing_auth_setup","method":"GET","relativePath":"/mcp/setup","origin":"api","parameters":{},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"browse:workload:csv-import-tool","label":"Browse CSV import tool","operationId":"browse_node","method":"GET","relativePath":"/v1/catalog/nodes/workload%3Acsv-import-tool","origin":"api","parameters":{"nodeId":"workload:csv-import-tool"},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"browse:stack:framework-asp-net-core","label":"Browse ASP.NET Core","operationId":"browse_node","method":"GET","relativePath":"/v1/catalog/nodes/stack%3Aframework-asp-net-core","origin":"api","parameters":{"nodeId":"stack:framework-asp-net-core"},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"browse:pattern:transactional-workflows","label":"Browse Transactional workflows","operationId":"browse_node","method":"GET","relativePath":"/v1/catalog/nodes/pattern%3Atransactional-workflows","origin":"api","parameters":{"nodeId":"pattern:transactional-workflows"},"requiresAuthentication":false,"requiresApproval":false},{"actionId":"browse:intent:deploy-web-app","label":"Browse Deploy web app","operationId":"browse_node","method":"GET","relativePath":"/v1/catalog/nodes/intent%3Adeploy-web-app","origin":"api","parameters":{"nodeId":"intent:deploy-web-app"},"requiresAuthentication":false,"requiresApproval":false}]}