Em Andamento

Windows service to access MSSQL data through REST interface

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=[url removed, login to view],[url removed, login to view],B.COLUMN3&filter=[url removed, login to view] eq ‘filtervalue1’ AND [url removed, login to view] gt ‘filtervalue2’&orderby=[url removed, login to view],[url removed, login to view] 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 [url removed, login to view] AS A_COLUMN1,[url removed, login to view] AS A_COLUMN2,[url removed, login to view] AS B_COLUMN3

FROM TABLE1 A INNER JOIN TABLE2 B ON A.SOME_ID_FIELD=B.SOME_ID_FIELD

WHERE A.COLUMN4='filtervalue1' AND [url removed, login to view] > 'filtervalue2'

ORDER BY [url removed, login to view],[url removed, login to view] 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

Habilidades: .NET, Programação C#, Delphi, Microsoft SQL Server , RESTful

Ver mais: mysql rest api generator, mysql rest interface, mysql rest api php, mysql http plugin, mysql rest plugin, mysql rest api json, mariadb rest api, ms sql rest api, python data rest web service, sending json data rest service, data rest service, windows service waiting data table, windows service weather data, windows service import csv file data, source code net windows service import data csv file sql server

Acerca do Empregador:
( 1 comentário ) Riga, Latvia

ID do Projeto: #14835812

Premiar a:

kukhtinigor

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

$30 USD em 10 dias
(73 Avaliações)
7.0

34 freelancers estão ofertando em média $171 para este trabalho

customizedata

I have gone through the [url removed, login to view] of windows service it is better if we make the executable as scheduled [url removed, login to view] far as the caching is concerned, it is better to implement caching at sql level. Relevant Skills a Mais

$245 USD in 5 dias
(145 Comentários)
6.8
$30 USD em 1 dia
(669 Comentários)
7.0
igors233

Robust REST server for handling numerous concurrent clients, written in Delphi using kernel mode windows [url removed, login to view] driver (fastest possible on Windows) Relevant Skills and Experience Years of Delphi experience in clien Mais

$388 USD in 15 dias
(63 Comentários)
6.6
papon13

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?

$155 USD in 3 dias
(68 Comentários)
6.2
$333 USD in 7 dias
(26 Comentários)
5.6
$138 USD in 3 dias
(28 Comentários)
5.9
Gates777

Hello? I am very interesting in your project I have read your description carefully and i can do this in a short time with high quality Please contact me Let discuss more details together on chat Relevant Skills and E Mais

$155 USD in 3 dias
(28 Comentários)
5.6
BitSDestiny

I am 9+ Years of Experienced Software Developer,confident about to complete the project. Stay tuned, I'm still working on this proposal.

$150 USD in 3 dias
(32 Comentários)
5.6
mauricemarinus

Hi. I think I may have a solution for you as far as parsing goes. But it will only work for MS SQL Queries. Relevant Skills and Experience 17 yers software developer 10+ C#/VB.Net Proposed Milestones $111 USD - Deliv Mais

$111 USD in 10 dias
(66 Comentários)
5.4
sheikDev

Hello, I'm interested to work on this. Please share more details. My proposal is to develop a Windows service in C#. Thanks, Sheik

$148 USD in 3 dias
(42 Comentários)
5.3
pgcan

Hi, I think the best solution would be to create a WCF Rest Service and Host this service on windows service. I have done similar project before and it would be an easy one for me. Relevant Skills and Experience I am Mais

$300 USD in 6 dias
(11 Comentários)
5.3
seefattechnologi

I have 5 Years experience in analysis and development of client/server, windows and web applications using Microsoft Visual Studio .Net IDE using C#, ASP.NET, SQL Server, MVC. Relevant Skills and Experience For curren Mais

$300 USD in 10 dias
(14 Comentários)
5.2
ghyfer

Hi sir, i'm an experienced developer, hopefully could help your work, please check my profile for further info. Relevant Skills and Experience ASP.NET, C#, XML, SQL SERVER, JSON, Restfull Proposed Milestones $150 USD Mais

$150 USD in 3 dias
(13 Comentários)
4.5
murtaza1981

Hi, Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. Thanks, Murtaza Relevant Skills and Experience Hi, An ASP.NET,c#,vb , [url removed, login to view], NopCommerce,S Mais

$350 USD in 3 dias
(11 Comentários)
4.5
prasadak82

A proposal has not yet been provided

$55 USD em 1 dia
(18 Comentários)
4.1
diegofpr

Hello, I have only one doubt about the tables, as they don't seem to appear in your example. Habilidades y experiencia relevante I am a developer with more than 15 years of experience, the last ten in web development, Mais

$150 USD in 4 dias
(13 Comentários)
4.2
wasifmuneer

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 Mais

$155 USD in 3 dias
(10 Comentários)
4.3
$155 USD in 3 dias
(3 Comentários)
4.3
$155 USD em 1 dia
(8 Comentários)
4.8
Alprn2558

I would like to help you with your project. I understood the general concept and i would like to talk for details Relevant Skills and Experience I am an experienced .NET Devleoper for both Web & Desktop. Good at Front Mais

$100 USD in 3 dias
(10 Comentários)
3.7