コード例 #1
0
        public static void DeleteTrips()
        {
            var query = new StringBuilder();

            query.AppendLine("DELETE");
            query.AppendLine($"FROM {TableName}");
            query.AppendLine("WHERE NOT EXISTS");
            query.AppendLine("(SELECT *");
            query.AppendLine($"FROM {EcologDao.TableName}");
            query.AppendLine($"WHERE {EcologDao.ColumnTripId} = {TripsDao.ColumnTripId}");

            DatabaseAccesser.Delete(query.ToString());
        }