Andrus,
>I'm looking a way to create fast C# Winforms database application.
>
>I need that all data read from database is stored in memory cache.
>Every time when object is required cache should be examined first.
>Database access should be performed only if object does not exist in cache.
>
>I looked into sample business objects and found code like
>
>public CustomerEntity GetCustomerByID(string customerID) {
> return this.GetEntity("CustomersSelectByPK",
> this.CreateParameter("@CustomerID", customerID));
>}
>
>In this case every retrieval of customer causes database access over internet which makes application very slow.
Are you using the MM .NET Web Service data access class?
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com