summaryrefslogtreecommitdiff
path: root/slips/src/app/Marina/DataAccess/Builders/DatabaseDelete.cs
blob: 801aba0c298ff5cd0a424e2a97dc0969da239205 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
using System.Collections.Generic;

namespace Marina.DataAccess.Builders {
	public static class DatabaseDelete {
		public static IQuery Where< T >( DatabaseColumn column, T equalsValue ) {
			return new DeleteQueryBuilder< T >( column, equalsValue ).Build( );
		}

		private class DeleteQueryBuilder< T > : IDeleteQueryBuilder {
			public DeleteQueryBuilder( DatabaseColumn column, T value ) {
				_column = column;
				_value = value;
			}

			public override string ToString() {
				return string.Format( "DELETE FROM [{0}] WHERE [{0}].[{1}] = @{1};", _column.TableName, _column.ColumnName );
			}

			public IEnumerable< DatabaseCommandParameter > Parameters() {
				yield return new DatabaseCommandParameter( _column.ColumnName, _value );
			}

			public IQuery Build() {
				return new Query( this );
			}

			private readonly DatabaseColumn _column;
			private readonly T _value;
		}
	}
}