Exemplo n.º 1
0
        public DbConnectorJob <T, TDbConnection> NonQuery <T>(
            Action <IDbConnectorSettings> onInit,
            Func <int, DbParameterCollection, T> onExecute,
            Func <Exception, IDbResult <T>, IDbResult <T> > onError = null)
        {
            return(new DbConnectorJobTask <T, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                if (typeof(T).IsClass)
                {
                    return new DbResult <T>
                    {
                        Data = Activator.CreateInstance <T>()
                    };
                }
                else
                {
                    return new DbResult <T>
                    {
                        Data = default(T)
                    };
                }
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                int numberOfRowsAffected = cmd.ExecuteNonQuery();

                return onExecute(numberOfRowsAffected, cmd.Parameters);
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }
Exemplo n.º 2
0
        public DbConnectorJob <List <Dictionary <string, object> >, TDbConnection> ReadToDictionary(
            Action <IDbConnectorSettings> onInit,
            Func <List <Dictionary <string, object> >, List <Dictionary <string, object> > > onLoad = null,
            Func <Exception, IDbResult <List <Dictionary <string, object> > >, IDbResult <List <Dictionary <string, object> > > > onError = null,
            List <string> columnNamesToInclude = null,
            List <string> columnNamesToExclude = null)
        {
            return(new DbConnectorJobTask <List <Dictionary <string, object> >, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                return new DbResult <List <Dictionary <string, object> > >
                {
                    Data = new List <Dictionary <string, object> >()
                };
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                using (var odr = cmd.ExecuteReader())
                {
                    var data = odr.ToListDictionary(columnNamesToInclude, columnNamesToExclude);

                    if (onLoad != null)
                    {
                        data = onLoad(data);
                    }

                    return data;
                }
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }
Exemplo n.º 3
0
        public DbConnectorJob <List <T>, TDbConnection> Read <T>(
            Action <IDbConnectorSettings> onInit,
            Func <List <T>, List <T> > onLoad = null,
            Func <Exception, IDbResult <List <T> >, IDbResult <List <T> > > onError = null)
            where T : new()
        {
            return(new DbConnectorJobTask <List <T>, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                return new DbResult <List <T> >
                {
                    Data = new List <T>()
                };
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                using (var odr = cmd.ExecuteReader())
                {
                    var data = odr.ToList <T>();

                    if (onLoad != null)
                    {
                        data = onLoad(data);
                    }

                    return data;
                }
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }
Exemplo n.º 4
0
        public DbConnectorJob <bool, TDbConnection> NonQuery(
            Action <IDbConnectorSettings> onInit,
            Func <int, DbParameterCollection, bool, bool> onExecute       = null,
            Func <Exception, IDbResult <bool>, IDbResult <bool> > onError = null)
        {
            return(new DbConnectorJobTask <bool, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                return new DbResult <bool>();
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                int numberOfRowsAffected = cmd.ExecuteNonQuery();

                if (onExecute != null)
                {
                    return onExecute(numberOfRowsAffected, cmd.Parameters, true);
                }

                return true;
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }
Exemplo n.º 5
0
        public DbConnectorJob <T, TDbConnection> Read <T>(
            Action <IDbConnectorSettings> onInit,
            Func <DbDataReader, T> onLoad,
            CommandBehavior commandBehavior = CommandBehavior.Default,
            Func <Exception, IDbResult <T>, IDbResult <T> > onError = null)
        {
            return(new DbConnectorJobTask <T, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                return new DbResult <T>
                {
                    Data = default(T)
                };
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                using (var odr = cmd.ExecuteReader(commandBehavior))
                {
                    return onLoad(odr);
                }
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }
Exemplo n.º 6
0
        public DbConnectorJob <T, TDbConnection> ReadSingle <T>(
            Action <IDbConnectorSettings> onInit,
            Func <T, T> onLoad = null,
            Func <Exception, IDbResult <T>, IDbResult <T> > onError = null)
        {
            return(new DbConnectorJobTask <T, TDbConnection>
                   (
                       connectionString: _connectionString,
                       onInit: () =>
            {
                if (typeof(T).IsClass)
                {
                    return new DbResult <T>
                    {
                        Data = Activator.CreateInstance <T>()
                    };
                }
                else
                {
                    return new DbResult <T>
                    {
                        Data = default(T)
                    };
                }
            },
                       onSetCommand: () =>
            {
                var cmdModel = new DbConnectorSettings();

                onInit(cmdModel);

                return new List <IDbConnectorSettings>()
                {
                    cmdModel
                };
            },
                       onOpen: (cmd) =>
            {
                using (var odr = cmd.ExecuteReader(CommandBehavior.SingleRow))
                {
                    T data = odr.ToSingle <T>();

                    if (onLoad != null)
                    {
                        data = onLoad(data);
                    }

                    return data;
                }
            },
                       onError: (ex, result) =>
            {
                if (onError != null)
                {
                    result = onError(ex, result);
                }

                return result;
            }
                   ));
        }