How to Connect .NET MAUI App to Salesforce via ADO.NET

private readonly string _connectionString;

public SalesforceService() {
  _connectionString = "Authentication Type=UserNamePassword;" +
    "Host=https://develop.my.salesforce.com;" +
    "[email protected];" +
    "Password=******;" +
    "Security Token=***********;" +
    "License Key=***********;";
}

public async Task<bool> TestConnectionAsync() {
  try {
    using(var connection = new SalesforceConnection(_connectionString)) {
      connection.Open();
      return true;
    }
  } catch {
    return false;
  }
}

public async Task<List<LeadModel>> GetLeadDataAsync() {
  var leadData = new List<LeadModel>();

  try {
    using(var connection = new SalesforceConnection(_connectionString)) {
      connection.Open();

      string query = "SELECT Id, FirstName, LastName, Company, Title, Phone, Email, Status FROM Lead LIMIT 15";
      using(var command = new SalesforceCommand(query, connection)) {
        using(var reader = command.ExecuteReader()) {
          while (reader.Read()) {
            leadData.Add(new LeadModel {
                Id = reader["Id"].ToString(),
                FullName = $"{reader["FirstName"]} {reader["LastName"]}",
                DetailInfo = $"Company: {reader["Company"]}, Title: {reader["Title"]}, Phone: {reader["Phone"]}, Email: {reader["Email"]}, Status: {reader["Status"]}"
            });
          }
        }
      }
    }
  } catch (Exception ex) {
    Console.WriteLine($"Error retrieving data: {ex.Message}");
  }

  return leadData;
}

<Label Text="Leads Table" FontAttributes="Bold" Margin="0,10,0,5" />
<CollectionView x:Name="DataCollectionView" ItemsSource="{Binding LeadData}" VerticalOptions="FillAndExpand">
<CollectionView.ItemTemplate>
    <DataTemplate>
     <Grid Padding="5" ColumnDefinitions="*,*,Auto">
         <!-- Full Name -->
         <Label Grid.Column="0" Text="{Binding FullName}" FontSize="16" />

         <!-- Detail Info -->
         <Label Grid.Column="1" Text="{Binding DetailInfo}" FontSize="12" TextColor="Gray" />

         <!-- Delete Button -->
         <Button Grid.Column="2" Text="Delete" TextColor="White" BackgroundColor="Red"
            Command="{Binding Path=BindingContext.DeleteCommand, Source={x:Reference DataCollectionView}}"
            CommandParameter="{Binding Id}" />
        </Grid>
    </DataTemplate>
</CollectionView.ItemTemplate>
</CollectionView>

public async Task<bool>
AddLeadAsync(string firstName, string lastName, string company, string title, string phone, string email, string status) {
  try {
    using(var connection = new SalesforceConnection(_connectionString)) {
      connection.Open();

      string query = "INSERT INTO Lead (FirstName, LastName, Company, Title, Phone, Email, Status) VALUES (@FirstName, @LastName, @Company, @Title, @Phone, @Email, @Status)";
      using(var command = new SalesforceCommand(query, connection)) {
        command.Parameters.AddWithValue("FirstName", firstName ?? string.Empty);
        command.Parameters.AddWithValue("LastName", lastName ?? string.Empty);
        command.Parameters.AddWithValue("Company", company ?? string.Empty);
        command.Parameters.AddWithValue("Title", title ?? string.Empty);
        command.Parameters.AddWithValue("Phone", phone ?? string.Empty);
        command.Parameters.AddWithValue("Email", email ?? string.Empty);
        command.Parameters.AddWithValue("Status", status ?? string.Empty);

        command.ExecuteNonQuery();
      }
    }
    return true;
  } catch (Exception ex) {
    Console.WriteLine($"Error adding lead: {ex.Message}");
    return false;
  }
}

<VerticalStackLayout Padding="10" Spacing="10">
	<Label Text="Add New Lead" FontAttributes="Bold" FontSize="20" HorizontalOptions="Center" />

	<Grid ColumnDefinitions="*,3*" RowDefinitions="Auto,Auto,Auto,Auto,Auto,Auto,Auto" RowSpacing="15" Padding="0,10,0,10">
    	<!-- First Name -->
    	<Label Text="First Name:" VerticalTextAlignment="Center" />
    	<Entry x:Name="FirstNameEntry" Placeholder="First Name" Grid.Column="1" />

    	<!-- Last Name -->
    	<Label Text="Last Name:" VerticalTextAlignment="Center" Grid.Row="1" />
    	<Entry x:Name="LastNameEntry" Placeholder="Last Name" Grid.Row="1" Grid.Column="1" />

    	<!-- Company -->
    	<Label Text="Company:" VerticalTextAlignment="Center" Grid.Row="2" />
    	<Entry x:Name="CompanyEntry" Placeholder="Company" Grid.Row="2" Grid.Column="1" />

    	<!-- Title -->
    	<Label Text="Title:" VerticalTextAlignment="Center" Grid.Row="3" />
    	<Entry x:Name="TitleEntry" Placeholder="Title" Grid.Row="3" Grid.Column="1" />

    	<!-- Phone -->
    	<Label Text="Phone:" VerticalTextAlignment="Center" Grid.Row="4" />
    	<Entry x:Name="PhoneEntry" Placeholder="Phone" Grid.Row="4" Grid.Column="1" />

    	<!-- Email -->
    	<Label Text="Email:" VerticalTextAlignment="Center" Grid.Row="5" />
    	<Entry x:Name="EmailEntry" Placeholder="Email" Grid.Row="5" Grid.Column="1" />

    	<!-- Status -->
    	<Label Text="Status:" VerticalTextAlignment="Center" Grid.Row="6" />
    	<Entry x:Name="StatusEntry" Placeholder="Status" Grid.Row="6" Grid.Column="1" />
	</Grid>
</VerticalStackLayout>

<Button Text="Add Lead" Clicked="OnAddLeadClicked" />

public async Task<bool> DeleteLeadAsync(string id) {
  try {
    using(var connection = new SalesforceConnection(_connectionString)) {
      connection.Open();

      string query = "DELETE FROM Lead WHERE Id = @Id";
      using(var command = new SalesforceCommand(query, connection)) {
        command.Parameters.AddWithValue("Id", id);

        command.ExecuteNonQuery();
      }
    }
    return true;
  } catch (Exception ex) {
    Console.WriteLine($"Error deleting lead: {ex.Message}");
    return false;
  }
}
}

<Button Grid.Column="2" Text="Delete" TextColor="White" BackgroundColor="Red" Command="{Binding Path=BindingContext.DeleteCommand, Source={x:Reference DataCollectionView}}" CommandParameter="{Binding Id}" />