Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version
Go to top

Developing Next Generation Smart Clients using .NET 2.0 working with Existing .NET 1.1 SOA-based XML Web Services

, 16 Aug 2005
Comprehensive guide to development of .NET 2.0 Smart Clients working with existing Service Oriented Architecture based XML web services, fully utilizing the Enterprise Library
smartclientsoa_src.zip
SmartClient
Client
SMI.App
Controls
Forms
Modules
Properties
app.manifest
Settings.settings
Resources
240.png
Bottom.png
BuilderDialog_delete.bmp
DarkBlue.bmp
download-xp.gif
Earth.png
fldropen.png
iSync.gif
Leonardo_da_Vinci_My_Computer.png
LightBlue.bmp
LoginBox.jpg
LoginButton.jpg
LoginButton1.jpg
LoginButton2.jpg
Logo1.png
LogoPic.jpg
Middle.png
Refresh.bmp
refresh.ico
refresh1.ico
RightArrow.bmp
SuccessComplete.bmp
Task.bmp
Tasks.png
Top.png
TurnOffButton.bmp
wi0062-32.ico
wi0063-32.ico
wi0064-16.ico
wi0064-32.ico
SmartInstitute.App.csproj.user
wi0064-32.ico
SMI.Automation
Commands
Course
Framework
Security
Students
UI
Controls
Documents
MiscDocuments
StudentDocuments
Factories
Forms
Helpers
Misc
Properties
Settings.settings
Resources
BuilderDialog_delete.bmp
LogoSmall.bmp
Misho.jpg
My Pic 7.jpg
table.ico
SmartInstitute.Automation.csproj.user
Web References
SmartInstituteServices.AccountService
Account.datasource
AccountService.disco
AccountService.wsdl
Reference.map
SmartInstituteServices.CourseService
Course.datasource
CourseService.disco
CourseService.wsdl
Reference.map
SmartInstituteServices.SecurityService
Reference.map
SecurityService.disco
SecurityService.wsdl
SmartInstituteServices.StudentService
Reference.map
Student.datasource
StudentService.disco
StudentService.wsdl
SMI.ObjectModel.Enhanced
Base
Models
Properties
Settings.settings
Settings
SmartInstitute.ObjectModel.csproj.user
UMS.ObjectModel.Enhanced.csproj.user
SMI.Objects
SmartInstitute.csproj.user
CodeSmith
Tier
BusinessLogicLayer
Entity.cst
EntityBase.cst
EntityCollection.cst
EntityCollectionBase.cst
Enum.cst
IEntity.cst
DataAccessLayer
App.config.cst
CommonSql.cst
Configuration.cst
DBConcurrencyException.cst
DBException.cst
Factories
EntityRepositoryFactory.cst
IEntityRepository.cst
SqlClient
CVS
Entries
Entries.Extra
Entries.Extra.Old
Entries.Old
Repository
Root
TortoiseCVS.Status
SqlEntityRepository.cst
SqlEntityRepositoryBase.cst
TransactionManager.cst
UnitTests
EntityRepositoryTest.cst
WebServiceClient
WsEntityRepository.cst
WsEntityRepositoryBase.cst
Main.cst
nant.cst
References
GotDotNet.ApplicationBlocks.Data.dll
Microsoft.ApplicationBlocks.Data.dll
nunit.framework.dll
StoredProcedures.cst
vsnet2003.project.cst
vsnet2003.solution.cst
vsnet2005.project.cst
vsnet2005.solution.cst
WebService
Web.config.cst
WebService.cst
Database
SmartInstitute.bak
Library
Microsoft.Practices.EnterpriseLibrary.Caching.dll
Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Configuration.dll
Microsoft.Practices.EnterpriseLibrary.Data.dll
Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.dll
Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.Logging.dll
Microsoft.Practices.EnterpriseLibrary.Logging.dll
Microsoft.Practices.EnterpriseLibrary.Security.ActiveDirectory.dll
Microsoft.Practices.EnterpriseLibrary.Security.Cache.CachingStore.dll
Microsoft.Practices.EnterpriseLibrary.Security.Cryptography.dll
Microsoft.Practices.EnterpriseLibrary.Security.Database.Authentication.dll
Microsoft.Practices.EnterpriseLibrary.Security.Database.dll
Microsoft.Practices.EnterpriseLibrary.Security.dll
nunit.core.dll
nunit.framework.dll
Server
BLL
SmartInstitute.csproj.user
DAL
Factories
SmartInstitute.DataAccessLayer.csproj.user
SqlClient
Utilities
GotDotNet.ApplicationBlocks.Data.dll
Microsoft.ApplicationBlocks.Data.dll
nunit.framework.dll
UnitTests
SmartInstitute.build
SmartInstitute.Facade
FacadeTest
SmartInstitute.Facade.csproj.user
SmartInstitute.Test
App.ico
SmartInstitute.Test.csproj.user
SmartInstituteServices
Global.asax
log
SmartInstituteServices.csproj.webinfo
SQL
Setup
SecurityDatabase
SecurityDatabaseConsole
App.ico
SecurityDatabaseConsole.exe.manifest
SR.strings
Tests
Tools.SecurityDatabaseConsole.csproj.user
	 
#region "Using directives"

using System;
using System.Data;
using System.Data.SqlClient;
//using Microsoft.ApplicationBlocks.Data;
using System.Collections;
using System.Diagnostics;
using SmartInstitute;

#endregion

namespace SmartInstitute.DataAccessLayer.SqlClient
{

/// <summary>
///	This class is the base repository for the CRUD operations on the CourseTakenByStudent objects.
/// </summary>
public class CourseTakenByStudentRepositoryBase : ICourseTakenByStudentRepository
{
	#region "Declarations"	
	
	/// <summary>
	/// Connection String.
	/// </summary>
	protected string connectionString = string.Empty;
	
	
	/// <summary>
	/// <see cref="TransactionManager"/> object.
	/// </summary>
	protected TransactionManager transactionManager;
	
	private static volatile CourseTakenByStudentRepositoryBase current;
   	private static object syncRoot = new Object();
	
	#endregion "Declarations"
	
	
	#region "Constructors"
		
	/// <summary>
	/// Creates a new <see cref="CourseTakenByStudentRepositoryBase"/> instance.
	/// Uses connection string to connect to datasource.
	/// </summary>
	/// <param name="connectionString">Connection string.</param>
	protected CourseTakenByStudentRepositoryBase(string connectionString)
	{
		this.connectionString = connectionString;
	}
	
	/// <summary>
	///	Creates a new <see cref="CourseTakenByStudentRepositoryBase"/> instance.
	/// Uses connection string to connect to datasource.
	/// If a transaction is open, it will use the transaction, otherwise it will use the connection string from the transaction manager object.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object.</param>
	protected CourseTakenByStudentRepositoryBase(TransactionManager transactionManager)
	{
		this.transactionManager = transactionManager;
		this.connectionString = this.transactionManager.ConnectionString;
	}
	
	#endregion "Constructors"
	
	#region Public properties
	
	///<summary>
	/// The current CourseTakenByStudentRepositoryBase instance.
	///</summary>
	///<value></value>
	public static CourseTakenByStudentRepositoryBase Current
	{
	  get 
	  {
	     if (current == null) 
	     {
	        lock (syncRoot) 
	        {
	           if (current == null)
	           {
			   		current = new CourseTakenByStudentRepositoryBase(string.Empty);
			   }
	        }
	     }
	     return current;
	  }
	}
	
	///<summary>
	/// Gets or sets the connectionstring to the database.
	///</summary>
	///<value></value>
	public string ConnectionString
	{
		get {return this.connectionString;}
		set {this.connectionString = value;}
	}
	
	
	///<summary>
	/// Gets or sets the TransactionManager instance.
	///</summary>
	///<value></value>
	public TransactionManager TransactionManager
	{
		get {return this.transactionManager;}
		set {this.transactionManager = value;}
	}
	
	#endregion
	
	#region "Get from  Many To Many Relationship Functions"
	#endregion
	
	#region "Delete Functions"
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
    /// <param name="ChangeStamp">Concurrency Parameter. </param>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(System.Int32 ID, DateTime ChangeStamp)
	{
		if(UseTransaction())
		{
			return Delete(this.transactionManager, ID, ChangeStamp);
		}
		else
		{
			return Delete(this.connectionString, ID, ChangeStamp);
		}
	}//end Delete
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="entity">CourseTakenByStudent object containing data.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(CourseTakenByStudent entity)
	{
		if(UseTransaction())
		{
			return Delete(this.transactionManager, entity.ID, entity.ChangeStamp);	
		}
		else
		{
			return Delete(this.connectionString, entity.ID, entity.ChangeStamp);	
		}
	}//end Delete
	/// <summary>
	/// 	Deletes rows from the DataSource.
	/// </summary>
	/// <param name="entityCollection">CourseTakenByStudentCollection containing data.</param>
	/// <remarks>Deletes CourseTakenByStudents only when IsDeleted equals true.</remarks>
	/// <returns>Returns the number of successful delete.</returns>
	public int Delete(CourseTakenByStudentCollection entityCollection)
	{
		if(UseTransaction())
			return Delete(this.transactionManager, entityCollection);
		else
			return Delete(this.connectionString, entityCollection);
	}
	
	
	/// <summary>
	/// 	Deletes a rows from the DataSource.
	/// </summary>
	/// <param name="entityCollection">CourseTakenByStudentCollection containing data.</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes CourseTakenByStudents only when IsDeleted equals true.</remarks>
	/// <returns>Returns the number of successful delete.</returns>
	public int Delete(string connectionString, CourseTakenByStudentCollection entityCollection)
	{
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if ( Delete(connectionString, entity) )
			{
				number++;
			}
		}
		return number;
	}
	
	/// <summary>
	/// 	Deletes a rows from the DataSource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entityCollection">CourseTakenByStudentCollection containing data.</param>
	/// <remarks>Deletes CourseTakenByStudents only when IsDeleted equals true.</remarks>
	/// <returns>Returns the number of successful delete.</returns>
	public int Delete(TransactionManager transactionManager, CourseTakenByStudentCollection entityCollection)
	{
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if ( Delete(transactionManager, entity) )
			{
				number++;
			}
		}
		return number;
	}
	
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="entity">CourseTakenByStudent object containing data.</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(string connectionString, CourseTakenByStudent entity)
	{
		return Delete(null, connectionString,entity.ID, entity.ChangeStamp);	
	}
	
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
	/// <param name="connectionString">Connection string to datasource.</param>
    /// <param name="ChangeStamp">Concurrency Parameter. </param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(string connectionString, System.Int32 ID, DateTime ChangeStamp)
	{
		return Delete(null, connectionString,ID, ChangeStamp);
	}
	
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="entity">CourseTakenByStudent object containing data.</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(TransactionManager transactionManager, CourseTakenByStudent entity)
	{
		if (transactionManager.IsOpen)
			return Delete(transactionManager, null, entity.ID, entity.ChangeStamp);	
		else
			return Delete(null, transactionManager.ConnectionString, entity.ID, entity.ChangeStamp);	
	}
	
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
    /// <param name="ChangeStamp">Concurrency Parameter. </param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	public bool Delete(TransactionManager transactionManager, System.Int32 ID, DateTime ChangeStamp)
	{
		if (transactionManager.IsOpen)
			return Delete(transactionManager, null, ID, ChangeStamp);
		else
			return Delete(null, transactionManager.ConnectionString, ID, ChangeStamp);
	}
	
	
	
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	protected bool Delete(TransactionManager transactionManager, string connectionString, System.Int32 ID, DateTime ChangeStamp)
	{
		int result = 0;
		if (transactionManager != null)
			result = SqlHelper.ExecuteNonQuery(transactionManager.TransactionObject, "prc_CourseTakenByStudent_Delete", ID, ChangeStamp);
		else
			result = SqlHelper.ExecuteNonQuery(connectionString, "prc_CourseTakenByStudent_Delete", ID, ChangeStamp);
			
		Debug.WriteLine("CourseTakenByStudentRepository.Delete Affected " + result + " records.");
		if (result == 0) {
			ThrowDeleteConcurrencyException( ID, ChangeStamp);
		} 
		return Convert.ToBoolean(result);
	}//end Delete
	
	
	/// <summary>
	/// Throws the delete concurrency exception.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
	protected void ThrowDeleteConcurrencyException(System.Int32 ID, DateTime ChangeStamp)
	{
		DBConcurrencyException conflict = new DBConcurrencyException("Concurrency exception: Cannot delete entity as it does not exist.");
		//conflict.ModifiedRecord = entity;
		throw conflict;
	}
	
	
	#endregion

		
	#region "GetList Functions"
	
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <remarks>Uses connection string object was created with.</remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll()
	{	
		if(UseTransaction())
		{
			return GetAll(this.transactionManager);
		}
		else
		{
			return GetAll(this.connectionString);
		}
	}
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <remarks>Uses connection string object was created with.</remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll(int start, int pagelen)
	{	
		if(UseTransaction())
		{
			return GetAll(this.transactionManager, start, pagelen);
		}
		else
		{
			return GetAll(this.connectionString, start, pagelen);
		}
	}
	
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll(string connectionString)
	{
		return GetAll(null, connectionString,0,int.MaxValue);
	}
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll(string connectionString, int start, int pagelen)
	{
		return GetAll(null, connectionString, start, pagelen);
	}//end getall
	
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll(TransactionManager transactionManager)
	{
		if (transactionManager.IsOpen)
			return GetAll(transactionManager, null, 0,int.MaxValue);
		else
			return GetAll(null, transactionManager.ConnectionString, 0,int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetAll(TransactionManager transactionManager, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetAll(transactionManager, null, start, pagelen);
		else
			return GetAll(null, transactionManager.ConnectionString, start, pagelen);
	}//end getall
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetAll(TransactionManager transactionManager, string connectionString, int start, int pagelen)
	{
		//Declare Varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_Get_List");
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_Get_List");
		//Create Collection
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}//end getall
	
	#endregion
	
	#region Paged Recordset
			
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(int start, int pagelen, out int count)
	{
		if(UseTransaction())
		{
			return GetPaged(this.transactionManager, start, pagelen, out count);
		}
		else
		{
			return GetPaged(this.connectionString, start, pagelen, out count);
		}
	}
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(string whereClause, string orderBy, int start, int pagelen, out int count)
	{
		if(UseTransaction())
		{
			return GetPaged(this.transactionManager, whereClause, orderBy, start, pagelen, out count);
		}
		else
		{
			return GetPaged(this.connectionString, whereClause, orderBy, start, pagelen, out count);
		}
	}
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="connectionString">The connection string to the datasource</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(string connectionString, int start, int pagelen, out int count)
	{
		return GetPaged(null, connectionString, null, null, start, pagelen, out count);
	}

	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="connectionString">The connection string to the datasource</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(string connectionString, string whereClause, string orderBy, int start, int pagelen, out int count)
	{
		return GetPaged(null, connectionString, whereClause, orderBy, start, pagelen, out count);
	}
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(TransactionManager transactionManager, int start, int pagelen, out int count)
	{
		if (transactionManager.IsOpen)
			return GetPaged(transactionManager, null, null, null, start, pagelen, out count);
		else
			return GetPaged(null, transactionManager.ConnectionString, null, null, start, pagelen, out count);
	}
	
		/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetPaged(TransactionManager transactionManager, string whereClause, string orderBy, int start, int pagelen, out int count)
	{
		if (transactionManager.IsOpen)
			return GetPaged(transactionManager, null, whereClause, orderBy, start, pagelen, out count);
		else
			return GetPaged(null, transactionManager.ConnectionString, whereClause, orderBy, start, pagelen, out count);
	}
	
	/// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetPaged(TransactionManager transactionManager, string connectionString, string whereClause, string orderBy, int start, int pagelen, out int count)
	{
		
		//Declare Varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetPaged", whereClause, orderBy, start, pagelen);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetPaged", whereClause, orderBy, start, pagelen);
		
		reader.Read();
		count = reader.GetInt32(0);
		reader.NextResult();

		//Create Collection
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, 0, int.MaxValue);
		reader.Close();
		return rows;
	}
	
	#endregion
	
	#region "Get By Foreign Key Functions"
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="CourseID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(System.Int32 CourseID)
	{
		if(UseTransaction())
		{
			return GetByCourseID(this.transactionManager, CourseID, 0, int.MaxValue);;
		}
		else
		{
			return GetByCourseID(this.connectionString, CourseID, 0, int.MaxValue);
		}
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="CourseID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(System.Int32 CourseID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetByCourseID(this.transactionManager, CourseID, start, pagelen);
		}
		else
		{
			return GetByCourseID(this.connectionString, CourseID, start, pagelen);
		}	
	}

	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="CourseID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(string connectionString, System.Int32 CourseID)
	{
		return GetByCourseID(null, connectionString, CourseID, 0,int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="CourseID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(string connectionString, System.Int32 CourseID, int start, int pagelen)
	{
		return GetByCourseID(null, connectionString, CourseID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(TransactionManager transactionManager, System.Int32 CourseID)
	{
		if (transactionManager.IsOpen)
			return GetByCourseID(transactionManager, null, CourseID, 0,int.MaxValue);
		else
			return GetByCourseID(null, transactionManager.ConnectionString, CourseID, 0,int.MaxValue);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByCourseID(TransactionManager transactionManager, System.Int32 CourseID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetByCourseID(transactionManager, null, CourseID, start, pagelen);
		else
			return GetByCourseID(null, transactionManager.ConnectionString, CourseID, start, pagelen);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Course key.
	///		FK_CourseTakenByStudent_Course Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetByCourseID(TransactionManager transactionManager, string connectionString, System.Int32 CourseID, int start, int pagelen)
	{
		//Declare varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetByCourseID", CourseID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetByCourseID", CourseID);
		//Create Collection
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="SectionID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(System.Int32 SectionID)
	{
		if(UseTransaction())
		{
			return GetBySectionID(this.transactionManager, SectionID, 0, int.MaxValue);;
		}
		else
		{
			return GetBySectionID(this.connectionString, SectionID, 0, int.MaxValue);
		}
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(System.Int32 SectionID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetBySectionID(this.transactionManager, SectionID, start, pagelen);
		}
		else
		{
			return GetBySectionID(this.connectionString, SectionID, start, pagelen);
		}	
	}

	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="SectionID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(string connectionString, System.Int32 SectionID)
	{
		return GetBySectionID(null, connectionString, SectionID, 0,int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(string connectionString, System.Int32 SectionID, int start, int pagelen)
	{
		return GetBySectionID(null, connectionString, SectionID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="SectionID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(TransactionManager transactionManager, System.Int32 SectionID)
	{
		if (transactionManager.IsOpen)
			return GetBySectionID(transactionManager, null, SectionID, 0,int.MaxValue);
		else
			return GetBySectionID(null, transactionManager.ConnectionString, SectionID, 0,int.MaxValue);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionID(TransactionManager transactionManager, System.Int32 SectionID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetBySectionID(transactionManager, null, SectionID, start, pagelen);
		else
			return GetBySectionID(null, transactionManager.ConnectionString, SectionID, start, pagelen);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Section key.
	///		FK_CourseTakenByStudent_Section Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetBySectionID(TransactionManager transactionManager, string connectionString, System.Int32 SectionID, int start, int pagelen)
	{
		//Declare varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetBySectionID", SectionID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetBySectionID", SectionID);
		//Create Collection
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="StudentID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(System.Int32 StudentID)
	{
		if(UseTransaction())
		{
			return GetByStudentID(this.transactionManager, StudentID, 0, int.MaxValue);;
		}
		else
		{
			return GetByStudentID(this.connectionString, StudentID, 0, int.MaxValue);
		}
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(System.Int32 StudentID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetByStudentID(this.transactionManager, StudentID, start, pagelen);
		}
		else
		{
			return GetByStudentID(this.connectionString, StudentID, start, pagelen);
		}	
	}

	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="StudentID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(string connectionString, System.Int32 StudentID)
	{
		return GetByStudentID(null, connectionString, StudentID, 0,int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(string connectionString, System.Int32 StudentID, int start, int pagelen)
	{
		return GetByStudentID(null, connectionString, StudentID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(TransactionManager transactionManager, System.Int32 StudentID)
	{
		if (transactionManager.IsOpen)
			return GetByStudentID(transactionManager, null, StudentID, 0,int.MaxValue);
		else
			return GetByStudentID(null, transactionManager.ConnectionString, StudentID, 0,int.MaxValue);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentID(TransactionManager transactionManager, System.Int32 StudentID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetByStudentID(transactionManager, null, StudentID, start, pagelen);
		else
			return GetByStudentID(null, transactionManager.ConnectionString, StudentID, start, pagelen);
	}
	
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_CourseTakenByStudent_Student key.
	///		FK_CourseTakenByStudent_Student Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetByStudentID(TransactionManager transactionManager, string connectionString, System.Int32 StudentID, int start, int pagelen)
	{
		//Declare varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetByStudentID", StudentID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetByStudentID", StudentID);
		//Create Collection
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	
	#endregion
	
	#region "Get By Index Functions"

	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(System.Int32 SectionID, System.Int32 StudentID)
	{
		if(UseTransaction())
		{
			return GetBySectionIDStudentID(this.transactionManager, SectionID, StudentID, 0, int.MaxValue);
		}
		else
		{
			return GetBySectionIDStudentID(this.connectionString, SectionID, StudentID, 0, int.MaxValue);
		}
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(System.Int32 SectionID, System.Int32 StudentID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetBySectionIDStudentID(this.transactionManager, SectionID, StudentID, start, pagelen);
		}
		else
		{
			return GetBySectionIDStudentID(this.connectionString, SectionID, StudentID, start, pagelen);
		}
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(string connectionString, System.Int32 SectionID, System.Int32 StudentID)
	{
		return GetBySectionIDStudentID(null, connectionString, SectionID, StudentID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(string connectionString, System.Int32 SectionID, System.Int32 StudentID, int start, int pagelen)
	{
		return GetBySectionIDStudentID(null, connectionString, SectionID, StudentID, start, pagelen);
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(TransactionManager transactionManager, System.Int32 SectionID, System.Int32 StudentID)
	{
		if (transactionManager.IsOpen)
			return GetBySectionIDStudentID(transactionManager, null, SectionID, StudentID, 0, int.MaxValue);
		else
			return GetBySectionIDStudentID(null, transactionManager.ConnectionString, SectionID, StudentID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetBySectionIDStudentID(TransactionManager transactionManager, System.Int32 SectionID, System.Int32 StudentID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetBySectionIDStudentID(transactionManager, null, SectionID, StudentID, start, pagelen);
		else
			return GetBySectionIDStudentID(null, transactionManager.ConnectionString, SectionID, StudentID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_2 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <param name="StudentID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetBySectionIDStudentID(TransactionManager transactionManager, string connectionString, System.Int32 SectionID, System.Int32 StudentID, int start, int pagelen)
	{
		//Declare Varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetBySectionIDStudentID", SectionID, StudentID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetBySectionIDStudentID", SectionID, StudentID);
		//Create collection and fill
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	


	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="ID"></param>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(System.Int32 ID)
	{
		if(UseTransaction())
		{
			return GetByID(this.transactionManager, ID, 0, int.MaxValue);
		}
		else
		{
			return GetByID(this.connectionString, ID, 0, int.MaxValue);
		}
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="ID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(System.Int32 ID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetByID(this.transactionManager, ID, start, pagelen);
		}
		else
		{
			return GetByID(this.connectionString, ID, start, pagelen);
		}
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="ID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(string connectionString, System.Int32 ID)
	{
		return GetByID(null, connectionString, ID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="ID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(string connectionString, System.Int32 ID, int start, int pagelen)
	{
		return GetByID(null, connectionString, ID, start, pagelen);
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="ID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(TransactionManager transactionManager, System.Int32 ID)
	{
		if (transactionManager.IsOpen)
			return GetByID(transactionManager, null, ID, 0, int.MaxValue);
		else
			return GetByID(null, transactionManager.ConnectionString, ID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="ID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByID(TransactionManager transactionManager, System.Int32 ID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetByID(transactionManager, null, ID, start, pagelen);
		else
			return GetByID(null, transactionManager.ConnectionString, ID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_CourseTakenByStudent index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="ID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetByID(TransactionManager transactionManager, string connectionString, System.Int32 ID, int start, int pagelen)
	{
		//Declare Varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetByID", ID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetByID", ID);
		//Create collection and fill
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	


	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(System.Int32 StudentID, System.Int32 CourseID)
	{
		if(UseTransaction())
		{
			return GetByStudentIDCourseID(this.transactionManager, StudentID, CourseID, 0, int.MaxValue);
		}
		else
		{
			return GetByStudentIDCourseID(this.connectionString, StudentID, CourseID, 0, int.MaxValue);
		}
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(System.Int32 StudentID, System.Int32 CourseID, int start, int pagelen)
	{
		if(UseTransaction())
		{
			return GetByStudentIDCourseID(this.transactionManager, StudentID, CourseID, start, pagelen);
		}
		else
		{
			return GetByStudentIDCourseID(this.connectionString, StudentID, CourseID, start, pagelen);
		}
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(string connectionString, System.Int32 StudentID, System.Int32 CourseID)
	{
		return GetByStudentIDCourseID(null, connectionString, StudentID, CourseID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(string connectionString, System.Int32 StudentID, System.Int32 CourseID, int start, int pagelen)
	{
		return GetByStudentIDCourseID(null, connectionString, StudentID, CourseID, start, pagelen);
	}

	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(TransactionManager transactionManager, System.Int32 StudentID, System.Int32 CourseID)
	{
		if (transactionManager.IsOpen)
			return GetByStudentIDCourseID(transactionManager, null, StudentID, CourseID, 0, int.MaxValue);
		else
			return GetByStudentIDCourseID(null, transactionManager.ConnectionString, StudentID, CourseID, 0, int.MaxValue);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	public CourseTakenByStudentCollection GetByStudentIDCourseID(TransactionManager transactionManager, System.Int32 StudentID, System.Int32 CourseID, int start, int pagelen)
	{
		if (transactionManager.IsOpen)
			return GetByStudentIDCourseID(transactionManager, null, StudentID, CourseID, start, pagelen);
		else
			return GetByStudentIDCourseID(null, transactionManager.ConnectionString, StudentID, CourseID, start, pagelen);
	}
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the IX_CourseTakenByStudent_1 index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="StudentID"></param>
	/// <param name="CourseID"></param>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of CourseTakenByStudent objects.</returns>
	protected CourseTakenByStudentCollection GetByStudentIDCourseID(TransactionManager transactionManager, string connectionString, System.Int32 StudentID, System.Int32 CourseID, int start, int pagelen)
	{
		//Declare Varibles
		SqlDataReader reader;
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_GetByStudentIDCourseID", StudentID, CourseID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_GetByStudentIDCourseID", StudentID, CourseID);
		//Create collection and fill
		CourseTakenByStudentCollection rows = new CourseTakenByStudentCollection();
		Fill(reader, rows, start, pagelen);
		reader.Close();
		return rows;
	}
	

	#endregion "Get By Index Functions"

	#region "Insert Functions"

	/// <summary>
	/// 	Inserts a CourseTakenByStudent object into the datasource.
	/// </summary>
	/// <param name="entity">CourseTakenByStudent object to insert.</param>
	/// <remarks>After inserting into the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Insert(CourseTakenByStudent entity)
	{
		if(UseTransaction())
		{
			return Insert(this.transactionManager, entity);
		}
		else
		{
			return Insert(this.connectionString, entity);
		}
	}
	
	/// <summary>
	/// 	Insert rows in the datasource.
	/// </summary>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to insert.</param>
	/// <remarks>
	///		This function will only insert entity objects marked as dirty
	///		and have an identity field equal to zero.
	///		Upon inserting the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After inserting into the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful insert.</returns>
	public int Insert(CourseTakenByStudentCollection entityCollection)
	{
			if(UseTransaction())
		{
			return Insert(this.transactionManager, entityCollection);
		}
		else
		{
			return Insert(this.connectionString, entityCollection);
		}		
	}

		
	/// <summary>
	/// 	Insert rows in the datasource.
	/// </summary>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to insert.</param>
	/// <remarks>
	///		This function will only insert entity objects marked as dirty
	///		and have an identity field equal to zero.
	///		Upon inserting the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After inserting into the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful insert.</returns>
	public int Insert(string connectionString, CourseTakenByStudentCollection entityCollection)
	{
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if (entity.IsNew)
			{
				if (Insert(connectionString, entity) )
				{
					number++;
				}
			}
		}
		return number;
	}
	
	/// <summary>
	/// 	Insert rows in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to insert.</param>
	/// <remarks>
	///		This function will only insert entity objects marked as dirty
	///		and have an identity field equal to zero.
	///		Upon inserting the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After inserting into the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful insert.</returns>
	public int Insert(TransactionManager transactionManager, CourseTakenByStudentCollection entityCollection)
	{
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if (entity.IsNew)
			{
				if (Insert(transactionManager, entity) )
				{
					number++;
				}
			}
		}
		return number;
	}
	
	/// <summary>
	/// 	Inserts a CourseTakenByStudent object into the datasource.
	/// </summary>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entity">CourseTakenByStudent object to insert.</param>
	/// <remarks>After inserting into the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Insert(string connectionString, CourseTakenByStudent entity)
	{
		return Insert(null, connectionString, entity);
	}
	
	
	/// <summary>
	/// 	Inserts a CourseTakenByStudent object into the datasource using a transaction.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entity">CourseTakenByStudent object to insert.</param>
	/// <remarks>After inserting into the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Insert(TransactionManager transactionManager,  CourseTakenByStudent entity)
	{
		if (transactionManager.IsOpen)
			return Insert(transactionManager, null, entity);
		else
			return Insert(null, transactionManager.ConnectionString, entity);
	}
	
	
	/// <summary>
	/// 	Inserts a CourseTakenByStudent object into the datasource using a transaction.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entity">CourseTakenByStudent object to insert.</param>
	/// <remarks>After inserting into the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	protected bool Insert(TransactionManager transactionManager, string connectionString, CourseTakenByStudent entity)
	{
		//Declare variables			
		//IDataParameterCollection parameters;
		SqlDataReader reader;
		int result = 0;
		//Get Parameters
		//if (transactionManager != null)
		//	parameters = SqlHelperParameterCache.GetSpParameterSet(transactionManager.ConnectionString, "prc_CourseTakenByStudent_Insert");
		//else
		//	parameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, "prc_CourseTakenByStudent_Insert");
		//Assign values to parameters
		//AssignInsertParameters(parameters, entity);
		
		
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_Insert", 
			entity.ChangeStamp,entity.CourseID,entity.NonCredit,entity.SectionID,entity.Status,entity.StudentID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_Insert", 
			entity.ChangeStamp,entity.CourseID,entity.NonCredit,entity.SectionID,entity.Status,entity.StudentID );
			
		Debug.WriteLine("CourseTakenByStudentRepository-Insert Affected " + reader.RecordsAffected + " records.");
		if (reader.RecordsAffected > 0)
		{
			//RefreshEntity closes the connection
			RefreshEntity(reader, entity);
			result = 1;
		}
		else
		{
			//must always close the connection
			reader.Close();
		}
		return Convert.ToBoolean(result);
	}
	
	
	
	
	/// <summary>
	/// Assigns the insert parameters from the CourseTakenByStudent instance to the SqlParameter array.
	/// </summary>
	/// <param name="parameters">The <see cref="SqlParameter"/> array to fill.</param>
	/// <param name="entity">The <see cref="CourseTakenByStudent"/> instance to read from.</param>
	/* protected void AssignInsertParameters(IDataParameterCollection paramCollection, CourseTakenByStudent entity)
	{
		SqlParameter[] parameters = new SqlParameter[ paramCollection.Count ];
		paramCollection.CopyTo( parameters, 0 );
		
					parameters[0].Value = entity.ChangeStamp;
					parameters[1].Value = entity.CourseID;
					parameters[2].Value = entity.NonCredit;
					parameters[3].Value = entity.SectionID;
					parameters[4].Value = entity.Status;
					parameters[5].Value = entity.StudentID;
	} */
	
	#endregion

	#region "Update Functions"
	
	
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity">The <see cref="CourseTakenByStudent"/> instance to update.</param>
	/// <remarks>After updating the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Update(CourseTakenByStudent entity)
	{
		if(UseTransaction())
		{
			return Update(this.transactionManager, entity);
		}
		else
		{
			return Update(this.connectionString, entity);
		}		
	}		
	
	/// <summary>
	/// 	Update existing rows in the datasource.
	/// </summary>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	///		This function will only update entity objects marked as dirty
	///		and do not have an primary key value of 0.
	///		Upon updating the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful update .</returns>
	public int Update(CourseTakenByStudentCollection entityCollection)
	{
		if(UseTransaction())
		{
			return Update(this.transactionManager, entityCollection);
		}
		else
		{
			return Update(this.connectionString, entityCollection);
		}	
	}

	
	/// <summary>
	/// 	Update existing rows in the datasource.
	/// </summary>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	///		This function will only update entity objects marked as dirty
	///		and do not have an primary key value of 0.
	///		Upon updating the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful update .</returns>
	public int Update(string connectionString, CourseTakenByStudentCollection entityCollection)
	{	
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if ((entity.IsDirty) && !(entity.IsNew))
			{
				if ( Update(connectionString, entity) )
				{
					number++;
				}
			}
		}
		return number;
	}
	
	
	/// <summary>
	/// 	Update existing rows in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	///		This function will only update entity objects marked as dirty
	///		and do not have an primary key value of 0.
	///		Upon updating the objects, each dirty object will have the public
	///		method <c>Object.AcceptChanges()</c> called to make it clean.
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns the number of successful update .</returns>
	public int Update(TransactionManager transactionManager, CourseTakenByStudentCollection entityCollection)
	{
		int number = 0;
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			if ((entity.IsDirty) && !(entity.IsNew))
			{
				if ( Update(transactionManager, entity) )
				{
					number++;
				}
			}
		}
		return number;
	}

	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entity">CourseTakenByStudent object to update.</param>
	/// <remarks>After updating the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Update(string connectionString, CourseTakenByStudent entity)
	{	
		return Update(null, connectionString, entity);
	}
	
	
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entity">CourseTakenByStudent object to update.</param>
	/// <remarks>After updating the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public bool Update(TransactionManager transactionManager, CourseTakenByStudent entity)
	{
		if (transactionManager.IsOpen)
			return Update(transactionManager, null, entity);
		else
			return Update(null, transactionManager.ConnectionString, entity);
	}
	
	
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="connectionString">Connection string to datasource.</param>
	/// <param name="entity">CourseTakenByStudent object to update.</param>
	/// <remarks>After updating the datasource, the CourseTakenByStudent object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	protected bool Update(TransactionManager transactionManager, string connectionString, CourseTakenByStudent entity)
	{
		//Declare variables
		//IDataParameterCollection parameters;
		SqlDataReader reader;
		int result = 0;
		//Get Parameters
		//if (transactionManager != null)
		//	parameters = SqlHelperParameterCache.GetSpParameterSet(transactionManager.ConnectionString, "prc_CourseTakenByStudent_Update");
		//else
		//	parameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, "prc_CourseTakenByStudent_Update");
		//Assign parameters values to corresponding entity values
		//AssignUpdateParameters(parameters, entity);
		
		
		//Get Reader
		if (transactionManager != null)
			reader = SqlHelper.ExecuteReader(transactionManager.TransactionObject, "prc_CourseTakenByStudent_Update",
				entity.ID,entity.ChangeStamp,entity.CourseID,entity.NonCredit,entity.SectionID,entity.Status,entity.StudentID);
		else
			reader = SqlHelper.ExecuteReader(connectionString, "prc_CourseTakenByStudent_Update", 
				entity.ID,entity.ChangeStamp,entity.CourseID,entity.NonCredit,entity.SectionID,entity.Status,entity.StudentID);
			
		Debug.WriteLine("CourseTakenByStudentRepository-Update Affected " + reader.RecordsAffected + " records.");
		if (reader.RecordsAffected > 0)
		{
			RefreshEntity(reader, entity);
			result = reader.RecordsAffected;
		}
		else
		{
			//must always close the connection
			reader.Close();
			DBConcurrencyException conflict = new DBConcurrencyException("Concurrency exception");
			conflict.ModifiedRecord = entity;
			CourseTakenByStudentCollection dsrecord;
			//Get record from Datasource
			if (transactionManager != null)
				dsrecord = CourseTakenByStudentRepository.Current.GetByID(this.transactionManager, entity.ID);
			else
				dsrecord = CourseTakenByStudentRepository.Current.GetByID(connectionString, entity.ID);
			if(dsrecord.Count > 0)
				conflict.DatasourceRecord = dsrecord[0];
			throw conflict;
		}
		return Convert.ToBoolean(result);
	}

	
	
	/// <summary>
	/// Assigns the update parameters from an to a <see cref="CourseTakenByStudent"/> instance to an <see cref="SqlParameter"/> array.
	/// </summary>
	/// <param name="parameters">The <see cref="SqlParameter"/> array.</param>
	/// <param name="entity">The <see cref="CourseTakenByStudent"/> instance.</param>
	//protected void AssignUpdateParameters(IDataParameterCollection paramCollection, CourseTakenByStudent entity)
	//{
	//}
	
	#endregion
	
	
	#region "Save Functions"
	
	/// <summary>
	/// 	Updates, Inserts rows in the datasource.
	/// </summary>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated or inserted
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public void Save(CourseTakenByStudentCollection entityCollection)
	{
		if(UseTransaction())
		{
			Save(this.transactionManager, entityCollection);
		}
		else
		{
			Save(this.connectionString, entityCollection);
		}
	}
	

		
	
	/// <summary>
	/// 	Updates, Inserts rows in the datasource.
	/// </summary>
	/// <param name="connectionString">Connection String to Datasource.</param>
	/// <param name="entity">CourseTakenByStudent object to update.</param>
	/// <remarks>
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated or inserted
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public void Save(string connectionString, CourseTakenByStudent entity)
	{		
		if (entity.IsDeleted)
			Delete(connectionString, entity);
		else if ((entity.IsDirty) && !(entity.IsNew))
			Update(connectionString, entity);
		else if (entity.IsNew)
			Insert(connectionString, entity);
	}



	/// <summary>
	/// 	Updates, Inserts rows in the datasource.
	/// </summary>
	/// <param name="connectionString">Connection String to Datasource.</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated or inserted
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public void Save(string connectionString, CourseTakenByStudentCollection entityCollection)
	{
		foreach (CourseTakenByStudent entity in entityCollection)
		{			
			Save(connectionString, entity);
		}
	}
	
	
	
	
	/// <summary>
	/// 	Updates, Inserts rows in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entity"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated or inserted
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public void Save(TransactionManager transactionManager, CourseTakenByStudent entity)
	{		
		if (entity.IsDeleted)
		{
			Delete(transactionManager, entity);
		}
		if ((entity.IsDirty) && !(entity.IsNew))
		{
			Update(transactionManager, entity);
		}
		else if (entity.IsNew)
		{
			Insert(transactionManager, entity);
		}
	}
	
	
	/// <summary>
	/// 	Updates, Inserts rows in the datasource.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
	/// <param name="entityCollection"><c>CourseTakenByStudent</c> objects in a <c>CourseTakenByStudentCollection</c> object to update.</param>
	/// <remarks>
	/// 	After updating the datasource, the <c>CourseTakenByStudent</c> objects will be updated or inserted
	/// 	to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	public void Save(TransactionManager transactionManager, CourseTakenByStudentCollection entityCollection)
	{
		foreach (CourseTakenByStudent entity in entityCollection)
		{
			Save(transactionManager, entity);
		}
	}
	#endregion
	

	#region "Helper Functions"

	///<summary>
	/// Fill an CourseTakenByStudentCollection From a DataSet
	///</summary>
	/// <param name="dataSet">the DataSet</param>
	/// <param name="rows">The collection to fill</param>
	/// <param name="start">Start row</param>
	/// <param name="pagelen">number of row.</param>
	///<returns>A <see chref="CourseTakenByStudentCollection"/> object.</returns>
	protected CourseTakenByStudentCollection Fill(DataSet dataSet, CourseTakenByStudentCollection rows, int start, int pagelen)
	{
		int recordnum = 0;
		
		System.Collections.IEnumerator dataRows =  dataSet.Tables[0].Rows.GetEnumerator();
		
		while (dataRows.MoveNext() && (pagelen != 0))
		{
			if(recordnum >= start)
			{
				DataRow row = (DataRow)dataRows.Current;
			
				CourseTakenByStudent c = new CourseTakenByStudent();
				c.ID = (Convert.IsDBNull(row["ID"]))?(int)0:(System.Int32)row["ID"];
				c.StudentID = (Convert.IsDBNull(row["StudentID"]))?(int)0:(System.Int32)row["StudentID"];
				c.CourseID = (Convert.IsDBNull(row["CourseID"]))?(int)0:(System.Int32)row["CourseID"];
				c.SectionID = (Convert.IsDBNull(row["SectionID"]))?(int)0:(System.Int32)row["SectionID"];
				c.Status = (Convert.IsDBNull(row["Status"]))?(int)0:(System.Int32)row["Status"];
				c.NonCredit = (Convert.IsDBNull(row["NonCredit"]))?false:(System.Boolean)row["NonCredit"];
				c.ChangeStamp = (Convert.IsDBNull(row["ChangeStamp"]))?DateTime.MinValue:(System.DateTime)row["ChangeStamp"];
				rows.Add(c);
				pagelen -= 1;
			}
			recordnum += 1;
		}
		return rows;
	}

	
	///<summary>
	/// Fill an CourseTakenByStudentCollection From a DataReader.
	///</summary>
	/// <param name="reader">Datareader</param>
	/// <param name="rows">The collection to fill</param>
	/// <param name="start">Start row</param>
	/// <param name="pagelen">number of row.</param>
	///<returns>a <see cref="CourseTakenByStudentCollection"/></returns>
	protected CourseTakenByStudentCollection Fill(SqlDataReader reader, CourseTakenByStudentCollection rows, int start, int pagelen)
	{
		int recordnum = 0;
		while (reader.Read() && (pagelen != 0))
		{
			if(recordnum >= start)
			{
				CourseTakenByStudent c = new CourseTakenByStudent();
				c.ID = (Convert.IsDBNull(reader["ID"]))?(int)0:(System.Int32)reader["ID"];
				c.StudentID = (Convert.IsDBNull(reader["StudentID"]))?(int)0:(System.Int32)reader["StudentID"];
				c.CourseID = (Convert.IsDBNull(reader["CourseID"]))?(int)0:(System.Int32)reader["CourseID"];
				c.SectionID = (Convert.IsDBNull(reader["SectionID"]))?(int)0:(System.Int32)reader["SectionID"];
				c.Status = (Convert.IsDBNull(reader["Status"]))?(int)0:(System.Int32)reader["Status"];
				c.NonCredit = (Convert.IsDBNull(reader["NonCredit"]))?false:(System.Boolean)reader["NonCredit"];
				c.ChangeStamp = (Convert.IsDBNull(reader["ChangeStamp"]))?DateTime.MinValue:(System.DateTime)reader["ChangeStamp"];
				c.AcceptChanges();
				rows.Add(c);
				pagelen -= 1;
			}
			recordnum += 1;
		}
		return rows;
	}
	
	
	/// <summary>
	/// Refreshes the <see cref="CourseTakenByStudent"/> object from the <see cref="SqlDataReader"/>.
	/// </summary>
	/// <param name="reader">The <see cref="SqlDataReader"/> to read from.</param>
	/// <param name="entity">The <see cref="CourseTakenByStudent"/> object.</param>
	protected void RefreshEntity(SqlDataReader reader, CourseTakenByStudent entity)
	{
		reader.Read();
		entity.ID = (Convert.IsDBNull(reader["ID"]))?(int)0:(System.Int32)reader["ID"];
		entity.StudentID = (Convert.IsDBNull(reader["StudentID"]))?(int)0:(System.Int32)reader["StudentID"];
		entity.CourseID = (Convert.IsDBNull(reader["CourseID"]))?(int)0:(System.Int32)reader["CourseID"];
		entity.SectionID = (Convert.IsDBNull(reader["SectionID"]))?(int)0:(System.Int32)reader["SectionID"];
		entity.Status = (Convert.IsDBNull(reader["Status"]))?(int)0:(System.Int32)reader["Status"];
		entity.NonCredit = (Convert.IsDBNull(reader["NonCredit"]))?false:(System.Boolean)reader["NonCredit"];
		entity.ChangeStamp = (Convert.IsDBNull(reader["ChangeStamp"]))?DateTime.MinValue:(System.DateTime)reader["ChangeStamp"];
		reader.Close();

		entity.AcceptChanges();
	}
	
	
	/// <summary>
	/// Indicates if a transaction is currently used.
	/// </summary>
	/// <returns></returns>
	protected bool UseTransaction()
	{
		return UseTransaction(this.transactionManager);
	}
	
	
	
	/// <summary>
	/// Indicates if a transaction is currently used.
	/// </summary>
	/// <param name="transactionManager"><see cref="TransactionManager"/> object.</param>
	/// <returns></returns>
	protected bool UseTransaction(TransactionManager transactionManager)
	{
		if (transactionManager != null)
		{
			if (transactionManager.IsOpen)
				return true;
		}
		return false;
	}
	#endregion "Helper Functions"
	
	}//end class
} // end namespace

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author


| Advertise | Privacy | Mobile
Web04 | 2.8.140916.1 | Last Updated 17 Aug 2005
Article Copyright 2005 by Omar Al Zabir
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid