{"id":11147,"date":"2021-05-27T08:01:06","date_gmt":"2021-05-27T15:01:06","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11147"},"modified":"2025-06-13T19:40:16","modified_gmt":"2025-06-14T02:40:16","slug":"sql-nosql-comparison-aspnet-application","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/sql-nosql-comparison-aspnet-application\/","title":{"rendered":"SQL\uacfc NoSQL \ube44\uad50: ASP.NET \uc560\ud50c\ub9ac\ucf00\uc774\uc158"},"content":{"rendered":"
\n

\uc774 SQL\uacfc NoSQL \ube44\uad50\ub294 SQL Server \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c Couchbase\ub85c \ubcc0\ud658\ud55c \ud6c4 \ub2e4\uc74c \ub2e8\uacc4\uc785\ub2c8\ub2e4. In \uc774\uc804 \uac8c\uc2dc\ubb3c<\/a>\ub97c \uc0ac\uc6a9\ud558\uc5ec SQL Server\uc5d0\uc11c Couchbase\ub85c AdventureWorks\ub97c \ubcf5\uc0ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

\uc774 \uae00\uc5d0\uc11c\ub294 SQL Server\ub97c \uc0ac\uc6a9\ud558\ub294 ASP.NET Core \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc \ub3d9\uc77c\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 Couchbase\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4. \ub530\ub77c \ud574\ubcf4\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 SqlServerToCouchbase \ud504\ub85c\uc81d\ud2b8<\/a> \uc5d0\uc11c \ud655\uc778\ud558\uc138\uc694.<\/p>\n<\/div>\n

\n

\uc774\uc804 \uac8c\uc2dc\ubb3c\uacfc \ub2ec\ub9ac \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \"\uc790\ub3d9\" \ubcc0\ud658\uc744 \uc2dc\ub3c4\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub300\uc2e0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc218\uc900\uc5d0\uc11c SQL\uacfc NoSQL\uc744 \ube44\uad50\ud558\ub294 \uac83\uc73c\ub85c \uc0dd\uac01\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

ASP.NET SQL Server \uc560\ud50c\ub9ac\ucf00\uc774\uc158<\/h2>\n
\n
\n

\uc544\uc8fc \uac04\ub2e8\ud55c ASP.NET Core REST API \uc2a4\ud0c0\uc77c\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \uc800\ub294 \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc0ac\uc6a9\ud588\uc9c0\ub9cc Dapper, ADO.NET, NHibernate \ub4f1\uc744 \uc0ac\uc6a9\ud558\uc2dc\ub294 \ubd84\ub4e4\ub3c4 \uc27d\uac8c \ub530\ub77c\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

\uac01 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub294 JSON\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \ub610\ud55c \ud504\ub85c\uc81d\ud2b8\uc5d0 Swashbuckle\uc744 \ucd94\uac00\ud558\uc5ec \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c OpenAPI\ub97c \ud1b5\ud574 \ubc14\ub85c \uc694\uccad\uc744 \ubc1c\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n

ASP.NET \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc560\ud50c\ub9ac\ucf00\uc774\uc158<\/h2>\n
\n
\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubc84\uc804\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ub3d9\uc77c\ud55c SQL Server AdventureWorks \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

\uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc800\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 .NET SDK<\/a> \uadf8\ub9ac\uace0 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uac70\ub798<\/a> \ub77c\uc774\ube0c\ub7ec\ub9ac. (\ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Linq2Couchbase<\/a> \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c \ub300\uccb4\uc758 \ud55c \uc720\ud615\uc73c\ub85c).<\/p>\n<\/div>\n

\n

\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ub3d9\uc77c\ud558\uba70 SQL\uacfc NoSQL \ube44\uad50(\ubc0f \ub300\uc870)\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub294 JSON\uc744 \ubc18\ud658\ud558\uace0 Swashbuckle\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

\uac01 \uc0d8\ud50c\uc5d0\ub294 \ucee8\ud2b8\ub864\ub7ec\uac00 \ud558\ub098\uc529 \uc788\uc2b5\ub2c8\ub2e4. \ucee8\ud2b8\ub864\ub7ec\uc758 \uac01 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub97c \uc0b4\ud3b4\ubcf4\uace0 SQL\uacfc NoSQL \ube44\uad50\ub97c \uc218\ud589\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n

SQL\uacfc NoSQL \ube44\uad50: ID\ub85c \uac00\uc838\uc624\uae30<\/h2>\n
\n
\n

\uba3c\uc800 GetPersonByIdAsync<\/code> \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uc785\ub2c8\ub2e4. \uac1c\uc778 ID\uac00 \uc8fc\uc5b4\uc9c0\uba74 \uc774 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub294 \uc8fc\uc5b4\uc9c4 ID\uc5d0 \ub300\ud55c \uac1c\uc778 \ub370\uc774\ud130\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n

\n

SQL Server<\/h3>\n
\n

\ub2e4\uc74c\uc740 \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc0ac\uc6a9\ud558\ub294 SQL Server \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n<\/div>\n

\n
\n
[HttpGet(\"\/person\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdAsync(int personId)\r\n{\r\n    var person = await _context.Persons\r\n        .SingleOrDefaultAsync(p => p.BusinessEntityID == personId);\r\n\r\n    return Ok(person);\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc774 \uba54\uc11c\ub4dc\uc758 \ub2e4\ub978 \ubc84\uc804\ub3c4 \uc791\uc131\ud588\uc2b5\ub2c8\ub2e4. GetPersonByIdRawAsync<\/code> \ub294 \"\uc6d0\uc2dc\" SQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \ucffc\ub9ac\ub294 \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c(\uc704)\uac00 \uad81\uadf9\uc801\uc73c\ub85c \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac\uc640 \ub9e4\uc6b0 \uc720\uc0ac\ud558\uba70, Dapper \uc811\uadfc \ubc29\uc2dd\uacfc\ub3c4 \uc720\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/personRaw\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdRawAsync(int personId)\r\n{\r\n    var person = await _context.Persons\r\n        .FromSqlRaw(@\"SELECT * FROM Person.Person WHERE BusinessEntityID = {0}\", personId)\r\n        .SingleOrDefaultAsync();\r\n\r\n    return Ok(person);\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc5b4\ub290 \ucabd\uc774\ub4e0 SQL \ucffc\ub9ac\uac00 \uc2e4\ud589\ub418\uace0 \uc788\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694.<\/p>\n<\/div>\n
\n
N1QL\uc744 \uc0ac\uc6a9\ud558\uba74 \ub9e4\uc6b0 \uc720\uc0ac\ud55c \ubc29\uc2dd\uc73c\ub85c Couchbase\uc758 \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 GetPersonByIdRawAsync<\/code> \ub97c \uc0ac\uc6a9\ud558\uc138\uc694:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/personRaw\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdRawAsync(int personId)\r\n{\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var cluster = bucket.Cluster;\r\n    var personResult = await cluster.QueryAsync<Person>(@\"\r\n        SELECT p.* FROM AdventureWorks2016.Person.Person p WHERE p.BusinessEntityID = $personId\",\r\n        new QueryOptions().Parameter(\"personId\", personId));\r\n    return Ok(await personResult.Rows.SingleOrDefaultAsync());\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
(\"\ubc84\ud0b7\"\uc5d0\uc11c \"\ud074\ub7ec\uc2a4\ud130\"\ub85c \uc774\ub3d9\ud558\ub294 \ucd94\uac00 \ub2e8\uacc4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub2e8\uacc4\ub97c \uac74\ub108\ub6f8 \uc218\ub3c4 \uc788\uc9c0\ub9cc \uc800\ub294 \ucee8\ud2b8\ub864\ub7ec\uc758 \ub2e4\ub978 \uacf3\uc5d0\uc11c \ubc84\ud0b7\uc744 \uc0ac\uc6a9\ud558\uae30 \ub54c\ubb38\uc5d0 \uadf8\ub300\ub85c \ub450\uc5c8\uc2b5\ub2c8\ub2e4.)<\/p>\n<\/div>\n
\n
\uadf8\ub7ec\ub098 N1QL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc778\ub371\uc2f1, \ucffc\ub9ac \uad6c\ubb38 \ubd84\uc11d \ub4f1 \uc57d\uac04\uc758 \ucd94\uac00 \uc624\ubc84\ud5e4\ub4dc\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. Couchbase\ub97c \uc0ac\uc6a9\ud558\uba74 \uc774\ubbf8 \uac1c\uc778 ID\ub97c \uc54c\uace0 \uc788\ub294 \uacbd\uc6b0 N1QL \ucffc\ub9ac\ub97c \uac74\ub108\ub6f0\uace0 \uc9c1\uc811 \ud0a4\/\uac12(K\/V) \uc870\ud68c\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n
\n
K\/V\ub85c \uc2e0\ubd84\uc99d \ud655\uc778<\/h3>\n
\n
\ud0a4\ub294 \uc774\ubbf8 \uc54c\uace0 \uc788\uc73c\ubbc0\ub85c \uc778\uc790\ub85c \uc8fc\uc5b4\uc9d1\ub2c8\ub2e4. SQL\uc744 \uc0ac\uc6a9\ud558\ub294 \ub300\uc2e0 \ud0a4\/\uac12 \uc870\ud68c\ub97c \ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc800\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d4\ub4dc\ud3ec\uc778\ud2b8 \uba54\uc11c\ub4dc\uc5d0\uc11c \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud588\uc2b5\ub2c8\ub2e4. GetPersonByIdAsync<\/code>:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/person\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdAsync(int personId)\r\n{\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var scope = await bucket.ScopeAsync(\"Person\");\r\n    var coll = await scope.CollectionAsync(\"Person\");\r\n    var personDoc = await coll.GetAsync(personId.ToString());\r\n    return Ok(personDoc.ContentAs<Person>());\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
SQL Server\uc640 \ub2ec\ub9ac Couchbase\ub294 \ub370\uc774\ud130\uc640 \uc0c1\ud638 \uc791\uc6a9\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c API\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \ud0a4\/\uac12 \uc870\ud68c\ub294 \uba54\ubaa8\ub9ac\uc5d0\uc11c \uc9c1\uc811 Person \ubb38\uc11c\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. SQL \ucffc\ub9ac\ub97c \ud30c\uc2f1\ud558\uac70\ub098 \uc778\ub371\uc2f1\uc744 \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. Couchbase\uc758 \ud0a4\/\uac12 \uc870\ud68c\ub294 \uc885\uc885 \ub9c8\uc774\ud06c\ub85c\ucd08 \ub2e8\uc704\ub85c \uce21\uc815\ub429\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\uc81c \uc870\uc5b8: \uac00\ub2a5\ud558\uba74 \ud0a4\/\uac12 \uc870\ud68c\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
ID\ub85c \ud655\uc7a5\ub41c \uc5d4\ud130\ud2f0 \uac00\uc838\uc624\uae30<\/h2>\n
\n
\n
\ub370\uc774\ud130\ub294 \ubcf5\uc7a1\ud558\uace0 \uc5ec\ub7ec \ud14c\uc774\ube14\uc5d0 \uac78\uccd0 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\ub610\ub294 Couchbase\uc758 \uacbd\uc6b0 \uc5ec\ub7ec \ubb38\uc11c\uc5d0 \uac78\uccd0 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4). \uc0ac\uc6a9 \uc911\uc778 \ub3c4\uad6c\uc5d0 \ub530\ub77c \uad00\ub828 \uc5d4\ud2f0\ud2f0\ub97c \ub85c\ub4dc\ud560 \uc218 \uc788\ub294 \uc77c\ubd80 \uae30\ub2a5\uc774 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\uc608\ub97c \ub4e4\uc5b4, \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc0ac\uc6a9\ud558\uba74 \ud3ec\ud568<\/code> \ub97c \uc0ac\uc6a9\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc774 \uad00\ub828 \uc5d4\ud2f0\ud2f0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. GetPersonByIdExpandedAsync<\/code> \uc608\uc81c:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/personExpanded\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdExpandedAsync(int personId)\r\n{\r\n    var person = await _context.Persons\r\n        .Include(p => p.EmailAddresses)\r\n        .SingleOrDefaultAsync(p => p.BusinessEntityID == personId);\r\n\r\n    return Ok(person);\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub294 \uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uae30 \uc704\ud574 \ub4a4\uc5d0\uc11c JOIN \ubc0f\/\ub610\ub294 \uc5ec\ub7ec SELECT \ucffc\ub9ac\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ubfd0\ub9cc \uc544\ub2c8\ub77c \ubaa8\ub4e0 O\/RM\uc774 \uc704\ud5d8\ud560 \uc218 \uc788\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4. SQL \ud504\ub85c\ud30c\uc77c\ub7ec\uc640 \uac19\uc740 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc2e4\uc81c\ub85c \uc5b4\ub5a4 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub418\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n\n\n\n
\n
\ucc38\uace0<\/div>\n<\/td>\n
O\/RM\uc774 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc9c0\ub9cc SQL\uc5d0\uc11c NoSQL\ub85c<\/a> \uc640 \ube44\uad50\ud560 \ub54c, \uc784\ud53c\ub358\uc2a4 \ubd88\uc77c\uce58\ub294 NoSQL \uc138\uacc4\uc5d0\uc11c \ud6e8\uc52c \ub35c \ubb38\uc81c\uac00 \ub41c\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n
Couchbase \uc0d8\ud50c\uc758 \uacbd\uc6b0, \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 \ub300\uc2e0\uc5d0 NEST \uad6c\ubb38<\/a> SQL \ud45c\uc900\uc758 N1QL \ud655\uc7a5\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. \ub2e4\uc74c\uc740 Couchbase \ubc84\uc804\uc758 GetPersonByIdExpandedAsync<\/code> \uc678\ubaa8:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/personExpanded\/{personId}\")]\r\npublic async Task<IActionResult> GetPersonByIdExpandedAsync(int personId)\r\n{\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var cluster = bucket.Cluster;\r\n    var personResult = await cluster.QueryAsync<Person>(@\"\r\n        SELECT p.*, EmailAddresses\r\n        FROM AdventureWorks2016.Person.Person p\r\n        NEST AdventureWorks2016.Person.EmailAddress EmailAddresses ON EmailAddresses.BusinessEntityID = p.BusinessEntityID\r\n        WHERE p.BusinessEntityID = $personId\",\r\n        new QueryOptions().Parameter(\"personId\", personId));\r\n    return Ok(await personResult.Rows.SingleOrDefaultAsync());\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
NEST\ub294 \uc870\uc778\ub41c \ub370\uc774\ud130\ub97c \uc911\ucca9\ub41c JSON \uac1d\uccb4\uc5d0 \ub123\ub294 \uc77c\uc885\uc758 JOIN\uc785\ub2c8\ub2e4. O\/RM\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ub9e4\ud551\ud558\ub294 \ub300\uc2e0 \uc774 \ub370\uc774\ud130\ub97c C# \uac1d\uccb4\ub85c \uc9c1\uc811 \uc9c1\ub82c\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
\ud398\uc774\uc9d5 \ucffc\ub9ac<\/h2>\n
\n
\n
\ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \uc218 \uc788\ub294 \ud0a4\uac00 \ud558\ub098\ub3c4 \uc5c6\ub294 \uacbd\uc6b0\ub97c \uc608\ub85c \ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\uc758 '\ud398\uc774\uc9c0'\ub97c \ubc18\ud658\ud558\ub294 \uba54\uc11c\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4(\uc544\ub9c8\ub3c4 UI \uadf8\ub9ac\ub4dc\ub098 \ubaa9\ub85d\uc744 \ucc44\uc6b0\uae30 \uc704\ud55c \uac83\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4).<\/p>\n<\/div>\n
\n
SQL Server\uc758 \ud398\uc774\uc9d5<\/h3>\n
\n
SQL Server \ubc84\uc804\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. GetPersonsPageAsync<\/code>:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/persons\/page\/{pageNum}\")]\r\npublic async Task<IActionResult> GetPersonsPageAsync(int pageNum)\r\n{\r\n    var pageSize = 10;\r\n    var personPage = await _context.Persons\r\n        .OrderBy(p => p.LastName)\r\n        .Skip(pageNum * pageSize)\r\n        .Take(pageSize)\r\n        .Select(p => new { p.BusinessEntityID, p.FirstName, p.LastName })\r\n        .ToListAsync();\r\n    return Ok(personPage);\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c \uc0ac\uc6a9, \uc8fc\ubb38 \uae30\uc900<\/code>, \uac74\ub108\ub6f0\uae30<\/code>\ubc0f Take<\/code> \ub294 \uc77c\ubc18\uc801\uc73c\ub85c \ud398\uc774\uc9d5\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. SQL Server \ud504\ub85c\ud30c\uc77c\ub7ec\ub97c \uc5f4\uba74 \uc0dd\uc131\ub418\ub294 SQL\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n
\n
\n
exec sp_executesql N'SELECT [p].[BusinessEntityID], [p].[FirstName], [p].[LastName]\r\nFROM [Person].[Person] AS [p]\r\nORDER BY [p].[LastName]\r\nOFFSET @__p_0 ROWS FETCH NEXT @__p_0 ROWS ONLY',N'@__p_0 int',@__p_0=10<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc624\ud504\uc14b ... \ud589 \uac00\uc838 \uc624\uae30 \ub2e4\uc74c ...<\/code> \ub294 \uc5ec\uae30\uc11c \ud398\uc774\uc9d5\uc5d0 \uc0ac\uc6a9\ub418\ub294 \uad6c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n
\n
Couchbase\uc758 \ud398\uc774\uc9d5<\/h3>\n
\n
\ud398\uc774\uc9d5 \uad6c\ubb38\uc740 \ud56d\uc0c1 SQL \uad6c\ud604\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. Couchbase\ub294 \uc774 \uc810\uc5d0\uc11c Oracle\/MySQL \uad6c\ubb38\uc5d0 \ub354 \uc758\uc874\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 Couchbase \ubc84\uc804\uc758 GetPersonsPageAsync<\/code>:<\/p>\n<\/div>\n
\n
\n
[HttpGet(\"\/persons\/page\/{pageNum}\")]\r\npublic async Task<IActionResult> GetPersonsPageAsync(int pageNum)\r\n{\r\n    var pageSize = 10;\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var bucketName = bucket.Name;\r\n    var cluster = bucket.Cluster;\r\n\r\n    var personPage = await cluster.QueryAsync<Person>($@\"\r\n        SELECT p.LastName, p.BusinessEntityID, p.FirstName\r\n        FROM `{bucketName}`.Person.Person p\r\n        WHERE p.LastName IS NOT MISSING\r\n        ORDER BY p.LastName\r\n        LIMIT {pageSize} OFFSET {(pageNum * pageSize)}\r\n    \");\r\n\r\n    return Ok(await personPage.Rows.ToListAsync());\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uc774 \uacbd\uc6b0 \uc81c\ud55c ... \uc624\ud504\uc14b ...<\/code> \uac00 \uc0ac\uc6a9 \uc911\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\ub610\ud55c p.LastName\uc774 \ub204\ub77d\ub418\uc9c0 \uc54a\uc740 \uacbd\uc6b0<\/code>. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\ubbc0\ub85c \ucffc\ub9ac \uc5d4\uc9c4\uc740 \ub2e4\uc74c\uc744 \uac00\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc131<\/code> \ub97c \ud3ec\ud568\ud55c \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 p.\uc131\uc73c\ub85c \uc8fc\ubb38<\/code>. \uc774\uac83\uc744 \ucd94\uac00\ud558\uba74 \uc5b4\ub514<\/code> \uc808\uc744 \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac\ub294 \uc774\uc81c \uc5b4\ub5a4 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560\uc9c0 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc808\uc774 \uc5c6\uc73c\uba74 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \ub370 \ud6e8\uc52c \ub354 \uc624\ub798 \uac78\ub9bd\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
ACID \ud2b8\ub79c\uc7ad\uc158\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8<\/h2>\n
\n
\n
\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 SQL Server\uc640 Couchbase \ubaa8\ub450\uc5d0\uc11c \uad00\uacc4\ud615 \ubaa8\ub378\uc744 \uc0ac\uc6a9\ud558\ubbc0\ub85c \ub450 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubaa8\ub450\uc5d0\uc11c ACID \ud2b8\ub79c\uc7ad\uc158\uc774 \uc911\uc694\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\uc774 \uc608\uc81c\uc5d0\uc11c\ub294 PersonUpdateApi<\/code> \ub97c \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub458 \ub2e4<\/strong> \uc0ac\ub78c\uc758 \uc774\ub984\uacfc \uc774\uba54\uc77c \uc8fc\uc18c\uc785\ub2c8\ub2e4. \uc774 \ub370\uc774\ud130\ub294 \ub450 \uac1c\uc758 \uac1c\ubcc4 \ud14c\uc774\ube14\/\ud589(SQL Server) \ub610\ub294 \ub450 \uac1c\uc758 \uac1c\ubcc4 \ubb38\uc11c(Couchbase)\uc5d0 \uc788\uc73c\ubbc0\ub85c, \uc774 \uc791\uc5c5\uc740 \uc804\ubd80 \uc544\ub2c8\uba74 \uc804\ubb34\uc758 \uc6d0\uc790 \uc5f0\uc0b0\uc774 \ub418\uae30\ub97c \uc6d0\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n\n\n\n
\n
\ucc38\uace0<\/div>\n<\/td>\n
\ud55c \uc0ac\ub78c\uc774 \uc5ec\ub7ec \uac1c\uc758 \uc774\uba54\uc77c \uc8fc\uc18c\ub97c \uac00\uc9c8 \uc218 \uc788\uc9c0\ub9cc \uc774 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c\ub294 \ub4dc\ubb3c\uae30 \ub54c\ubb38\uc5d0 (API\ub97c \ub2e8\uc21c\ud654\ud558\uae30 \uc704\ud574) \ub458 \ub2e4\uc5d0 \ub300\ud574 ID\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n
\uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\uac00 \ud3ec\ud568\ub41c ACID<\/h3>\n
\n
\ub2e4\uc74c\uc740 \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\ub97c \uc0ac\uc6a9\ud558\uc5ec Person \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \ud589\uacfc EmailAddress \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130 \ud589\uc744 \ubaa8\ub450 \uc5c5\ub370\uc774\ud2b8\ud558\ub294 ACID \ud2b8\ub79c\uc7ad\uc158\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n
\n
\n
[HttpPut(\"\/person\")]\r\npublic async Task<IActionResult> UpdatePurchaseOrderAsync(PersonUpdateApi personUpdateApi)\r\n{\r\n    var transaction = await _context.Database.BeginTransactionAsync();\r\n\r\n    try\r\n    {\r\n        \/\/ find the person\r\n        var person = await _context.Persons\r\n            .Include(p => p.EmailAddresses)\r\n            .SingleOrDefaultAsync(p => p.BusinessEntityID == personUpdateApi.PersonId);\r\n\r\n        \/\/ update name\r\n        person.FirstName = personUpdateApi.FirstName;\r\n        person.LastName = personUpdateApi.LastName;\r\n\r\n        \/\/ get the particular email address and update it\r\n        \/\/ if the supplied ID is invalid, this will throw an exception\r\n        var email = person.EmailAddresses.Single(e =>\r\n            e.EmailAddressID == personUpdateApi.EmailAddressId);\r\n        email.EmailAddress = personUpdateApi.EmailAddress;\r\n\r\n        await _context.SaveChangesAsync();\r\n\r\n        \/\/ commit transaction\r\n        await transaction.CommitAsync();\r\n\r\n        return Ok($\"Person {personUpdateApi.PersonId} name and email updated.\");\r\n    }\r\n    catch (Exception ex)\r\n    {\r\n        await transaction.RollbackAsync();\r\n        return BadRequest(\"Something went wrong, transaction rolled back\");\r\n    }\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
\n
\uac70\ub798\uc758 \ub124 \uac00\uc9c0 \uc8fc\uc694 \ubd80\ubd84\uc5d0 \uc720\uc758\ud558\uc138\uc694:<\/p>\n<\/div>\n
\n
    \n
  1. \uac70\ub798 \uc2dc\uc791(_context.Database.BeginTransactionAsync();<\/code>)<\/li>\n
  2. \uc2dc\ub3c4<\/code>\/catch<\/code><\/li>\n
  3. \ud2b8\ub79c\uc7ad\uc158 \ucee4\ubc0b(\ud2b8\ub79c\uc7ad\uc158.CommitAsync()\ub97c \uae30\ub2e4\ub9bd\ub2c8\ub2e4;<\/code>)<\/li>\n
  4. \ub864\ubc31 \ud2b8\ub79c\uc7ad\uc158\uc758 catch<\/code> (\ud2b8\ub79c\uc7ad\uc158.\ub864\ubc31\ube44\ub3d9\uae30();<\/code>)<\/li>\n<\/ol>\n<\/div>\n
    \n
    \uc774\uac83\uc740 \ucd5c\uadfc \uba87 \ub144 \ub3d9\uc548 SQL\uacfc NoSQL\uc744 \ube44\uad50\ud558\ub294 \uc911\uc694\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4. Couchbase\ub97c \uc0ac\uc6a9\ud558\uba74 \uc774\uc81c ACID \ud2b8\ub79c\uc7ad\uc158\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n
    \n
    \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud2b8\ub79c\uc7ad\uc158\uc774 \uc788\ub294 ACID<\/h3>\n
    \n
    \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uacbd\uc6b0 API\ub294 \uc57d\uac04 \ub2e4\ub974\uc9c0\ub9cc \ub2e8\uacc4\ub294 \ubaa8\ub450 \ub3d9\uc77c\ud569\ub2c8\ub2e4:<\/p>\n<\/div>\n
    \n
    \n
    [HttpPut(\"\/person\")]\r\npublic async Task<IActionResult> UpdatePurchaseOrderAsync(PersonUpdateApi personUpdateApi)\r\n{\r\n    \/\/ setup bucket, cluster, and collections\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var scope = await bucket.ScopeAsync(\"Person\");\r\n    var personColl = await scope.CollectionAsync(\"Person\");\r\n    var emailColl = await scope.CollectionAsync(\"EmailAddress\");\r\n\r\n    \/\/ create transaction\r\n    var cluster = bucket.Cluster;\r\n    var transaction = Transactions.Create(cluster,\r\n        TransactionConfigBuilder.Create()\r\n            .DurabilityLevel(DurabilityLevel.None)\r\n            .Build());\r\n\r\n    try\r\n    {\r\n        await transaction.RunAsync(async (context) =>\r\n        {\r\n            \/\/ update person and email documents\r\n            \/\/ based on values passed in API object\r\n            var personKey = personUpdateApi.PersonId.ToString();\r\n            var emailKey = personKey + \"::\" + personUpdateApi.EmailAddressId.ToString();\r\n            var person = await context.GetAsync(personColl, personKey);\r\n            var email = await context.GetAsync(emailColl, emailKey);\r\n\r\n            var personDoc = person.ContentAs<dynamic>();\r\n            var emailDoc = email.ContentAs<dynamic>();\r\n\r\n            personDoc.FirstName = personUpdateApi.FirstName;\r\n            personDoc.LastName = personUpdateApi.LastName;\r\n            emailDoc.EmailAddress = personUpdateApi.EmailAddress;\r\n\r\n            await context.ReplaceAsync(person, personDoc);\r\n            await context.ReplaceAsync(email, emailDoc);\r\n        });\r\n        return Ok($\"Person {personUpdateApi.PersonId} name and email updated.\");\r\n    }\r\n    catch (Exception ex)\r\n    {\r\n        return BadRequest(\"Something went wrong, transaction rolled back.\");\r\n    }\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
    \n
    \uc8fc\uc694 \ub2e8\uacc4\ub294 \ub3d9\uc77c\ud569\ub2c8\ub2e4:<\/p>\n<\/div>\n
    \n
      \n
    1. \uac70\ub798 \uc2dc\uc791(\ud2b8\ub79c\uc7ad\uc158.RunAsync( ... )<\/code>)<\/li>\n
    2. \uc2dc\ub3c4<\/code>\/catch<\/code><\/li>\n
    3. \ud2b8\ub79c\uc7ad\uc158 \ucee4\ubc0b(\uc554\uc2dc\uc801\uc774\uc9c0\ub9cc context.CommitAsync()<\/code> \uc0ac\uc6a9 \uac00\ub2a5)<\/li>\n
    4. \ub864\ubc31 \ud2b8\ub79c\uc7ad\uc158(\ub2e4\uc2dc \ud55c \ubc88 \uc554\uc2dc\ub418\uc9c0\ub9cc context.RollbackAsync()<\/code> \ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4).<\/li>\n<\/ol>\n<\/div>\n
      \n
      \ub450 \uacbd\uc6b0 \ubaa8\ub450 ACID \ud2b8\ub79c\uc7ad\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc640 \ub2ec\ub9ac<\/strong> \uadf8\ub7ec\ub098 SQL Server\ub294 \ub098\uc911\uc5d0<\/strong> Couchbase\uc758 \ub370\uc774\ud130\ub97c \ucd5c\uc801\ud654\ud558\uace0 \ud1b5\ud569\ud558\uc5ec \ud544\uc694\ud55c ACID \ud2b8\ub79c\uc7ad\uc158\uc758 \uc591\uc744 \uc904\uc774\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      \n
      \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800: SQL\uacfc NoSQL \ube44\uad50<\/h2>\n
      \n
      \n
      \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub294 \ub54c\ub54c\ub85c \ub17c\ub780\uc758 \uc5ec\uc9c0\uac00 \uc788\ub294 \uc8fc\uc81c\uc785\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc5d0\ub294 \ub9ce\uc740 \uae30\ub2a5\uacfc \ub17c\ub9ac\uac00 \ud3ec\ud568\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n
      \n
      SQL Server\uc758 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800<\/h3>\n
      \n
      \"ListSubcomponents\"\ub77c\ub294 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4 ( \uae43\ud5c8\ube0c\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9<\/a>). \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\uc5d0\uc11c\ub294 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. FromSqlRaw<\/code> \ub97c \uc2e4\ud589\ud558\uace0 \uadf8 \uacb0\uacfc\ub97c C# \uac1d\uccb4\uc5d0 \ub9e4\ud551\ud569\ub2c8\ub2e4. \uc758\uc0ac \uc5d4\ud2f0\ud2f0 C# \uac1d\uccb4\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \ud558\uc704 \ucef4\ud3ec\ub10c\ud2b8 \ub098\uc5f4<\/code> \uc774 \uc2a4\ud504\ub85c\ud06c\uc5d0\ub9cc \uc0ac\uc6a9\ub429\ub2c8\ub2e4:<\/p>\n<\/div>\n
      \n
      \n
      \/\/ sproc example - see ExampleStoredProcedure.sql\r\n[HttpGet(\"\/getListSubcomponents\/{listPriceMin}\/{listPriceMax}\")]\r\npublic async Task<IActionResult> GetListSubcomponents(decimal listPriceMin, decimal listPriceMax)\r\n{\r\n    var listPriceMinParam = new SqlParameter(\"@ListPriceMin\", SqlDbType.Decimal) {Value = listPriceMin };\r\n    var listPriceMaxParam = new SqlParameter(\"@ListPriceMax\", SqlDbType.Decimal) {Value = listPriceMax };\r\n\r\n    var result = await _context.ListSubcomponents\r\n        .FromSqlRaw(\"EXECUTE dbo.ListSubcomponents @ListPriceMin, @ListPriceMax\", listPriceMinParam, listPriceMaxParam)\r\n        .ToListAsync();\r\n\r\n    return Ok(result);\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
      \n
      \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc5d0\ub294 \ub450 \uac1c\uc758 \ub9e4\uac1c \ubcc0\uc218\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n
      \n
      \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc815\uc758 \uae30\ub2a5<\/h3>\n
      \n
      Couchbase\uc5d0\ub294 \uc544\uc9c1 \"\uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\"\ub77c\ub294 \uac83\uc774 \uc5c6\uc9c0\ub9cc, \ud544\uc694\ud55c \uacbd\uc6b0 \ubcf5\uc7a1\ud55c \ub85c\uc9c1\uc744 \ud3ec\ud568\ud560 \uc218 \uc788\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218(UDF)\ub77c\ub294 \uac83\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n
      \n
      \ub77c\ub294 UDF\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4. \ud558\uc704 \ucef4\ud3ec\ub10c\ud2b8 \ub098\uc5f4<\/code> (\ub610\ud55c \uae43\ud5c8\ube0c\uc5d0\uc11c \ubcf4\uae30<\/a>)\uc758 \uae30\ub2a5\uacfc \uc77c\uce58\ud558\ub294 SQL Server \uc2a4\ud504\ub85c\ud06c\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n
      \n
      ASP.NET\uc5d0\uc11c \ud574\ub2f9 UDF\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n
      \n
      \n
      \/\/ sproc example - see ExampleStoredProcedure.sql\r\n[HttpGet(\"\/getListSubcomponents\/{listPriceMin}\/{listPriceMax}\")]\r\npublic async Task<IActionResult> GetListSubcomponents(decimal listPriceMin, decimal listPriceMax)\r\n{\r\n    var bucket = await _bucketProvider.GetBucketAsync();\r\n    var cluster = bucket.Cluster;\r\n\r\n    var options = new QueryOptions();\r\n    options.Parameter(\"$listPriceMin\", listPriceMin);\r\n    options.Parameter(\"$listPriceMax\", listPriceMax);\r\n\r\n    var result = await cluster.QueryAsync<ListSubcomponent>(\r\n        \"SELECT l.* FROM ListSubcomponents($listPriceMin, $listPriceMax) l\", options);\r\n\r\n    return Ok(await result.Rows.ToListAsync());\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n
      \n
      \ub450 \uac1c\uc758 \ub9e4\uac1c \ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec Couchbase\uc5d0\uc11c \uc774\ub97c \ud638\ucd9c\ud558\ub294 \uac83\uc740 \uc5d4\ud2f0\ud2f0 \ud504\ub808\uc784\uc6cc\ud06c\uc5d0\uc11c FromSqlRaw\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uacfc \ub9e4\uc6b0 \uc720\uc0ac\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      \n
      \uc131\ub2a5 - SQL\uacfc NoSQL \ube44\uad50<\/h2>\n
      \n
      \n
      \uc774\uc81c \uc571\uc744 Couchbase\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \ubcc0\ud658\ud588\ub294\ub370 \uc0c8 \ubc84\uc804\uc774 \uc801\uc5b4\ub3c4 \uc774\uc804 SQL Server \ubc84\uc804\ub9cc\ud07c \ube60\ub974\uac8c \uc2e4\ud589\ub418\ub098\uc694?<\/p>\n<\/div>\n
      \n
      \ub300\ub2f5\ud558\uae30 \ubcf5\uc7a1\ud55c \uc9c8\ubb38\uc785\ub2c8\ub2e4:<\/p>\n<\/div>\n
      \n