void StoredProcedureInitialization() { StoredProcQuery spQuery = new StoredProcQuery("StoredProcedure", "stored_procedure_name"); spQuery.Parameters.Add(new QueryParameter("@First", typeof(int), 0)); spQuery.Parameters.Add(new QueryParameter("@Second", typeof(string), "Value")); spQuery.Parameters.Add(new QueryParameter("@Third", typeof(string), "Value")); DataSource.Queries.Add(spQuery); }
static void Main(string[] args) { var connectionString = "Data Source=(localdb)\\MSSQLLocalDB; Initial Catalog=AmazingDb; Integrated Security=True;"; //Console.WriteLine("Enter schema name: "); //var schema = Console.ReadLine(); //Console.WriteLine("Enter stored procedure name: "); //var procName = Console.ReadLine(); var repository = new Repository(connectionString, "usp_AccessTypesGet"); var storedProcQuery = new StoredProcQuery(); var dataTable = repository.ParametersTableGet(); storedProcQuery.ParamaterNamesGet(dataTable); var dict = storedProcQuery.TableAndColumnNamesGet("fs"); //foreach (string param in parameters) //{ // Console.WriteLine(param); //} var data = repository.ParametersDataGet(dict); var query = storedProcQuery.QueryGet("fs", "usp_AccessTypesGet", data); Console.WriteLine(query); //Test methods //IDbConnection db = new SqlConnection(connectionString); //var data = db.Query("select * from fs.AccessTypes").ToList(); //var parametersNames = repository.ParametersNamesGet(); //var parametersData = repository.ParametersDataGet(parametersNames); //var query = new StoredProcQuery(procName, parametersNames, parametersData); //Console.WriteLine(query); }
internal StoredProc(string storedProcName) { Query = new StoredProcQuery(storedProcName); }