Hi,
This can be achieved by designing database in SQL Server and a WCF Service that will communicate with database using Entity Framework. The UI (Win/Web) will communicate with this WCF service to get/set data in database. In this way there will be a clear separation between logic and presentation and same service can be used in future for like mobile apps.
I have 8.5 years experience in C# win-forms, ASP.NET, WCF and SQL Server.
Thanks,
Ajay