{"id":638,"date":"2022-07-01T18:26:25","date_gmt":"2022-07-01T09:26:25","guid":{"rendered":"https:\/\/mvc.auctionpro.co.kr\/?p=638"},"modified":"2022-09-22T15:31:06","modified_gmt":"2022-09-22T06:31:06","slug":"dataset-%ec%97%90-%eb%84%a3%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/mvc.auctionpro.co.kr\/?p=638","title":{"rendered":"DataSet \uc5d0 \ub123\uae30"},"content":{"rendered":"\n

1.NuGet \uc5d0\uc11c System.Configuration.ConfigurationManager \uc124\uce58<\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

2.App.conf<\/h3>\n\n\n\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<configuration>\n  <configSections>\n    <!-- For more information on Entity Framework configuration, visit http:\/\/go.microsoft.com\/fwlink\/?LinkID=237468 -->\n    <section name=\"entityFramework\" type=\"System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\" requirePermission=\"false\" \/>\n  <\/configSections>\n  <startup>\n    <supportedRuntime version=\"v4.0\" sku=\".NETFramework,Version=v4.6.1\" \/>\n  <\/startup>\n  <connectionStrings>\n    \n    <add name=\"REG\" connectionString=\"Server=SQLOLEDB.1;Password=password01;Persist Security Info=True;User ID=REG001;Initial Catalog=REG;Data Source=MYPC\"\/-->\n    <add name=\"REG_Entities\" connectionString=\"metadata=res:\/\/*\/RuleVariable.csdl|res:\/\/*\/RuleVariable.ssdl|res:\/\/*\/RuleVariable.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=MYPC;initial catalog=REG;user id=REG;password=password01;MultipleActiveResultSets=True;App=EntityFramework&quot;\" providerName=\"System.Data.EntityClient\" \/>\n    \n  <\/connectionStrings>\n  <entityFramework>\n    <defaultConnectionFactory type=\"System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework\" \/>\n    <providers>\n      <provider invariantName=\"System.Data.SqlClient\" type=\"System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer\" \/>\n    <\/providers>\n  <\/entityFramework>\n  <!--AppSettings>\n    <add key=\"CacheTime\" value=\"60\"\/>\n  <\/AppSettings-->\n\n  <appSettings>\n    <add key=\"CacheTime\" value=\"60\"\/>\n  <\/appSettings>\n\n<\/configuration><\/pre><\/div>\n\n\n\n
3.\uc18c\uc2a4 <\/h3>\n\n\n\n
using System;\nusing System.Data;\nusing System.Runtime.Caching;\nusing System.Data.SqlClient;\nusing System.Configuration;\n\n::::::: \uc911\ub7b5 ::::::\n\npublic DataSet FilterData(ArsonFilterModel filterData)\n        {\n            var connectionString = ConfigurationManager.ConnectionStrings[\"UCR_DataEntities\"];\n            DataSet dsResult = new DataSet();\n            using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString))\n            {\n                try\n                {\n                    SqlCommand command = new SqlCommand();\n                    command.Connection = conn;\n                    command.CommandText = GenerateArsonORQuery(filterData);\n                    command.CommandType = System.Data.CommandType.Text;\n                    SqlDataAdapter adapter = new SqlDataAdapter();\n                    adapter.SelectCommand = command;\n\n                    conn.Open();\n                    adapter.Fill(dsResult);\n                    conn.Close();\n                    adapter.Dispose();\n                    command.Dispose();\n                }\n                catch (Exception ex)\n                {\n                    StorageClient.LogError(ex);\n                }\n            }\n            return dsResult;\n        }<\/pre><\/div>\n\n\n\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
1.NuGet \uc5d0\uc11c System.Configuration.ConfigurationManager \uc124\uce58 2.App.conf 3.\uc18c\uc2a4<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-638","post","type-post","status-publish","format-standard","hentry","category-20"],"_links":{"self":[{"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=638"}],"version-history":[{"count":4,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions"}],"predecessor-version":[{"id":648,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/638\/revisions\/648"}],"wp:attachment":[{"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mvc.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}