Summarize this content to 400 words in Persian Lang AWS Aurora (\u0647\u0645 MySQL \u0648 \u0647\u0645 Postgres) \u0648 MariaDB \u0627\u062c\u0627\u0632\u0647 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a IAM \u0631\u0627 \u0645\u06cc \u062f\u0647\u0646\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a\u060c \u0647\u0646\u06af\u0627\u0645 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0646\u062f\u0627\u0631\u06cc\u062f. \u062f\u0631 \u0639\u0648\u0636\u060c \u0627\u0632 \u06cc\u06a9 \u0646\u0634\u0627\u0646\u0647 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 IAM \u0628\u0627 EF Core \u0648 Aurora Postgres \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n
\u0642\u0628\u0644 \u0627\u0632 \u0634\u0631\u0648\u0639\u060c \u0628\u0627\u06cc\u062f \u0686\u0646\u062f \u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632 \u0631\u0627 \u0631\u0639\u0627\u06cc\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n
\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 IAM Authentication \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Aurora Postgres.
\n\u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 IAM \u0628\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.
\nAWS CLI \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062d\u0644\u06cc \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n
\u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062e\u0637 \u0645\u0634\u06cc IAM \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0644\u06af\u0648 \u0627\u0633\u062a:<\/p>\n
{
\n “Version”: “2012-10-17”,
\n “Statement”: [
\n {
\n “Effect”: “Allow”,
\n “Action”: [
\n “rds-db:connect”
\n ],
\n “Resource”: [
\n “arn:aws:rds-db:[region]:[account-id]:dbuser:[db-cluster-resourceId]\/[db-user-name]”
\n ]\n }
\n ]\n}<\/p>\n[region] \u0645\u0646\u0637\u0642\u0647 AWS \u0628\u0631\u0627\u06cc \u062e\u0648\u0634\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u06cc\u06a9 \u0645\u0646\u0637\u0642\u0647 \u0627\u0633\u062a us-east-2.
\n[account-id] \u0634\u0645\u0627\u0631\u0647 \u062d\u0633\u0627\u0628 AWS \u0628\u0631\u0627\u06cc \u06a9\u0644\u0627\u0633\u062a\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u0634\u0645\u0627\u0631\u0647 \u062d\u0633\u0627\u0628 \u0627\u0633\u062a 1234567890.
\n[db-cluster-resourceId] \u0634\u0646\u0627\u0633\u0647 \u06a9\u0644\u0627\u0633\u062a\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0634\u0646\u0627\u0633\u0647 \u0627\u0633\u062a cluster-ABCDEFGHIJKL01234.
\n[db-user-name] \u0646\u0627\u0645 \u062d\u0633\u0627\u0628 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a IAM \u0627\u0633\u062a.<\/p>\n
\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645\u060c \u0622\u0646 \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 IAM \u062e\u0648\u062f \u0645\u062a\u0635\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a (\u0645\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 postgres \u06a9\u0627\u0631\u0628\u0631 \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0632\u06cc\u0631:<\/p>\n
CREATE DATABASE tasksmanager
\nWITH
\nENCODING = ‘UTF8’;<\/p>\n
\u0648 \u0633\u067e\u0633 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f:<\/p>\n
CREATE TABLE tasks(
\n id UUID PRIMARY KEY,
\n name VARCHAR(255)
\n);<\/p>\n
\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u06a9\u0627\u0631\u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647:<\/p>\n
CREATE USER db_iam_user;
\nGRANT rds_iam TO db_iam_user;
\nGRANT postgres TO db_iam_user;<\/p>\n
\u0627\u06a9\u0646\u0648\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 API .NET ASP Core Web \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0628\u0633\u062a\u0647 \u0647\u0627\u06cc NuGet \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0622\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n
AWSSDK.RDS.
\nNpgsql.EntityFrameworkCore.PostgreSQL.
\nEFCore.NamingConventions.<\/p>\n
\u062f\u0631 \u0645\u0627 appsetting.json\u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 a \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 ConnectionString \u062f\u0627\u0631\u0627\u06cc\u06cc:<\/p>\n
{
\n “Logging”: {
\n “LogLevel”: {
\n “Default”: “Information”,
\n “Microsoft.AspNetCore”: “Warning”
\n }
\n },
\n “AllowedHosts”: “*”,
\n “ConnectionString”: “host=[aurora-database-endpoint];Database=tasksmanager;Username=db_iam_user;SSL Mode=Require;TrustServerCertificate=true”
\n}<\/p>\n
\u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0628\u0627 \u0645\u062d\u062a\u0648\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n
public class Task
\n {
\n public Guid Id { get; set; }
\n public string Name { get; set; }<\/p>\n
private Task()
\n {<\/p>\n
}<\/p>\n
public Task(string name)
\n {
\n Id = Guid.NewGuid();
\n Name = name;
\n }
\n }<\/p>\n
\u0628\u0627 \u0622\u0646\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 DbContext \u06a9\u0644\u0627\u0633:<\/p>\n
public class ApplicationDbContext : DbContext
\n {
\n public DbSet<Task> Tasks { get; set; }<\/p>\n
public ApplicationDbContext(DbContextOptions options) : base(options)
\n {<\/p>\n
}
\n }<\/p>\n
\u062d\u0627\u0644\u0627 \u06cc\u06a9 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f ServiceCollectionExtensions.cs \u0641\u0627\u06cc\u0644 \u0627\u06cc\u0646\u062c\u0627 \u062c\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u0647 \u062c\u0627\u062f\u0648 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f:<\/p>\n
public static class ServiceCollectionExtensions
\n {
\n public static IServiceCollection AddPostgreSQL(this IServiceCollection services, IConfiguration configuration)
\n {
\n services.AddDbContext<ApplicationDbContext>(options =>
\n {
\n var connectionString = configuration[“ConnectionString”];
\n options.UseNpgsql(connectionString, npgsqlOption => { npgsqlOption.UseAwsIamAuthentication(); });
\n options.UseLowerCaseNamingConvention();
\n });
\n return services;
\n }<\/p>\n
public static NpgsqlDbContextOptionsBuilder UseAwsIamAuthentication(this NpgsqlDbContextOptionsBuilder optionsBuilder)
\n {
\n optionsBuilder.ProvidePasswordCallback(RequestAwsIamAuthToken);
\n return optionsBuilder;
\n }<\/p>\n
static string RequestAwsIamAuthToken(string host, int port, string database, string username)
\n {
\n return RDSAuthTokenGenerator.GenerateAuthToken(host, port, username);
\n }
\n }<\/p>\n
\u0633\u067e\u0633 \u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u062e\u0637 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f Program.cs \u0641\u0627\u06cc\u0644:<\/p>\n
builder.Services.AddPostgreSQL(builder.Configuration);<\/p>\n
\u0628\u0631\u0627\u06cc \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0648 \u067e\u0627\u0633\u062e \u0645\u0627 \u0686\u0646\u062f \u0645\u062f\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n
public class RegisterTaskCommand
\n {
\n public string Name { get; set; }
\n }<\/p>\n
public class ListTasksResult
\n {
\n public Guid Id { get; set; }
\n public string Name { get; set; }
\n }<\/p>\n
\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0645\u0627 TaskController.cs \u0641\u0627\u06cc\u0644:<\/p>\n
[ApiController]\n [Route(“[controller]”)]\n public class TasksController : ControllerBase
\n {
\n private readonly ApplicationDbContext _context;
\n public TasksController(ApplicationDbContext context)
\n {
\n _context = context;
\n }<\/p>\n
[HttpGet()]\n public Task<ListTasksResult[]> ListTasks()
\n {
\n return _context.Tasks.Select(t => new ListTasksResult() { Id = t.Id, Name = t.Name }).ToArrayAsync();
\n }<\/p>\n
[HttpPost()]\n public async Task<Guid> RegisterTask(RegisterTaskCommand command)
\n {
\n var task = new Task(command.Name);
\n _context.Tasks.Add(task);
\n await _context.SaveChangesAsync();
\n return task.Id;
\n }
\n }<\/p>\n
\u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u062a\u0635\u0627\u0644 \u0628\u062f\u0648\u0646 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0645\u0627\u0645 \u06a9\u062f\u0647\u0627 \u0648 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n
AWS Aurora (\u0647\u0645 MySQL \u0648 \u0647\u0645 Postgres) \u0648 MariaDB \u0627\u062c\u0627\u0632\u0647 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a IAM \u0631\u0627 \u0645\u06cc \u062f\u0647\u0646\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a\u060c \u0647\u0646\u06af\u0627\u0645 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u0646\u062f\u0627\u0631\u06cc\u062f. \u062f\u0631 \u0639\u0648\u0636\u060c \u0627\u0632 \u06cc\u06a9 \u0646\u0634\u0627\u0646\u0647 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 IAM \u0628\u0627 EF Core \u0648 Aurora Postgres \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n
\u0642\u0628\u0644 \u0627\u0632 \u0634\u0631\u0648\u0639\u060c \u0628\u0627\u06cc\u062f \u0686\u0646\u062f \u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632 \u0631\u0627 \u0631\u0639\u0627\u06cc\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n
\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 IAM Authentication \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Aurora Postgres.<\/p>\n<\/li>\n
\u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 IAM \u0628\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n<\/li>\n
AWS CLI \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062d\u0644\u06cc \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/li>\n<\/ul>\n
\u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062e\u0637 \u0645\u0634\u06cc IAM \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0644\u06af\u0648 \u0627\u0633\u062a:\n<\/p>\n
{<\/span>\n <\/span>\"Version\"<\/span>:<\/span> <\/span>\"2012-10-17\"<\/span>,<\/span>\n <\/span>\"Statement\"<\/span>:<\/span> <\/span>[<\/span>\n <\/span>{<\/span>\n <\/span>\"Effect\"<\/span>:<\/span> <\/span>\"Allow\"<\/span>,<\/span>\n <\/span>\"Action\"<\/span>:<\/span> <\/span>[<\/span>\n <\/span>\"rds-db:connect\"<\/span>\n <\/span>],<\/span>\n <\/span>\"Resource\"<\/span>:<\/span> <\/span>[<\/span>\n <\/span>\"arn:aws:rds-db:[region]:[account-id]:dbuser:[db-cluster-resourceId]\/[db-user-name]\"<\/span>\n <\/span>]<\/span>\n <\/span>}<\/span>\n <\/span>]<\/span>\n<\/span>}<\/span>\n<\/span><\/code><\/pre>\n<\/div>\n\n- \n
[region]<\/code> \u0645\u0646\u0637\u0642\u0647 AWS \u0628\u0631\u0627\u06cc \u062e\u0648\u0634\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u06cc\u06a9 \u0645\u0646\u0637\u0642\u0647 \u0627\u0633\u062a us-east-2<\/code>.<\/p>\n<\/li>\n- \n
[account-id]<\/code> \u0634\u0645\u0627\u0631\u0647 \u062d\u0633\u0627\u0628 AWS \u0628\u0631\u0627\u06cc \u06a9\u0644\u0627\u0633\u062a\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u0634\u0645\u0627\u0631\u0647 \u062d\u0633\u0627\u0628 \u0627\u0633\u062a 1234567890<\/code>.<\/p>\n<\/li>\n- \n
[db-cluster-resourceId]<\/code> \u0634\u0646\u0627\u0633\u0647 \u06a9\u0644\u0627\u0633\u062a\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0634\u0646\u0627\u0633\u0647 \u0627\u0633\u062a cluster-ABCDEFGHIJKL01234<\/code>.<\/p>\n<\/li>\n- \n
[db-user-name]<\/code> \u0646\u0627\u0645 \u062d\u0633\u0627\u0628 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a IAM \u0627\u0633\u062a.<\/p>\n<\/li>\n<\/ul>\n\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645\u060c \u0622\u0646 \u0631\u0627 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 IAM \u062e\u0648\u062f \u0645\u062a\u0635\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a (\u0645\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 postgres<\/code> \u06a9\u0627\u0631\u0628\u0631 \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u0647\u0627\u06cc \u0632\u06cc\u0631:\n<\/p>\n\nCREATE<\/span> DATABASE<\/span> tasksmanager<\/span>\nWITH<\/span> \nENCODING<\/span> =<\/span> 'UTF8'<\/span>;<\/span>\n<\/code><\/pre>\n<\/div>\n\u0648 \u0633\u067e\u0633 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f:\n<\/p>\n
\nCREATE<\/span> TABLE<\/span> tasks<\/span>(<\/span>\n id<\/span> UUID<\/span> PRIMARY<\/span> KEY<\/span>,<\/span>\n name<\/span> VARCHAR<\/span>(<\/span>255<\/span>)<\/span>\n);<\/span>\n<\/code><\/pre>\n<\/div>\n\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u06a9\u0627\u0631\u0628\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647:\n<\/p>\n
\nCREATE<\/span> USER<\/span> db_iam_user<\/span>;<\/span> \nGRANT<\/span> rds_iam<\/span> TO<\/span> db_iam_user<\/span>;<\/span>\nGRANT<\/span> postgres<\/span> TO<\/span> db_iam_user<\/span>;<\/span>\n<\/code><\/pre>\n<\/div>\n\u0627\u06a9\u0646\u0648\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 API .NET ASP Core Web \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0628\u0633\u062a\u0647 \u0647\u0627\u06cc NuGet \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0622\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n
\n- \n
AWSSDK.RDS.<\/p>\n<\/li>\n
- \n
Npgsql.EntityFrameworkCore.PostgreSQL.<\/p>\n<\/li>\n
- \n
EFCore.NamingConventions.<\/p>\n<\/li>\n<\/ul>\n
\u062f\u0631 \u0645\u0627 appsetting.json<\/code>\u060c \u0645\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u06cc\u0645 a \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 ConnectionString<\/code> \u062f\u0627\u0631\u0627\u06cc\u06cc:\n<\/p>\n\n{<\/span>\n <\/span>\"Logging\"<\/span>:<\/span> <\/span>{<\/span>\n <\/span>\"LogLevel\"<\/span>:<\/span> <\/span>{<\/span>\n <\/span>\"Default\"<\/span>:<\/span> <\/span>\"Information\"<\/span>,<\/span>\n <\/span>\"Microsoft.AspNetCore\"<\/span>:<\/span> <\/span>\"Warning\"<\/span>\n <\/span>}<\/span>\n <\/span>},<\/span>\n <\/span>\"AllowedHosts\"<\/span>:<\/span> <\/span>\"*\"<\/span>,<\/span>\n <\/span>\"ConnectionString\"<\/span>:<\/span> <\/span>\"host=[aurora-database-endpoint];Database=tasksmanager;Username=db_iam_user;SSL Mode=Require;TrustServerCertificate=true\"<\/span>\n<\/span>}<\/span>\n<\/span><\/code><\/pre>\n<\/div>\n\u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0628\u0627 \u0645\u062d\u062a\u0648\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f:\n<\/p>\n
\n public<\/span> class<\/span> Task<\/span>\n {<\/span>\n public<\/span> Guid<\/span> Id<\/span> {<\/span> get<\/span>;<\/span> set<\/span>;<\/span> }<\/span>\n public<\/span> string<\/span> Name<\/span> {<\/span> get<\/span>;<\/span> set<\/span>;<\/span> }<\/span>\n\n private<\/span> Task<\/span>()<\/span>\n {<\/span>\n\n }<\/span>\n\n public<\/span> Task<\/span>(<\/span>string<\/span> name<\/span>)<\/span>\n {<\/span>\n Id<\/span> =<\/span> Guid<\/span>.<\/span>NewGuid<\/span>();<\/span>\n Name<\/span> =<\/span> name<\/span>;<\/span>\n }<\/span>\n }<\/span>\n<\/code><\/pre>\n<\/div>\n\u0628\u0627 \u0622\u0646\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u062e\u0648\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 DbContext<\/code> \u06a9\u0644\u0627\u0633:\n<\/p>\n\n public<\/span> class<\/span> ApplicationDbContext<\/span> :<\/span> DbContext<\/span>\n {<\/span>\n public<\/span> DbSet<\/span><<\/span>Task<\/span>><\/span> Tasks<\/span> {<\/span> get<\/span>;<\/span> set<\/span>;<\/span> }<\/span>\n\n public<\/span> ApplicationDbContext<\/span>(<\/span>DbContextOptions<\/span> options<\/span>)<\/span> :<\/span> base<\/span>(<\/span>options<\/span>)<\/span>\n {<\/span>\n\n }<\/span>\n }<\/span>\n<\/code><\/pre>\n<\/div>\n\u062d\u0627\u0644\u0627 \u06cc\u06a9 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f ServiceCollectionExtensions.cs<\/code> \u0641\u0627\u06cc\u0644 \u0627\u06cc\u0646\u062c\u0627 \u062c\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u0647 \u062c\u0627\u062f\u0648 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f:\n<\/p>\n\n public<\/span>