/// <summary> /// Retrieve one or records collection with a custom command type. /// </summary> /// <param name="map"></param> /// <param name="type"></param> /// <param name="cmdType"></param> /// <param name="returnCollection"></param> /// <returns></returns> protected override PersistenceCommand MakeRetrieveCommand(Map map, Type type, string cmdType, bool returnCollection) { SqlServerPersistenceCommand pcmd = null; SqlCommand cmd = ((SqlConnection)ProviderConnection).CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; pcmd = new SqlServerRetrieveCommand(map, cmdType, cmd, type, ConcurrencySupport, returnCollection); return pcmd; }
/// <summary> /// Factory method to return a retrieve command with concurrency support. /// </summary> /// <param name="connectionString"></param> /// <param name="map"></param> /// <param name="oid"></param> /// <param name="type"></param> /// <returns></returns> protected override PersistenceCommand MakeRetrieveCommand(Map map, ObjectIdentifier oid, Type type) { SqlServerPersistenceCommand pcmd = null; SqlCommand cmd = ((SqlConnection)ProviderConnection).CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; if (ConcurrencySupport == ConcurrencySupportType.None) pcmd = new SqlServerRetrieveCommand(map, oid, cmd, type); else if (ConcurrencySupport == ConcurrencySupportType.Optimistic) pcmd = new SqlServerRetrieveCommand(map, oid, cmd, type, CRUD.RetrieveWithTimestamp); else if (ConcurrencySupport == ConcurrencySupportType.PessimisticUniqueIdentifier || ConcurrencySupport == ConcurrencySupportType.PessimisticUserName) pcmd = new SqlServerRetrieveCommand(map, oid, cmd, type, CRUD.RetrieveAndLock); return pcmd; }
/// <summary> /// Retrieve all command, based on type. /// </summary> /// <param name="map"></param> /// <param name="type"></param> /// <returns></returns> protected override PersistenceCommand MakeRetrieveCommand(Map map, Type type) { SqlServerPersistenceCommand pcmd = null; SqlCommand cmd = ((SqlConnection)ProviderConnection).CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; pcmd = new SqlServerRetrieveCommand(map, type, cmd); return pcmd; }