public new int ExecuteNonQuery(string sqlCommand, params DbParameter[] parameters) { MockSql info = new MockSql(sqlCommand); if (sqlCommand.StartsWith("CREATE TABLE " + TableName)) { RequestTablePresent = true; } if (sqlCommand.StartsWith("INSERT ")) { MockSql.AddRow(table, parameters); } if (sqlCommand.StartsWith("UPDATE ")) { table.Rows[0]["Status"] = 1; } if (sqlCommand.StartsWith("DELETE FROM ")) { DataRow row = table.Rows.Find(parameters[0].Value); if (row != null) { table.Rows.Remove(row); } } return(0); }
public new DbDataReader ExecuteReader(string sqlCommand, params DbParameter[] parameters) { MockSql info = new MockSql(sqlCommand); if (info.Where != null && info.Where.Length > 0) { foreach (DbParameter parameter in parameters) { if (parameter.DbType == DbType.String) { info.Where = info.Where.Replace("= " + parameter.ParameterName, "= '" + parameter.Value.ToString() + "'"); } else if (parameter.DbType == DbType.Guid) { info.Where = info.Where.Replace("= " + parameter.ParameterName, "= '" + parameter.Value.ToString() + "'"); } else { info.Where = info.Where.Replace(">= " + parameter.ParameterName, ">= " + parameter.Value.ToString()); } } DataView view = new DataView(table, info.Where, info.OrderBy, DataViewRowState.CurrentRows); return(view.ToTable().CreateDataReader()); } else { return(table.CreateDataReader()); } }
public new object ExecuteScalar(string sqlCommand, params DbParameter[] parameters) { MockSql info = new MockSql(sqlCommand); if (sqlCommand.StartsWith("SELECT Count")) { if (info.Where != null && info.Where.Length > 0) { DataView view = new DataView(table, info.Where, info.OrderBy, DataViewRowState.CurrentRows); return(view.Count); } else { return(table.Rows.Count); } } return(0); }