{"id":263,"date":"2012-01-18T07:36:35","date_gmt":"2012-01-18T07:36:35","guid":{"rendered":"http:\/\/anyons.net\/dev\/?p=263"},"modified":"2022-07-12T14:49:00","modified_gmt":"2022-07-12T05:49:00","slug":"mybatis-net-sql-%ec%bf%bc%eb%a6%ac-%ec%9d%b4%ec%81%98%ea%b2%8c-%ec%b6%9c%eb%a0%a5","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=263","title":{"rendered":"MyBatis.Net &#8211; SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825"},"content":{"rendered":"<p>iBatis.Net\uc5d0\uc11c \ucffc\ub9ac\ub97c \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uba74 \uc8fd~ \ud55c\uc904\ub85c\ub9cc \ub098\uc628\ub2e4.<\/p>\n<p>\uc774\ub54c \uac00\ub3c5\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574\uc11c iBatis.Net\uc758 \ucf54\ub4dc\uc5d0\uc11c \uc544\ub798\ub97c \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n<p>DataMapper \ud504\ub85c\uc81d\ud2b8\uc758 DomSqlMapBuilder \ud074\ub798\uc2a4\uc5d0\uc11c ParseDynamicTags() \uba54\uc18c\ub4dc&#8230;<\/p>\n<pre class=\"lang:c# decode:true\">\/\/string data = child.InnerText.Replace('n', ' ').Replace('r', ' ').Replace('t', ' '); \/\/ \uc8fc\uc11d\ucc98\ub9ac!!\nstring data = child.InnerText.Replace('t', ' ');<\/pre>\n<pre class=\"lang:verilog decode:true\">2008-10-24 11:39:24,281 - Statement Id: [select_categories] Prepared SQL:\n[select CategoryID,\nCategoryName,\nDescription\nfrom Categories]<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>iBatis.Net\uc5d0\uc11c \ucffc\ub9ac\ub97c \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uba74 \uc8fd~ \ud55c\uc904\ub85c\ub9cc \ub098\uc628\ub2e4.<\/p>\n<p>\uc774\ub54c \uac00\ub3c5\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574\uc11c iBatis.Net\uc758 \ucf54\ub4dc\uc5d0\uc11c \uc544\ub798\ub97c \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n<p>DataMapper \ud504\ub85c\uc81d\ud2b8\uc758 DomSqlMapBuilder \ud074\ub798\uc2a4\uc5d0\uc11c ParseDynamicTags() \uba54\uc18c\ub4dc&#8230;<\/p>\n<p> \/\/string data = child.InnerText.Replace(&#8216;n&#8217;, &#8216; &#8216;).Replace(&#8216;r&#8217;, &#8216; &#8216;).Replace(&#8216;t&#8217;, &#8216; &#8216;); \/\/ \uc8fc\uc11d\ucc98\ub9ac!! string data = child.InnerText.Replace(&#8216;t&#8217;, &#8216; &#8216;); 2008-10-24 11:39:24,281 &#8211; Statement Id: [select_categories] Prepared SQL: [select CategoryID, CategoryName, Description from Categories] [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[96],"tags":[31,266,117],"class_list":["post-263","post","type-post","status-publish","format-standard","hentry","category-programming","tag-csharp","tag-mybatis-net","tag-query","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/anyons.net\/?p=263\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon\" \/>\n<meta property=\"og:description\" content=\"iBatis.Net\uc5d0\uc11c \ucffc\ub9ac\ub97c \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uba74 \uc8fd~ \ud55c\uc904\ub85c\ub9cc \ub098\uc628\ub2e4. \uc774\ub54c \uac00\ub3c5\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574\uc11c iBatis.Net\uc758 \ucf54\ub4dc\uc5d0\uc11c \uc544\ub798\ub97c \ubcc0\uacbd\ud55c\ub2e4. DataMapper \ud504\ub85c\uc81d\ud2b8\uc758 DomSqlMapBuilder \ud074\ub798\uc2a4\uc5d0\uc11c ParseDynamicTags() \uba54\uc18c\ub4dc&#8230; \/\/string data = child.InnerText.Replace(&#039;n&#039;, &#039; &#039;).Replace(&#039;r&#039;, &#039; &#039;).Replace(&#039;t&#039;, &#039; &#039;); \/\/ \uc8fc\uc11d\ucc98\ub9ac!! string data = child.InnerText.Replace(&#039;t&#039;, &#039; &#039;); 2008-10-24 11:39:24,281 - Statement Id: [select_categories] Prepared SQL: [select CategoryID, CategoryName, Description from Categories] [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=263\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-18T07:36:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:49:00+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"MyBatis.Net &#8211; SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825\",\"datePublished\":\"2012-01-18T07:36:35+00:00\",\"dateModified\":\"2022-07-12T05:49:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263\"},\"wordCount\":11,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"csharp\",\"mybatis.net\",\"query\"],\"articleSection\":[\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=263#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=263\",\"name\":\"MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2012-01-18T07:36:35+00:00\",\"dateModified\":\"2022-07-12T05:49:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=263\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=263#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MyBatis.Net &#8211; SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/anyons.net\/?p=263","og_locale":"ko_KR","og_type":"article","og_title":"MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon","og_description":"iBatis.Net\uc5d0\uc11c \ucffc\ub9ac\ub97c \ub85c\uadf8\ub85c \ucd9c\ub825\ud558\uba74 \uc8fd~ \ud55c\uc904\ub85c\ub9cc \ub098\uc628\ub2e4. \uc774\ub54c \uac00\ub3c5\uc131\uc744 \ub192\uc774\uae30 \uc704\ud574\uc11c iBatis.Net\uc758 \ucf54\ub4dc\uc5d0\uc11c \uc544\ub798\ub97c \ubcc0\uacbd\ud55c\ub2e4. DataMapper \ud504\ub85c\uc81d\ud2b8\uc758 DomSqlMapBuilder \ud074\ub798\uc2a4\uc5d0\uc11c ParseDynamicTags() \uba54\uc18c\ub4dc&#8230; \/\/string data = child.InnerText.Replace('n', ' ').Replace('r', ' ').Replace('t', ' '); \/\/ \uc8fc\uc11d\ucc98\ub9ac!! string data = child.InnerText.Replace('t', ' '); 2008-10-24 11:39:24,281 - Statement Id: [select_categories] Prepared SQL: [select CategoryID, CategoryName, Description from Categories] [...]","og_url":"https:\/\/anyons.net\/?p=263","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2012-01-18T07:36:35+00:00","article_modified_time":"2022-07-12T05:49:00+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=263#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=263"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"MyBatis.Net &#8211; SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825","datePublished":"2012-01-18T07:36:35+00:00","dateModified":"2022-07-12T05:49:00+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=263"},"wordCount":11,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["csharp","mybatis.net","query"],"articleSection":["Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=263#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=263","url":"https:\/\/anyons.net\/?p=263","name":"MyBatis.Net - SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2012-01-18T07:36:35+00:00","dateModified":"2022-07-12T05:49:00+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=263#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=263"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=263#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"MyBatis.Net &#8211; SQL \ucffc\ub9ac \uc774\uc058\uac8c(?) \ucd9c\ub825"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack-related-posts":[{"id":270,"url":"https:\/\/anyons.net\/?p=270","url_meta":{"origin":263,"position":0},"title":"SQL Injection \ubc29\uc5b4","author":"anydragon","date":"2012\ub144 02\uc6d4 20\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/forums.asp.net\/t\/1254125.aspx \ub97c \ubcf4\uba74 ASP.NET 1.1\uc774\ub0d0 2.0 \uc774\ub0d0\uc5d0 \ub530\ub77c \uac01\uac01 \uc774\ub807\uac8c \ud558\ub77c\uace0 \ud55c\ub2e4. \uc544\uc9c1\uc740 \ub09c web.config\uac00 \uc775\uc219\uce58 \uc54a\uc544\uc11c \uadf8\ub7f0\uc9c0 1.1 \ubc29\uc2dd\uc73c\ub85c \ud558\uba74 \uc798 \ub418\ub294\ub370 2.0 \ubc29\uc2dd\uc73c\ub85c\ub294 \uc798 \uc548\ub41c\ub2e4. -_- ASP.NET 1.1 C# global.asax using System.Globalization; \/\/Defines the set of characters that will be checked. \/\/You can add to this\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":689,"url":"https:\/\/anyons.net\/?p=689","url_meta":{"origin":263,"position":1},"title":"windows event log","author":"anydragon","date":"2014\ub144 06\uc6d4 21\uc77c","format":false,"excerpt":"\ucd9c\ucc98 http:\/\/mainia.tistory.com\/412 \uc774\ubca4\ud2b8\ub85c\uadf8 \uc4f0\uae30 static void Main(string[] args) { WriteEventLogEntry(\"This is an entry in the event log by daveoncsharp.com\"); } private static void WriteEventLogEntry(string message) { \/\/ Create an instance of EventLog System.Diagnostics.EventLog eventLog = new System.Diagnostics.EventLog(); \/\/ Check if the event source exists. If not create it. if (!System.Diagnostics.EventLog.SourceExists(\"TestApplication\"))\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2548,"url":"https:\/\/anyons.net\/?p=2548","url_meta":{"origin":263,"position":2},"title":"csharp enum \uc744 \uc0ac\uc6a9\ud558\ub294 \ucf54\ub4dc \uc0d8\ud50c","author":"anydragon","date":"2022\ub144 05\uc6d4 23\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : https:\/\/qiita.com\/mkuwan\/items\/be6745f2c9e7823f8a66 public static class TypeExtention { \/\/\/ <summary> \/\/\/ enum\u306e\u5024\u30ea\u30b9\u30c8\u3092\u53d6\u5f97 \/\/\/ <\/summary> \/\/\/ <typeparam name=\"T\"><\/typeparam> \/\/\/ <returns><\/returns> public static List<T> GetEnumList<T>(this Type type) where T : Enum { return Enum.GetValues(typeof(T)).Cast<T>().ToList(); } \/\/\/ <summary> \/\/\/ enum\u306eDescripntion\u30ea\u30b9\u30c8\u3092\u53d6\u5f97 \/\/\/ <\/summary> \/\/\/ <typeparam name=\"T\"><\/typeparam> \/\/\/ <returns><\/returns> public static IEnumerable<string> GetEnumDescriptionEnumerable<T>(this Type type)\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13,"url":"https:\/\/anyons.net\/?p=13","url_meta":{"origin":263,"position":3},"title":"JET OLEDB Connect Sample using DataAdapter","author":"anydragon","date":"2009\ub144 10\uc6d4 05\uc77c","format":false,"excerpt":"#region Using directives using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Windows.Forms; #endregion namespace UsingADOManagedProvider { partial class ADONetForm1 : Form { public ADONetForm1( ) { InitializeComponent( ); \/\/ connect to Northwind Access database string connectionString = \"provider=Microsoft.JET.OLEDB.4.0; \" + \"data source = c:\\nwind.mdb\"; \/\/\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15,"url":"https:\/\/anyons.net\/?p=15","url_meta":{"origin":263,"position":4},"title":"ORACLE Connect Sample using DataAdapter without TNS","author":"anydragon","date":"2009\ub144 10\uc6d4 05\uc77c","format":false,"excerpt":"#region Using directives using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Windows.Forms; #endregion namespace UsingADOManagedProvider { partial class ADONetForm1 : Form { public ADONetForm1( ) { InitializeComponent( ); \/\/ connect to Northwind Access database string connectionString = \"Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":267,"url":"https:\/\/anyons.net\/?p=267","url_meta":{"origin":263,"position":5},"title":"ms sql \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \ubcf5\uc6d0\ubc29\ubc95","author":"anydragon","date":"2012\ub144 02\uc6d4 14\uc77c","format":false,"excerpt":"\ucd9c\ucc98 : http:\/\/nextstep.co.kr\/105 -- \ubc31\uc5c5\uc0dd\uc131(\uc788\uc73c\uba74 \uc0dd\ub7b5) BACKUP DATABASE Northwind TO DISK = 'c:\\Northwind.bak' --\ubc31\uc5c5\uc815\ubcf4\ud655\uc778(\ub17c\ub9ac\uc801\ud30c\uc77c\uba85, \ubb3c\ub9ac\uc801\uc800\uc7a5\uc704\uce58\ubc0f\ud30c\uc77c\uba85 \ud655\uc778) RESTORE FILELISTONLY FROM DISK = 'c:\\Northwind.bak' -- TestDB\ub77c\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc0c8\ub85c\uc6b4 \uacbd\ub85c(C:\\temptest*.*)\uc73c\ub85c \ubcf5\uc6d0 RESTORE DATABASE TestDB FROM DISK = 'c:\\Northwind.bak' WITH MOVE 'Northwind' TO 'c:\\testtestdb.mdf', MOVE 'Northwind_log' TO 'c:\\testtestdb.ldf'","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=263"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/263\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}