// This is an automatically generated code sample.
// To make this code sample work in your Oracle Cloud tenancy,
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
// boolean, number, and enum parameters with values not fitting your use case).
using System;
using System.Threading.Tasks;
using Oci.DatasafeService;
using Oci.Common;
using Oci.Common.Auth;
namespace Oci.Sdk.DotNet.Example.Datasafe
{
public class ListSqlCollectionsExample
{
public static async Task Main()
{
// Create a request and dependent object(s).
var listSqlCollectionsRequest = new Oci.DatasafeService.Requests.ListSqlCollectionsRequest
{
CompartmentId = "ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value",
CompartmentIdInSubtree = false,
AccessLevel = Oci.DatasafeService.Requests.ListSqlCollectionsRequest.AccessLevelEnum.Restricted,
DisplayName = "EXAMPLE-displayName-Value",
Limit = 784,
Page = "EXAMPLE-page-Value",
LifecycleState = Oci.DatasafeService.Models.SqlCollectionLifecycleState.Updating,
SqlCollectionId = "ocid1.test.oc1..<unique_ID>EXAMPLE-sqlCollectionId-Value",
TimeCreatedGreaterThanOrEqualTo = DateTime.Parse("11/26/2041 01:18:27"),
TimeCreatedLessThan = DateTime.Parse("07/02/2034 20:33:27"),
TargetId = "ocid1.test.oc1..<unique_ID>EXAMPLE-targetId-Value",
DbUserName = "EXAMPLE-dbUserName-Value",
SortOrder = Oci.DatasafeService.Requests.ListSqlCollectionsRequest.SortOrderEnum.Asc,
SortBy = Oci.DatasafeService.Requests.ListSqlCollectionsRequest.SortByEnum.Timecreated,
OpcRequestId = "0H1LDZVRTMKAL975PECQ<unique_ID>"
};
// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
var provider = new ConfigFileAuthenticationDetailsProvider("DEFAULT");
try
{
// Create a service client and send the request.
using (var client = new DataSafeClient(provider, new ClientConfiguration()))
{
var response = await client.ListSqlCollections(listSqlCollectionsRequest);
// Retrieve value from the response.
var itemsValue = response.SqlCollectionCollection.Items;
}
}
catch (Exception e)
{
Console.WriteLine($"ListSqlCollections Failed with {e.Message}");
throw e;
}
}
}
}