Remote client- server application

[Polon]

Hello!

Let me explain my task...

I have a computer (Server).

It runs firebird database.

I have another computer (Client).

Server and Client are in different towns.

People working on Client are supposed to be allowed to make some changes to
the database (insert, edit, delete data in one of the tables).

Questions:

1. What technology should I be using?
2. Web services maybe?
3. But is it possible to write a web service that connects to firebird
database?
4. What about security?
5. How can I start?
6. Any book or link?


Thank you!

 

[Arne Vajhøj]

Let me explain my task...

I have a computer (Server).

It runs firebird database.

I have another computer (Client).

Server and Client are in different towns.

People working on Client are supposed to be allowed to make some changes to
the database (insert, edit, delete data in one of the tables).

Questions:

1. What technology should I be using?
2. Web services maybe?
3. But is it possible to write a web service that connects to firebird
database?
4. What about security?

There are dozens of possibilities, but given that you have asked in
a C# group, then let us assume that you will want to use C#.

A couple of the more obvious choices in that case:

browser----(HTML/HTTP)----ASP.NET/C# web app----database

C# desktop app----(SOAP/HTTP)----WCF/C# web service----database

FireBird provides an ADO.NET provider so no problem
connecting to FireBird.

Requiring login with username/password should not be a
problem.

5. How can I start?
6. Any book or link?

How much C# and .NET do you know?

Arne

 

[Polon]

There are dozens of possibilities, but given that you have asked in
a C# group, then let us assume that you will want to use C#.

A couple of the more obvious choices in that case:

browser----(HTML/HTTP)----ASP.NET/C# web app----database

C# desktop app----(SOAP/HTTP)----WCF/C# web service----database

FireBird provides an ADO.NET provider so no problem
connecting to FireBird.

Requiring login with username/password should not be a
problem.


How much C# and .NET do you know?

Just started really.

Polon

 

[Polon]

Must admit I am confused here.

So many new technologies, abbrevations I do not understand, my brain is
boiling.

So...

Can anyone suggest a nice book that will lead me step by step through
different possible implementations of C# in a real world.

Something about WCF for a start...

Thank you!

Polon

 

[Arne Vajhøj]

Just started really.

Start with the basic stuff and then build up.

It takes time to learn advanced stuff.

Arne

 

[Arne Vajhøj]

Must admit I am confused here.

So many new technologies, abbrevations I do not understand, my brain is
boiling.

..NET is huge.

So...

Can anyone suggest a nice book that will lead me step by step through
different possible implementations of C# in a real world.

Something about WCF for a start...

You need to understand C# first. Start there and then
move to WCF later.

Or maybe even use the old .asmx web services. WCF is better,
but the old stuff is a lot simpler to get started with.

Arne

 

[Arne Vajhøj]

How much experience do you have? If you have expertise in other
languages, then things might not be so hard for you to pickup.

http://www.dofactory.com/Framework/Framework.aspx

Each one of the so called *real world apps* will show you how to do it.
Each solution uses the same back-end using WCF. The only thing different
is what client application type ASP.NET Web form, Windows Desktop form,
Windows Presentation Foundation etc etc on the front-end uses the back-end.

The thing different in your case is you won't be using Linq-2-SQL or
ADO.NET Entity Framework. You will be using your database.

FireBird supports EF.

Arne

 

[Polon]

Thank you Big Steel and Arne Vajhoj!

You helped me a lot.

Have a nice day

Polon