C# Development of Proof of Concept for Simple SQL runner tool.
Budget
157$
per month
Posted: 4 year ago
Opened
- Description
- We are looking for a super basic console app poc using .net core 2.2 for the following, no authentication is needed as the SQL authentication will use the same credentials as the app runs (so no need to put in additional credentials)
Brief:
I want to be able to test SQL query times through C# as part of a console app that loops through a folder set of .SQL files. We completely not bothered about the output of the query just the query run time of how long the query takes to execute.
Targets:
-The code scans the configured programme folder (just needs to be a folder from the run directory) to see if there is a folder called sqlrunner contained within it.
-If SQL runner exists it will enumerate any following folders inside sqlrunner folder
-If there are folders that have SERVER01.domain.com in them then the programme needs to open these folders
-Within the SERVER01.domain.com folder there will be .SQL files that have an SQL query in it
-Then the program will loop through each of the folders and scan all the IP addresses against the .SQL files and return the query time per SQL query.
-All the results (I.e SQL IP, Nameof.SQLfile,timescripttakedtorun) to be written to a dictionary collection and written out on screen will be just fine.
Basically what this will allow me to do is have this agent running on all my clients networks and we can just add .SQL files to SERVER01.domain.com folders to add more SQL servers / .SQL jobs to scan against that server IP_
Considerations:
No GUI needed at all just write results to console
Should be a fairly small Poc (so would like a high level estimate up front if Poss.), its probably a few hours work not much if you know what your doing.
No login authentication needed as the SQL script will just be run
No Async or TPL needed just boring synchronous is fine
You will need to have a little free MS Sql instance available to test.
This should be a fairly simple set of interactions with some local folders / .sql files and a loop to run the SQLs against the database and add the return time to a dictionary collection.
Skills:
structured query language (sql),Microsoft SQLServer,.net framework,authentication,C# programming language,database,graphical user interface (GUI),Internet Protocol Address (IP Address),software development
- Category
Source: peopleperhour.com
Drag