Devlec.com Javacstudy.com
MyÆäÀÌÁö |  óÀ½»ç¿ëÀÚ ÀÌ¿ë¾È³» |  ÀÌ¿ë¹®ÀÇ |  ȸ»ç¼Ò°³

¡á Æ©ÅÍ°Ô½ÃÆÇ Article Number : 25517

ÁöÁ¾¿Ï´ÔÀÌ ÀÛ¼ºÇϽŠ³»¿ëÀÔ´Ï´Ù. 2016-07-15   |   Refer : 685
÷ºÎÆÄÀÏ : None   À̹ÌÁö : None ŸÀÔ : °ø°³±Û

 

 ¾È³çÇϼ¼¿ä. ¹Ú¿ëÁØ°­»ç´Ô.

 ¼îÇθô °­Á ÇÁ·ÎÁ§Æ® ºÎºÐ¿¡¼­ »ç¿ëµÇ¾ú´ø DatabaseFactory.CreateDatabase()ÇÔ¼ö »ç¿ë½Ã ¾î·Á¿òÀÌ À־ Áú¹®µå¸³´Ï´Ù.
 ÀÌ°ÍÀÌ Enterprise Library ¹öÀü, ÇöÀç »ç¿ëµÇ´Â °ÍÀÌ ¸Â´ÂÁö? ¿À·ù°¡ »ý°Ü¼­ Áú¹®µå¸³´Ï´Ù.
 (Á¦ ȯ°æÀº .NET 4.5 / Visual Studio 2013 / Enterprise Library 6.0 »ç¿ëÁßÀÔ´Ï´Ù.)

 ¿ìÆí¹øÈ£ µî·ÏÇÏ´Â Äڵ忡¼­, 
 DatabaseFactory.CreateDatabase(...) ÄÚµå ÇÑÁÙ ´ë½Å¿¡ ADO.NET Äڵ带 »ç¿ëÇϸé DB¿¡ Á¦´ë·Î ½áÁö´Âµ¥,
 DatabaseFactory.CreateDatabase(...) Äڵ带 »ç¿ëÇÏ¸é ºôµå´Â ¼º°ø, ½ÇÇàÇÒ ¶§ ´ÙÀ½°ú °°Àº ¿À·ù°¡ ³³´Ï´Ù. ÀÌÀ¯¸¦ ¸ð¸£°Ú½À´Ï´Ù.

 StreamReader sr = new StreamReader(Server.MapPath("../Documents/") + "\\zipcode_20130201.csv", Encoding.Default);

       
        while (!sr.EndOfStream) // ÆÄÀÏÀÇ ³¡¿¡ µµ´ÞÇÒ ¶§±îÁö
        {
            // ÄÞ¸¶·Î ±¸ºÐÇؼ­ ÇÑÁÙ¾¿ Àоî¿À±â
            string[] arr = sr.ReadLine().Split(',');
            // Zip Å×À̺íÀÇ °¢°¢ÀÇ Çʵ忡 ÀúÀå
            try
            {
                DatabaseFactory.CreateDatabase("ConnectionString").ExecuteNonQuery(CommandType.Text, String.Format("Insert Zip Values('{0}','{1}','{2}','{3}','{4}');", arr[0], arr[1], arr[2], arr[3], arr[4]));
            }
       }

-----------------------------------------------
<¿À·ù¸Þ½ÃÁö>

Database provider factory not set for the static DatabaseFactory. Set a provider factory invoking the DatabaseFactory.SetProviderFactory method or by specifying custom mappings by calling the DatabaseFactory.SetDatabases method.


·Îµù½Ã°£ : 0.031 sec
±Û ´äº¯   ±Û ¼öÁ¤   ±Û »èÁ¦   ±Û ¸ñ·Ï


   
   
Ȩ ȸ»ç¼Ò°³ ÀÌ¿ë¾à°ü °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ ÀÌ¿ë¾È³» Q&A FAQ Guide