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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
using System.Collections.Generic;
using System.Text;
namespace Marina.DataAccess.Builders {
public static class DatabaseUpdate {
public static IUpdateQueryBuilder Where< T >( DatabaseColumn whereColumn, T whereValue ) {
return new UpdateQueryBuilder( whereColumn, whereValue.ToString( ) );
}
private class UpdateQueryBuilder : IUpdateQueryBuilder {
public UpdateQueryBuilder( DatabaseColumn whereColumn, string whereValue )
: this( new List< DatabaseCommandParameter >( ), new WhereClause( whereColumn, whereValue ) ) {}
public UpdateQueryBuilder( IList< DatabaseCommandParameter > parameters, WhereClause where ) {
_parameters = parameters;
_where = where;
}
public IEnumerable< DatabaseCommandParameter > Parameters() {
return _parameters;
}
public IQuery Build() {
return new Query( this );
}
public IUpdateQueryBuilder Add( DatabaseColumn column, string value ) {
_parameters.Add( new DatabaseCommandParameter( column.ColumnName, value ) );
return this;
}
public override string ToString() {
StringBuilder builder = new StringBuilder( );
builder.AppendFormat( "UPDATE [{0}] SET {1};", _where.Column( ).TableName, GetParameterNames( ) );
return builder.ToString( );
}
private string GetParameterNames() {
StringBuilder builder = new StringBuilder( );
foreach ( DatabaseCommandParameter parameter in _parameters ) {
builder.AppendFormat( "[{0}].[{1}] = @{1},", _where.Column( ).TableName, parameter.ColumnName );
}
builder.Remove( builder.Length - 1, 1 );
builder.Append( _where );
return builder.ToString( );
}
private readonly IList< DatabaseCommandParameter > _parameters;
private readonly WhereClause _where;
}
}
}
|
