FilesExpand file tree

 master

/

DeleteHelper.cs

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

42 lines (36 loc) · 1.31 KB

 master

/

DeleteHelper.cs

Top

File metadata and controls

• Code
• Blame

42 lines (36 loc) · 1.31 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Simple.Data.Ado.Schema;

namespace Simple.Data.Ado

{

internal class DeleteHelper

{

private readonly DatabaseSchema _schema;

private readonly ICommandBuilder _commandBuilder;

private readonly IExpressionFormatter _expressionFormatter;

public DeleteHelper(DatabaseSchema schema)

{

_schema = schema;

_commandBuilder = new CommandBuilder(schema);

_expressionFormatter = new ExpressionFormatter(_commandBuilder, _schema);

}

public ICommandBuilder GetDeleteCommand(string tableName, SimpleExpression criteria)

{

_commandBuilder.Append(GetDeleteClause(tableName));

if (criteria != null)

{

var whereCondition = _expressionFormatter.Format(criteria);

if (!string.IsNullOrEmpty(whereCondition))

_commandBuilder.Append(" where " + whereCondition);

}

return _commandBuilder;

}

private string GetDeleteClause(string tableName)

{

var table = _schema.FindTable(tableName);

return string.Concat("delete from ", table.QualifiedName);

}

}

}