private Table Adapters

[Drathmar]

Lately I have be using Strongly typed datasets and adapters and have been liking them. However I have come across a few stumbling blocks that I was wondering if someone could help me with. 1. I'm making a code library that does various things, I guess you would call it something of a 'business layer.' I have strongly typed data adapters, with my own sql fuctions. In my library I use these data adapters and also enforce a few key rules like setting timestamps and logging user names. If someone could create their own instance of the data adapter and bypass my library it would threaten the integrity of the data. Is there some way to secure the dataset so that my libary would be the only thing that could create it? 2. Next thing, in my library each function creates a data adapter, calls its function or functions and then returns its value. Since it is a class I was looking at making a private static version of each of these data adapters. Are there any pitfalls that I should be aware of, (adapters not clearing data, or disconnecting, etc....) or is this a pretty common practice? 3. Lastly, is there some way to enforce rules into the data adapter itself. For instance if i have a function called "Add_Record(recorddata, username, timestamp)" do something to enfoce that username must always be "HttpContext.Current.User.Identity.Name" and that the timestamp is "datetime.now"