´äº¯ °¨»çÇÕ´Ï´Ù.
´Ã ÁÁÀº °ÀÇ¿¡ °¨»çÇÏ°í ÀÖ½À´Ï´Ù.
¹Ú¿ëÁØ °»ç ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä.
´äº¯ÀÌ ´Ê¾î Á˼ÛÇÕ´Ï´Ù.
Enterprise Library´Â
6.0 ¹öÀü´ë·Î µé¾î¼¸é¼,
¾Õ¼ ¸»¾¸ÁֽŰÍó·³,
static ¹æ½Ä ´ë½Å¿¡ new¸¦ »ç¿ëÇÏ´Â ÀνºÅϽº ¹æ½ÄÀ¸·Î º¯°æµÇ¾ú½À´Ï´Ù.
Àú ¶ÇÇÑ, SqlDataReader·Î µÈ ºÎºÐÀº DataSetÀ¸·Î º¯°æÇß´ø ±â¾ïÀÌ ³³´Ï´Ù.
ÃÖ±Ù 2³â ³»¿¡´Â Enterprise Library ´ë½Å¿¡ Entity Framework¿Í Dapper.NET¸¸À»
»ç¿ëÇÏ°í ÀÖ¾î¼,
Âü°í¿ëµµ·Î °ÀÇ¿ë °Ô½ÃÆÇ ¼Ò½º Áß¿¡¼ Enterprise Library 6 ¹öÀüÀ» »ç¿ëÇÑ ºÎºÐ ¼Ò½º¸¦ ¿Ã·Áµå¸³´Ï´Ù.
Âü°íÇØ º¸¼¼¿ä...
using System;
using DotNetNote.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data;
namespace DotNetNote.Data
{
public class DotNetNoteData : DacBase
{
///
/// µ¥ÀÌÅÍÀÔ·Â
///
/// ¿£ÅÍƼ °³Ã¼
public void WriteDotNetNote(DotNetNote.Entity.DotNetNote dnn)
{
Database db = (new DatabaseProviderFactory()).Create("ConnectionString");
db.ExecuteNonQuery("WriteDotNetNote", dnn.Name, dnn.Email, dnn.Title, dnn.PostIP, dnn.Content, dnn.Password, dnn.Encoding, dnn.Homepage, dnn.FileName, dnn.FileSize);
}
///
/// ¸®½ºÆ®
///
///
///
public System.Data.DataSet ListDotNetNote(int intPage)
{
Database db = (new DatabaseProviderFactory()).Create("ConnectionString");
return db.ExecuteDataSet("ListDotNetNote", intPage);
}
///
/// ·¹ÄÚµå Ä«¿îÆ®
///
///
public int GetCountDotNetNote()
{
Database db = (new DatabaseProviderFactory()).Create("ConnectionString");
return Convert.ToInt32(db.ExecuteScalar(System.Data.CommandType.StoredProcedure, "GetCountDotNetNote"));
}
///
/// °Ë»ö °á°ú ·¹ÄÚµå ¼ö ¹Ýȯ ¸Þ¼µå
///
public int GetCountDotNetNoteByWord(string searchField, string searchQuery)
{
return Convert.ToInt32((new DatabaseProviderFactory()).Create("ConnectionString")
.ExecuteScalar("GetCountDotNetNoteByWord", searchField, searchQuery));
}
///
/// »ó¼¼
///
///
///
public DataSet ViewDotNetNote(int num)
{
//return (new DatabaseProviderFactory()).Create("ConnectionString").ExecuteDataSet("ViewDotNetNote", num);
return (new DatabaseProviderFactory()).Create("ConnectionString")
.ExecuteDataSet("ViewDotNetNote", num);
}
///
/// ´äº¯
///
///
public void ReplyDotNetNote(DotNetNote.Entity.DotNetNote dnn)
{
(new DatabaseProviderFactory()).Create("ConnectionString")
.ExecuteNonQuery(
"ReplyDotNetNote",
dnn.Name,
dnn.Email,
dnn.Title,
dnn.PostIP,
dnn.Content,
dnn.Password,
dnn.Encoding,
dnn.Homepage,
dnn.ParentNum,
dnn.FileName,
dnn.FileSize
);
}
public int ModifyDotNetNote(DotNetNote.Entity.DotNetNote dnn)
{
int result = 0;
result = Convert.ToInt32((new DatabaseProviderFactory()).Create("ConnectionString")
.ExecuteScalar(
"ModifyDotNetNote",
dnn.Name, dnn.Email, dnn.Title, dnn.ModifyIP, dnn.Content, dnn.Password,
dnn.Encoding, dnn.Homepage, dnn.Num
));
return result;
}
///
/// »èÁ¦
///
/// 0ÀÌ ¹ÝȯµÇ¸é ¾ÏȣƲ¸², 1ÀÌ»óÀÌ¸é »èÁ¦
public int DeleteDotNetNote(int num, string password)
{
return (new DatabaseProviderFactory()).Create("ConnectionString")
.ExecuteNonQuery("DeleteDotNetNote", num, password);
}
///
/// °Ë»ö
///
public DataSet SearchDotNetNote(string searchField, string searchQuery, int intPage)
{
return (new DatabaseProviderFactory()).Create("ConnectionString").ExecuteDataSet(
"SearchDotNetNote", searchField, searchQuery, intPage);
}
///
/// ´Ù¿î¼ö Áõ°¡
///
///
public void UpdateDownCount(int num)
{
(new DatabaseProviderFactory()).Create("ConnectionString").ExecuteNonQuery("UpdateDownCount", num);
}
}
}
ÁöÁ¾¿Ï ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä, ¹Ú¿ëÁØ°»ç´Ô.
ASP.NET3.5 ¼îÇθô °Á¸¦ µè°í ÀÖ½À´Ï´Ù. ±×·±µ¥, Enterprise6 ¹öÀü¿¡¼
DatabaseFactory.CreateDatabase(" ")¸¦ ¾²´Ï±î, IE ½ÇÇà½Ã ´ÙÀ½°ú °°Àº ¿À·ù°¡ ³ª´õ¶ó±¸¿ä.
Enterprise Library 6: InvalidOperationException - 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
±×·¡¼, ¾î¶»°Ô ÇؾßÇÒÁö ¸ð¸£°Ú½À´Ï´Ù.
°Ë»öÇؼ ÇÑ °¡Áö ¹æ¹ýÀ» ã¾Æ¼ Àû¿ëÇغôµ¥,
´ÙÀ½°ú °°ÀÌ ¾µ ¶§´Â ¿À·ù°¡ ¾È³ª´Â °Ô ÀÖ°í, ¿À·ù°¡ ³¯ ¶§°¡ ÀÖ´õ¶ó±¸¿ä. Casting¹®Á¦ÀÎ °Í °°Àºµ¥¿ä...
¹ÝȯÇü½ÄÀÌ DataSetÀÎ °æ¿ì´Â ±¦ÂúÀºµ¥, SqlDataReaderÀÎ °æ¿ì´Â ¿À·ù°¡ ³ª´Âµ¥, ¾î¶»°Ô CastingÇؾßÇÒÁö? ÀÌ°Í ¸»°í ´õ ¹ü¿ëÀ¸·Î ¾²ÀÏ ¼ö ÀÖ´Â ¹æ¹ýÀÌ ÀÖÀ¸¸é ´äº¯ ºÎŹµå¸³´Ï´Ù.
DatabaseProviderFactory factory = new DatabaseProviderFactory();
return (SqlDataReader)factory.Create("ConnectionString"). ......