internal override QueryConverter CreateQueryConverter(SqlFactory sql) { return(new PgsqlQueryConverter(services, typeProvider, translator, sql) { ConverterStrategy = ConverterStrategy.CanUseJoinOn });; }
public void Initialize() { //Need to setup the logger first if (LoggingEnabled) LoggerProvider = Options.LoggerProvider ?? new SystemLoggerProviderLog4Net(this); _logger = LoggerProvider.CreateLogger(typeof(Settings)); //Setting up the rest of the system _logger.Info("Settings - Setup Started"); _logger.Debug(() => string.Format("Settings - Settings Extension Options - {0}", Options)); var sqlFactory = new SqlFactory(); var feedProvider = new NugetReleaseFeedProvider(); var persistencyProvider = new ReleasePersistencyProvider(sqlFactory); QueryProvider = new CacheReleaseQueryProvider(); ExistingReleaseService = new ExistingReleaseQueryService(QueryProvider); NewReleaseService = new NewReleaseQueryService(QueryProvider); UpdateReleaseRepositoryService = new UpdateReleaseRepositoryService(feedProvider, persistencyProvider); UpdateReleaseService = new UpdateReleaseService(this, UpdateReleaseRepositoryService, QueryProvider); ReleaseService = new ReleaseService(QueryProvider); _logger.Info("Settings - Setup Finished"); //Run system setup _logger.Info("Settings - Pre Initialize"); UpdateReleaseService.Execute(true); _logger.Info("Settings - Post Initialize"); }
public static SqlFactory CreateInstance <T>() where T : System.Data.Common.DbProviderFactory { SqlFactory fac = CreateInstance <T>(null); return(fac); }
public ActionResult VoteQuestionAdd() { DbUser user = base.Session["user"] as DbUser; List <VotePersons> list = SqlFactory.GetSqlhelper().CreateWhere <VotePersons>().Where(o => o.VoteID == user.LimitVoteID).Select(); base.ViewData["persons"] = list; return(base.View()); }
public ProposalRepository() { sqlcmd = SqlFactory.MSSQL(); prop = new Proposal(); propinfo = new ProposalInfo(); // ...MoreComing. }
public static void FactoryMethod() { DbFactory dbFactory = new SqlFactory(); IConnection sqlConn = dbFactory.ConnectToDb(); DbFactory dbFactory2 = new OracleFactory(); IConnection oracleConn = dbFactory2.ConnectToDb(); }
// constructors public Database(DbModel dbModel, DbSettings settings) { this.DbModel = dbModel; Settings = settings; _driver = Settings.Driver; _timeService = dbModel.EntityApp.TimeService; SqlFactory = new SqlFactory(dbModel); }
public int ExecuteNonQuery(string sql) { using (var command = SqlFactory.CreateCommand()) { command.CommandText = sql; return(ExecuteNonQuery(command)); } }
//public new DbConnection Connection //{ // get // { // this.CheckDispose(); // this.CheckInitialized(); // return ((Connection)this.conManager.Connection).Source; // } //} internal override QueryConverter CreateQueryConverter(SqlFactory sql) { return(new SQLiteQueryConverter(services, typeProvider, translator, sql) { ConverterStrategy = ConverterStrategy.CanOutputFromInsert | ConverterStrategy.CanUseJoinOn | ConverterStrategy.CanUseOuterApply & ConverterStrategy.CanUseRowStatus }); }
public virtual System.Collections.Generic.List <System.Data.IDbDataParameter> BuildParams__TokenKey() { System.Collections.Generic.List <System.Data.IDbDataParameter> paramlist = new System.Collections.Generic.List <System.Data.IDbDataParameter>(); System.Data.IDbDataParameter p_TokenKey = SqlFactory.CreateParam("@TokenKey", System.Data.SqlDbType.VarChar); SetParameterValue(p_TokenKey, _TokenKey); paramlist.Add(p_TokenKey); return(paramlist); }
internal override QueryConverter CreateQueryConverter(SqlFactory sql) { return(new SqlQueryConverter(services, typeProvider, translator, sql) { ConverterStrategy = ConverterStrategy.CanUseJoinOn | ConverterStrategy.CanUseRowStatus | ConverterStrategy.CanUseScopeIdentity }); }
// Methods internal Translator(IDataServices services, SqlFactory sqlFactory, ITypeSystemProvider typeProvider, SqlProvider provider) { this.services = services; sql = sqlFactory; this.typeProvider = typeProvider; this.provider = provider; }
public ActionResult VoteBonusAdd(TF.WeiXinVote.Data.VoteBonus bonus) { DbUser user = base.Session["user"] as DbUser; bonus.VoteID = user.LimitVoteID; SqlFactory.GetSqlhelper().Save <TF.WeiXinVote.Data.VoteBonus>(bonus); return(base.Success()); }
public ActionResult VotePageAdd(VotePages page) { DbUser user = base.Session["user"] as DbUser; page.VoteID = user.LimitVoteID; SqlFactory.GetSqlhelper().Save <VotePages>(page); return(base.Success()); }
public async Task <List <SubTableInfo> > GetSubTableList(string conn, string tableName) { string sql = "SELECT * FROM Ray_SubTable where TableName=@TableName"; using (var connection = SqlFactory.CreateConnection(conn)) { return((await connection.QueryAsync <SubTableInfo>(sql, new { TableName = tableName })).AsList()); } }
public BudgetRepository() { //string connString = Settings.Default.EntityConnection; // Context = new BOTADBEntities1(); Connection conn = new Connection(); connectString = conn.GetDirectConnString(); sqlcmd = SqlFactory.MSSQL(); }
public AbstractUnitTest() { var sqlModule = new DBLibrary.Configuration.EntryPoint(typeof(Portal), "DBConnect"); var kernel = new StandardKernel(sqlModule.GetModules()); BaseFactory.Instance = new BaseFactory(kernel); Factory = Database.Current.Factory; sqlModule.Load(); }
public object ExecuteScalar(string sql) { using (var command = SqlFactory.CreateCommand()) { command.CommandText = sql; command.Transaction = CurrentTransaction; return(ExecuteScalar(command)); } }
/// <summary> /// Deletes all rows from the specified Table /// </summary> public void TruncateTable(string tableName) { var connection = GetWriteConnection(); using var command = SqlFactory.CreateCommand(); command.Connection = connection; command.CommandText = $"DELETE FROM {tableName}"; command.ExecuteNonQuery(); }
public ActionResult VoteQuestionEdit(int id) { VoteQuestions model = SqlFactory.GetSqlhelper().SingleById <VoteQuestions>(id); DbUser user = base.Session["user"] as DbUser; List <VotePersons> list = SqlFactory.GetSqlhelper().CreateWhere <VotePersons>().Where(o => o.VoteID == user.LimitVoteID).Select(); base.ViewData["persons"] = list; return(base.View(model)); }
public ActionResult Index(string mobile = "") { List <VoteBonusRecord> model = new List <VoteBonusRecord>(); if (!string.IsNullOrEmpty(mobile)) { model = SqlFactory.GetSqlhelper().CreateWhere <VoteBonusRecord>().Where(o => o.UseDate == null).Where(o => o.Mobile == mobile).Select().Where(o => o.Bonus.Title != "现金红包").ToList(); } return(base.View(model)); }
public ActionResult Get(PostModel postModel, string echostr, int id) { string token = SqlFactory.GetSqlhelper().SingleById <VoteInfos>(id).Token; if (CheckSignature.Check(postModel.Signature, postModel.Timestamp, postModel.Nonce, token)) { return(base.Content(echostr)); } return(base.Content("failed:" + postModel.Signature + "," + CheckSignature.GetSignature(postModel.Timestamp, postModel.Nonce, token) + "。如果你在浏览器中看到这句话,说明此地址可以被作为微信公众账号后台的Url,请注意保持Token一致。")); }
// Methods internal Visitor(Options options, IEnumerable <SqlParameter> parentParameters, SqlFactory sqlFactory, SqlIdentifier sqlIdentity) { this.options = options; this.sql = sqlFactory; this.canJoin = true; this.isTopLevel = true; this.parentParameters = parentParameters; this.sqlIdentity = sqlIdentity; }
/// <summary> /// Deletes all rows from the specified Table /// </summary> public void TruncateTable(string tableName) { var connection = GetConnection(); using (var command = SqlFactory.CreateCommand()) { command.Connection = connection; command.CommandText = string.Format("DELETE FROM {0}", tableName); command.ExecuteNonQuery(); } }
public virtual System.Collections.Generic.List <System.Data.IDbDataParameter> BuildParams__EndpointID_ContextID() { System.Collections.Generic.List <System.Data.IDbDataParameter> paramlist = new System.Collections.Generic.List <System.Data.IDbDataParameter>(); System.Data.IDbDataParameter p_EndpointID = SqlFactory.CreateParam("@EndpointID", System.Data.SqlDbType.VarChar); SetParameterValue(p_EndpointID, _EndpointID); paramlist.Add(p_EndpointID); System.Data.IDbDataParameter p_ContextID = SqlFactory.CreateParam("@ContextID", System.Data.SqlDbType.VarChar); SetParameterValue(p_ContextID, _ContextID); paramlist.Add(p_ContextID); return(paramlist); }
private void GetPersonDetail() { string name = HttpContext.Current.Request.QueryString["person"]; int voteid = int.Parse(HttpContext.Current.Request.QueryString["voteid"]); VotePersons persons = SqlFactory.GetSqlhelper().CreateWhere <VotePersons>().Where(o => (o.VoteID == voteid) && (o.RealName == name)).SingleOrDefault(); if (persons != null) { HttpContext.Current.Response.Write(persons.Description); } }
public AccountRepository() { // conn = new Connection(); // _configuration = ObjectFactory.GetInstance<IConfiguration>(); account = new Account(); sqlcmd = SqlFactory.MSSQL(); //Later we can add more like SqlFactory.Oracle(); Which will still have the same sqlcmd.GetUserByName(Username) methods. //How? StrucuteMapBootStrapper will switch the ISqlCommands to another Implementer! }
public ActionResult VoteQuestionAdd(VoteQuestions question) { DbUser user = base.Session["user"] as DbUser; question.VoteID = user.LimitVoteID; if (string.IsNullOrEmpty(question.Person)) { return(base.Error("请选择关联人员")); } SqlFactory.GetSqlhelper().Save <VoteQuestions>(question); return(base.Success()); }
/// <summary> /// 쿼리를 실행하여 object을 반환하는 Web Method를 실행합니다. /// </summary> /// <param name="dbName">DB 연결정보</param> /// <param name="command">Command String</param> /// <param name="cmdType">Command Type</param> /// <param name="paramList">Command Parameters</param> /// <param name="valueList">Command Parameters Values</param> /// <param name="outParam"></param> /// <param name="outValue"></param> /// <returns></returns> /// <remarks> /// 2009-01-08 최초생성 : 황준혁 /// 변경내역 /// /// </remarks> public object NTx_ExecuteScalar(string dbName, string command, string cmdType, string[] paramList, object[] valueList, string[] outParam, ref object[] outValue) { try { SqlFactory wsProxy = new SqlFactory(_webUrl); return(wsProxy.NTx_ExecuteScalar(command, cmdType, paramList, valueList, outParam, ref outValue)); } catch { throw; } }
/// <summary> /// DataTable을 사용하여 쿼리를 실행하여 Multi 처리하고 영향을 받은 Row 수를 반환하는 Web Method를 실행합니다. /// </summary> /// <param name="dbName">DB 연결정보</param> /// <param name="command">Command String</param> /// <param name="cmdType">Command Type</param> /// <param name="paramList">Command Parameters</param> /// <param name="dt">Command Parameters Values(DataTable)</param> /// <param name="outParam">Output Parameters</param> /// <param name="outValue">Output ParametersValue</param> /// <returns></returns> public int Tx_ExecuteNonQueryByDataTable(string dbName, string command, string cmdType, string[] paramList, DataTable dt, string[] outParam, ref object[] outValue) { try { SqlFactory wsProxy = new SqlFactory(_webUrl); return(wsProxy.Tx_ExecuteNonQueryByDataTable(command, cmdType, paramList, dt, outParam, ref outValue)); } catch { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (this.Session["openid"] == null) { Fun.Error("参数错误"); } string openid = this.Session["openid"].ToString(); var enumerable = SqlFactory.GetSqlhelper().CreateWhere <VoteBonusRecord>().Where(o => o.OpenId == openid).Select(); this.DataList.DataSource = enumerable; this.DataList.DataBind(); }