from access to .net with vidyano

Copyright © 2011 - Rhea NV

&

• Introduction

• Migrating from Access– Business Drivers

• Microsoft Modern Technology Platform

• Move to .NET– Challenges

• .NET with Vidyano

• Demo

• Rhea Your Partner


• Rhea - Member of iCros

• +250 IT Specialist

• Microsoft, Oracle, Java

• iCros - Member of Cronos

• +1800 IT Specialists

• You Name IT


1. 2001 -> Product Development• Vidyano

• Caffo

• SoftN

• Cura

2. 2001 -> Service Desk for Products

3. 2001 -> Consultancy Products

4. 2003 -> Service Desk Third Parties• 24/7 Functional & Technical

5. 2006 -> Consultancy ITIL


Product Development

Service Desk

Consultancy

Business Drivers


• Data re-centralization

• Data concurrency

• Database administration

• Data capacity outgrows Access file size

• Functional complexity outgrows VBA

• Number of users increase

• Internationalization and localization

• ...


Issues which you have to solve.

To much to do to little time

New requirements coming in

Business Users want to be served now

Package or Custom?

Choice of technology

Support supplier

Increase Speed of Development

Decrease learning curve

Support the daily systems, answering ad hoc requests from the business user, changing requirements, etc….

Users don’t wait anymore• Users are used to find “solutions” on the internet• Are used to be served now• Wants to see the things before using it

Application “fit for all”, or custom made “fit for us”

• Most Packages only used for 60% of possibilities• Every change in setup mostly done by consultants• Expensive licence and maintenance cost• Forced to upgrade even when you don’t want it

Custom Made “fit for us”• Learning curve new technology for IT department. Can we learn it ?• Is it easy to understand?• Cost of development. Can we quickly develop ?• Supporting the business. Can we show immediately what they want?• Do we have time for documentation – translation – online help?

Choice ofmethodology

Long Analysis

Business Drivers


• Customer satisfaction– Rich User Experience– Eliminates data corruption issues– Increases availability (for slow connections)

• Technical advantages– Scalability– Performance– Reliability– Data Security– Team Development



Client Browser Phone Server Cloud

Rich UX Web UX RIA UX Services

WPF ASP.NET MVC Silverlight WCF

Workflow Data Identity

Workflow Foundation, Biztalk

Entity FrameworkActive Directory,

Identity Foundation

Runtime Common Tools

BCLVisul Studio, Blend,

VSIP Partner Add-On

Challenges


• A wide range of capabilities

– Rich UX capability• WPF, WinForms

– Services capability• Webservices, WCF, AppFabric

– Data capability• ADO.NET, Entity Framework, LINQ, Data Services

• Deep knowledge is required for a solid architecture



Client Browser Phone Server Cloud

Rich UX Web UX RIA UX Services

WPF ASP.NET MVC Silverlight WCF

Workflow Data Identity

Workflow Foundation, Biztalk

Entity FrameworkActive Directory,

Identity Foundation

Runtime Common Tools

BCLVisul Studio, Blend,

VSIP Partner Add-On

• Based on the latest of Microsoft technology

– Microsoft .NET Framework 4.0• Including Reactive Extensions for .NET (Rx)

– Next generation User Interface using WPF(Windows Presentation Foundation)

– Service Oriented architecture based on WCF(Windows Communication Foundation)

– Data interaction with ADO.NET Entity Framework• SQL Server, Oracle, MySQL, PostgreSQL, Informix, DB2, etc...



Choose a data source

Customers

Products

Orders

OrderDetails

RecentCustomers

OutstandingBills

Tables

Customers

RecentCustomers*

Products

Orders

OrderDetails

OutstandingBills*

Map schema to classesMap classes toPersistent Objects

Customers

RecentCustomers*

Products

Orders

OrderDetails

OutstandingBills*

Views

Stored Procedures

* Read-only * Read-only

Getting started


• Application Customization… Changes the complete look and feel of the application

• Persistent Object Customization… Customize the visualization of a Persistent Object… Customize the visualization of a Persistent Object when New

• Query Customization… Customize the complete layout of items… Customize the visualization of an item on the Query

• Data type Customization… Customize the visualization of a data type


… On Load

… On New

… On Save

… On Save Existing

… On Save New

… On Delete

… On Add Reference

… On Remove Reference

… On Check Rules

… On Check Attribute Rules


Override default behavior to the finest level

• Define validation logic

– Per Persistent Object Attribute

– Per Persistent Object (Check multiple attributes)

• Reuse Vidyano built-in rules

– NotEmpty, Required, MaxLength, MaxValue, etc.

• Write your own rules

– Use the full power of the .NET Framework


• Define custom business logic

• Are written in Visual Studio

– Use the full power of the .NET Framework

– Requires recompilation of the service layer

• Are then applied to the correct scope the application

• Can be reused throughout the application


• Multilingual support– Optionally pass by Microsoft Translate

• Help integration– In-application documentation for end-users

• Export To Excel– Export list of data to Microsoft Office Excel

• Many more…


• Secure by default– By default users and groups only have Query rights

• Right types– Query, Read, Edit, Delete, New, etc…– Custom rights can also be defined, e.g. SendEmail

• Right levels– Schema Rights

• Persistent Object Rights– Persistent Object Attribute Rights


Match your current needs, be prepared for the future !

• Deployment through Click Once– Thin client is less than 2MB in size

– Only grows with extra user interface controls• Could be deployed in an alternative way as well

• Service based on Windows Communication Foundation– allows for a wide range of different deployment scenarios …


Full Client Client Server

Client Application Server Cloud Computing

New Features Silverlight / Web Visual Studio

Q2 2011 Q3 2011 Q4 2011 Q1 2012

AD Integration

Reporting

Rest API

Unit Testing API

Silverlight Samples

ASP.NET MVC Samples

Background Tasks

Differencing

Hierarchical Data

Silverlight Client

Repository Manager

Based on user feedback






• Cronos - HRM Application– Management of hiring contracts and legal advantages– Intercompany transactions

• Cronos - Car Management Application– Management of ~2000 cars and drivers– Coupling with 3 leasing companies– Matching ~30 fines per day to the offenders

• SoftN– Healthcare application for nurses– Interface to e-Health platform

• Provincie Vlaams Brabant - Predosa– Document management system– Planning of meetings, contacts, etc...– Interaction with SAP


Effort: 15 days

Estimated Effort: 30 days

Effort: 80 days

Effort: 95 days

• Development license allows unlimited usage

– No restriction as long as Visual Studio is running

• Runtime license (per application)


Standard Professional Enterprise

Maximum number of users 10 100 Unlimited

Maximum deployment scenario Client – Server Application Server Windows Azure

Price € 495 € 1.495 € 2.995

• Flexible– Completely adapt and extend to the needs of your project

• Maintainable– Centralized environment to make changes (in real-time !)

• Secure– Completely customizable to the organizations internal structure

• Scalable– From a local environment to a centralized server or cloud hosting

• Simple– Low learning curve, easy cross developer interaction

• Standardization– Coding by naming conventions



Product

Vidyano

Consultancy

.NET

Knowledge Transfer

Project Plan

Agile Method

Rollout

Development

Service Management

EventManagement

(Monitoring)

Service Support

(Helpdesk, …)

Service Delivery(SLA’s, Quality, …)

Thank you for your interest


from access to .net with vidyano

Documents