{"id":13499,"date":"2022-06-28T14:33:16","date_gmt":"2022-06-28T21:33:16","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=13499"},"modified":"2025-06-13T21:51:46","modified_gmt":"2025-06-14T04:51:46","slug":"asp-net-core-crud-nosql-part-4","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/asp-net-core-crud-nosql-part-4\/","title":{"rendered":"ASP.NET Core CRUD with NoSQL: Part 4"},"content":{"rendered":"

ASP.NET CRUD apps include interaction with data that consists of create, read, update, and delete. In <\/span>part 1<\/span><\/a>, we setup a basic ASP.NET Core project. In <\/span>part 2<\/span><\/a>, we added the first <\/span>read<\/span><\/i> endpoint, using a SQL++ query against wishlist data. In <\/span>part 3<\/span><\/a>, we added another read endpoint, this time using the key-value API.<\/span><\/p>\n

Until this point, the only data modifications we\u2019ve made have been directly in the Couchbase Capella UI. In this post, let\u2019s add an endpoint to handle creating and updating wishlist data.<\/span><\/p>\n

SQL++ vs Key-Value: Revisited<\/b><\/h2>\n

SQL++ includes <\/span>INSERT<\/span>, <\/span>UPDATE<\/span>, <\/span>DELETE<\/span><\/em> syntax. So, we could use SQL++ to build an endpoint for mutating data. It would be very similar to the code written in <\/span>part 2<\/span><\/a>.<\/span><\/p>\n

One keyword in SQL++ that you might not have seen before is <\/span>UPSERT<\/span><\/em>. As you might guess, it\u2019s a combination of <\/span>UPDATE<\/span><\/em> and <\/span>INSERT<\/span><\/em>.<\/em> An update will happen if the data already exists; an insert will happen if it doesn\u2019t. Here\u2019s how an upsert endpoint using SQL++ might look:<\/span><\/p>\n

[HttpPost]\r\n[Route(\"api\/editWithSql\")]\r\npublic async Task<IActionResult> CreateOrEditWithSql(WishlistItem item)\r\n{\r\n\u00a0 \u00a0 var bucket = await _bucketProvider.GetBucketAsync(\"demo\");\r\n\u00a0 \u00a0 var cluster = bucket.Cluster;\r\n\r\n\u00a0 \u00a0 var id = item.Id ?? Guid.NewGuid();\r\n\r\n\u00a0 \u00a0 var result = await cluster.QueryAsync<WishlistItem>(\r\n\u00a0 \u00a0 \u00a0 \u00a0 @\"UPSERT INTO demo._default.wishlist (KEY, VALUE)\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 VALUES ($id, { \"\"name\"\" : $name });\",\r\n\u00a0 \u00a0 \u00a0 \u00a0 options => options\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 .Parameter(\"id\", id)\r\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 .Parameter(\"name\", item.Name)\r\n\u00a0 \u00a0 );\r\n\r\n\u00a0 \u00a0 return Ok(result);\r\n}<\/pre>\n
Two important things to point out about this code:<\/span><\/p>\n