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