¾È³çÇϼ¼¿ä. ¹Ú¿ëÁØ°»ç´Ô.
¼îÇθô °Á ÇÁ·ÎÁ§Æ® ºÎºÐ¿¡¼ »ç¿ëµÇ¾ú´ø 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.
|