kamagra how much to take

Working With The ASP.NET Provider Database

I was staffing the TLC booth with a couple other MVP’s / softies during TechEd this past week, which was pretty interesting. Answering the classic “What is SharePoint” was enjoyable along with the requirement that it be introduced in under 10 seconds or less, but there were a lot of good questions that were asked as well.

Since every security question was pretty much directed at me, I got to dig really deep into peoples gripes with SharePoint security which gave me some good ideas for some future software packages. My policy management solution that I am going to be releasing will cover a whole lot of them, along with its cascading permission functionality.

One question I consistently got was working with the provider database to build custom applications that would leverage its data, some scenarios doing some fairly complex data massaging. I would encourage people that have these types of questions to look at the provider database code that I posted on the main site here (which I was directing people to at the conference) in order to get a better idea of how to structure applications in order to start to work with the provider database. This can of course be done in 50,000 different ways, I was just playing around with it, I mean after all, it is just a SQL database when it really comes down to it :-)

AspnetApplicationObject Class – This is the base partial data object class for the “Application” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetApplicationsCommands Parital Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “applications” table. This partial class could be extended to include your own queries if you desired.

AspnetApplicationsDTO Partial Class – A partial data object class for the “applications” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetMembership Partial Class – This is the base partial data object class for the “membership” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetMembershipCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “membership” table. This partial class could be extended to include your own queries if you desired.

AspnetMembershipDTO Partial Class – A partial data object class for the “membership” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetPaths Partial Class – This is the base partial data object class for the “paths” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetPathsCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “paths” table. This partial class could be extended to include your own queries if you desired.

AspnetPathsDTO Partial Class – A partial data object class for the “Paths” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetPersonalizationallusers Partial Class – This is the base partial data object class for the “personalizationallusers” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetPersonalizationallusersCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “personalizationallusers” table. This partial class could be extended to include your own queries if you desired.

AspnetPersonalizationallusersDTO Partial Class – A partial data object class for the “Personalizationallusers” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetPersonalizationperuser Partial Class – This is the base partial data object class for the “personalizationalluser” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetPersonalizationperuserCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “personalizationperuser” table. This partial class could be extended to include your own queries if you desired.

AspnetPersonalizationperuserDTO Partial Class – A partial data object class for the “Personalizationperuser” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetProfile Partial Class – This is the base partial data object class for the “profile” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetProfileCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “Profile” table. This partial class could be extended to include your own queries if you desired.

AspnetProfileDTO Partial Class – A partial data object class for the “Profile” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetRoles Partial Class – This is the base partial data object class for the “roles” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetRolesCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “Roles” table. This partial class could be extended to include your own queries if you desired.

AspnetRolesDTO Partial Class – A partial data object class for the “Roles” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetSchemaversions Partial Class – This is the base partial data object class for the “schemaversions” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetSchemaversionsCommands Partial Class - This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “Schemaversions” table. This partial class could be extended to include your own queries if you desired.

AspnetSchemaversionsDTO Partial Class – A partial data object class for the “Schemaversions” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetUsers Partial Class – This is the base partial data object class for the “users” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetUsersCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “Users” table. This partial class could be extended to include your own queries if you desired.

AspnetUsersDTO Partial Class – A partial data object class for the “users” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetUsersinroles Partial Class – This is the base partial data object class for the “usersinroles” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetUsersinrolesCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “Usersinroles” table. This partial class could be extended to include your own queries if you desired.

AspnetUsersinrolesDTO Partial Class – A partial data object class for the “Usersinroles” table in the ASP.NET 2.0 provider database. The relevant data transfer objects contain only the serializable data of a data object.

AspnetWebeventEvents Partial Class – This is the base partial data object class for the “webeventevents” table in the provider database. Using this class implies that there will be a singular relationship between the remaining provider tables and relevant data objects.

AspnetWebeventEventsCommands Partial Class – This command factory creates static partial classes that generate parameterized database commands to the ASP.NET database, in this case the “WebeventEvents” table. This partial class could be extended to include your own queries if you desired.

PersistenceManager – The PersistenceManager class is a static helper class that manages the commonly used objects like the connection string, the ADO.NET connection, and the current transaction.

share save 171 16 Working With The ASP.NET Provider Database

2 Comments

  1. Chooklay says:

    What I wanna know, is how do you do a dataview webpart?

  2. Adam Buenz says:

    God I hate you Chooklay.

Trackbacks/Pingbacks

  1. Sharepoint link love 10-7-2007 at Virtual Generations - [...] Working With The ASP.NET Provider Database [...]
  2. Links (6/10/2007) « Steve’s SharePoint Stuff - [...] Working With The ASP.NET Provider Database [...]
  3. links for 2007-06-11 » mhinze.com - [...] SharePoint Shelter » Blog Archive » Working With The ASP.NET Provider Database (tags: asp.net sharepoint) [...]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>