public async Task GetMovieByTitleSql(string parameter) { var movies = await _graphClient.ExecuteSQL <Movie>($"select * from c where c.label = 'Movie' and c.title = '{parameter}'"); ConsoleHelpers.ConsoleLine(movies.Result); ConsoleHelpers.ConsoleLine($"Success: {movies.IsSuccessful}. Execution Time: {movies.ExecutionTime.TotalSeconds.ToString("#.##")} s. Execution cost: {movies.RequestCharge} RUs"); }
public async Task ReadMultiWithSql() { var readMovies = await _cosmosClient.ExecuteSQL <MovieFullGraph>($"select * from c where c.label = 'Movie'"); Assert.IsTrue(readMovies.IsSuccessful); var readVertices = await _cosmosClient.ReadVertices <MovieFullGraph>(); Assert.IsTrue(readVertices.IsSuccessful); Assert.AreEqual(readMovies.Result.Count(), readVertices.Result.Count()); var read = await _cosmosClient.ExecuteSQL <string>($"SELECT VALUE c.Title[0]._value FROM c where c.label = 'Movie'"); Assert.IsTrue(read.IsSuccessful); }