Data access adapter class, which controls the complete database interaction with the database for all objects.
Use a DataAccessAdapter object solely per thread, and per connection. A DataAccessAdapter object contains 1 active connection and no thread-access scheduling code. This means that you need to create a new DataAccessAdapter object if you want to utilize in another thread a new connection and a new transaction or want to open a new connection.
Inheritance: DataAccessAdapterBase
DataAccessAdapter Class Documentation
Exemple #1
0
 /// <summary>Creates an IRetrievalQuery object for a call to the procedure 'FriendSuggestion'.</summary>
 /// <param name="userId">Input parameter of stored procedure</param>
 /// <param name="numberOfLevels">Input parameter of stored procedure</param>
 /// <param name="pageNumber">Input parameter of stored procedure</param>
 /// <param name="pageSize">Input parameter of stored procedure</param>
 /// <param name="isRandom">Input parameter of stored procedure</param>
 /// <param name="userName">Input parameter of stored procedure</param>
 /// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
 public static IRetrievalQuery GetFriendSuggestionCallAsQuery(System.Guid userId, System.Int32 numberOfLevels, System.Int32 pageNumber, System.Int32 pageSize, System.Boolean isRandom, System.String userName)
 {
     using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
     {
         return CreateFriendSuggestionCall(dataAccessProvider, userId, numberOfLevels, pageNumber, pageSize, isRandom, userName).ToRetrievalQuery();
     }
 }
Exemple #2
0
 /// <summary>Calls stored procedure 'FriendSuggestion'.<br/><br/></summary>
 /// <param name="userId">Input parameter. </param>
 /// <param name="numberOfLevels">Input parameter. </param>
 /// <param name="pageNumber">Input parameter. </param>
 /// <param name="pageSize">Input parameter. </param>
 /// <param name="isRandom">Input parameter. </param>
 /// <param name="userName">Input parameter. </param>
 /// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
 public static DataTable FriendSuggestion(System.Guid userId, System.Int32 numberOfLevels, System.Int32 pageNumber, System.Int32 pageSize, System.Boolean isRandom, System.String userName)
 {
     using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
     {
         return FriendSuggestion(userId, numberOfLevels, pageNumber, pageSize, isRandom, userName, dataAccessProvider);
     }
 }