Entity Framework DB Connection

간단히 테스트 할 수 있는 버전

 

 

using System; using System.Collections.Generic; using System.Linq; using System.Data.SqlClient; using System.Data.Entity; using kaishaku.FrameWork.Base; using DTO.Common.Common; using DTO.Common.Cocktail; namespace BIZ.Common.Dac { public class CommonCodeDAO : DacBase { public List<CommonCodeDTO> COMMON_CODE_LIST(string company, string highCode) { using (var con = new DbContext(@"Data Source=192.168.18.13;Initial Catalog=Kaishaku; Persist Security Info=True;User ID=sa;Password=1111")) { var sp = "dbo.Z_UP_COMMON_CODE_LIST @PARAM1"; return con.Database.SqlQuery<CommonCodeDTO>(sp, new SqlParameter("@ComCode", company) , new SqlParameter("@HighCode", highCode)).ToList(); } } } }

사용 법

 

List<CommonCodeDTO> lstData = (new CommonCodeDAO()).COMMON_CODE_LIST("060", "006000");