Have been trying to use Telerik Open Access ORM for the core framework. Finally have the basic structure setup. With having business objects layer, persistant classes and data access layer seperated, the web app itself could just communicate with the business objects, which then calls to persistant classes and data access layer.
Sometimes, somehow Telerik controls might suddenly not appear in Visual Studio's toolbox. A quick solution would be mouse hover to toolbox, add a new tab, and then choose items. Then point to the Telerik bin file (Telerik.Web.UI) and that should populate all controls into the toolbox.
Telerik ORM (Open Access Mapping) has been a very useful tool, for mapping database structures into object oriented classes, so called Persistent Classes. This saves a lot of efforts in writing up these classes manually. What's more we could add on to it is to use generic methods on standard adding and deleting transaction.
Applying security for a web application is a very common task. There are always parts on a web site that requires private only access for members. Recently, I tried to use the form authentication method provided by .NET and found it quite simple to use, though I have always done it with sessions. The
These are some of the commonly used SQL queries at work, just to note them down for easier access. To add a contraint (foreign key): alter table pro_product add constraint FK_53_PRO_Category_FK foreign key (PRO_Category_FK) references PRO_Category(Id) on delete cascade