Windows service to access MSSQL data through REST interface
$30-250 USD
Paguhet në dorëzim
I need a windows service that receives REST requests and depending on what is requested builds an SQL query joining needed tables, filters and columns and querying MSSQL database returning results to the client through REST interface. Database table relation structure (meta information) will be stored in separate database defining the resource/tablelist/columnlist relations so that SQL query can be generated properly.
REST URI request usually will look like this
/rest/resourcename/query?columns=[login to view URL],[login to view URL],B.COLUMN3&filter=[login to view URL] eq ‘filtervalue1’ AND [login to view URL] gt ‘filtervalue2’&orderby=[login to view URL],[login to view URL] DESC&limit=10&offset=300
and the response for the above query should be
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<collection>
<metadata>
<page>
<count>3</count>
<limited>true</limited>
<limit>10</limit>
<offset>300</offset>
<totalrows>[count of rows in unlimited query]</totalrows>
<sqlquery>SELECT [login to view URL] AS A_COLUMN1,[login to view URL] AS A_COLUMN2,[login to view URL] AS B_COLUMN3
FROM TABLE1 A INNER JOIN TABLE2 B ON A.SOME_ID_FIELD=B.SOME_ID_FIELD
WHERE A.COLUMN4='filtervalue1' AND [login to view URL] > 'filtervalue2'
ORDER BY [login to view URL],[login to view URL] DESC
OFFSET 300 ROWS FETCH NEXT 10 ROWS ONLY
</sqlquery>
</page>
</metadata>
<row>
<A_COLUMN1>value1</A_COLUMN1>
<A_COLUMN2>value2</A_COLUMN2>
<B_COLUMN3>value3</B_COLUMN3>
</row>
<row>
<A_COLUMN1>value1</A_COLUMN1>
<A_COLUMN2>value2</A_COLUMN2>
<B_COLUMN3>value3</B_COLUMN3>
</row>
<row>
<A_COLUMN1>value1</A_COLUMN1>
<A_COLUMN2>value2</A_COLUMN2>
<B_COLUMN3>value3</B_COLUMN3>
</row>
</collection>
Default response format is XML, but if in request header there is ‘Accept: application/json’ the same data should be returned in JSON format.
It should support HTTP Basic Authentication through request header.
It should cache SQL queries so that when requesting the same URL multiple times it should not build the SQL query again and again.
It would be good to use some caching mechanism so that service can return frequently used data from cache without requesting the database. This is not required for 1st version.
It would be good if service can be run on Windows Vista and newer.
There is no need for installer. Just some instructions how to install/uninstall on Windows manually.
Regarding Programming language/IDE there is no restrictions except I must be able to edit and compile the source code on my PC using tools available for free. I have some experience with Pascal/Lazarus, Visual C#, Visual Basic, etc
The service must be able to serve multiple requests from many clients simultaneously.
It must not depend on anything else than Windows and .Net Framework. I do not want to install IIS or something else.
As normal REST service it must be accessible through Web browser
ID Projekti: #14835812
Rreth projektit
Është zgjedhur fitues:
Good day i can do this project on Lazarus + MORMOT framework Relevant Skills and Experience You can review my profile . I have enough experience for this Proposed Milestones $30 USD - Good amount
32 profesionistë freelancer dërguan një ofertë mesatare prej $174 për këtë punë
I am a full stack developer. I have more than 4 years experience on development. Relevant Skills and Experience ASP.NET, C# and SQL Server Proposed Milestones $155 USD - Cost What is your deadline?
I am 9+ Years of Experienced Software Developer,confident about to complete the project. Stay tuned, I'm still working on this proposal.
Hello, I'm interested to work on this. Please share more details. My proposal is to develop a Windows service in C#. Thanks, Sheik
Relevant Skills and Experience C# Xamarin WebApi WPF/WinForms Asp.net-MVC Asp.net webforms Jquery javascript Entity Framework Linq Nhibernate Json FIX Protocol Office 365 Sharepoint online Proposed Milestones $155 US Më shumë
hello , I'm having good knowledge in Delphi development. I have done similar kind projects already. I can complete your task on time. please let me know if you are interested to do business with me.
We are a Team of Technical Consultants and Data Engineers having healthy experience into Big Data technologies,IOT/Cloud/AWS and Python/AI+Machine Learning. The Dynamic force has qualified engineers having expertise in Më shumë
I have gone through the requirement, I can do it. I have 13yrs experience in microsoft technologies including Web, Windows and mobile programming Relevant Skills and Experience I have more than 13 yrs exp as Architect Më shumë
Hi There, Greetings of the day .! i would like to make a proposal for your development of Widows service which accepting rest. Worked on desktop & web app, on several big n-tierd projects on C#.Net Relevant Skills Më shumë
hi i have done lot of projects in this domain lets discuss more in chat thanks Relevant Skills and Experience .NET, C# Programming, Delphi, Microsoft SQL Server, RESTful Proposed Milestones $30 USD - Complete work
Will finished with document Relevant Skills and Experience I am working 8 various Microsoft technologies.c# .net,azure ,wcf,web api.
