WCF Service for Remote SQL Access

I need an experienced coder to create a solution using WCF to do the following.

I will have a website that will allow users to login and sign up for services. These services require access to data from their server. I require the ability to connect from the website host on our server to access a service running on their server remotely over the internet and execute SQL and return datatables. I will have a service that the user will install on their server and enter a username and password to match their website account , configure access to their MS SQL database, and then save these settings and run silently in the background.

The above is the general usage of the solution, here are the requirements of what you must deliver.

Code is to be in vb.net using .net 4.0

You must build a complete solution the demonstrates all of the required abilities

Authentication and Authorization is to be via the standard ASP.net SQL provider with Roles

WCF must be used to talk between the server and the service on the client server

All communication between the server and client server must be secure (HTTPS)

The sample solution must have a webform that executes some SQL and then returns the data and binds it to a datagrid.

You can use the northwinds db for your example

You must create an installer for the client service and this installer must have the ability to configure the access to the local MS SQL server, this access will may use Domain Authentication or Username and Password. The user must also be able to enter the Main website username and password and store these for the client service to use.

Queries must be run using events so the execution is immediate. No timers my be used in the solution, all things must be event driven.

Beceriler: Microsoft, Yazılım Mimarisi, SQL, Visual Basic

Daha fazlasını gör: wcf example, what is vb net used for, wcf host, service for you, service database access, my sql create database, do a service, asp.net data driven website, asp.net database driven website, asp net database driven website, access database services, what is ms sql, ms sql client, sql and c, SQL Access, net wcf, ms access 2013, i need a sql coder, c# wcf, c wcf, build sql, build database sql, asp connect sql server, website wcf, installer build

İşveren Hakkında:
( 32 değerlendirme ) Saint Joseph, United States

Proje NO: #4399169



Hi, This can be achieved by designing a WCF service and a SETUP project to install it on client side. I have 8 years experience in ASP.NET, C#, WCF and SQL Server.

%selectedBids___i_period_sub_7% gün içinde 770%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(9 Değerlendirme)

6 freelancers are bidding on average $611 for this job


Hi, interested to work on, with heigh experience in .NET technologies (WCF, WPF, WebServices ....) i guarantee you the best product, pm me for some clarification

in %bids___i_period_sub_35% gün içinde800%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

Please check your Pm

in %bids___i_period_sub_35% gün içinde693%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

consider it done . !!! check pm.

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

I will work on this and complete as per your requirement.

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi I have studied your requirements. I have a solution for the above requirements, in which I will build a WCF data service and WPF as its front end. Please see the PMB for further details. Regards Looking forwa Daha Fazla

in %bids___i_period_sub_35% gün içinde550%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)