Tag Archive DSN

  • Home   /  
  • Posts tagged "DSN"
Byphunsanit
, , , , , ,

C#: connection database ใน .NET Core

หลังจากได้ Connection Strings มาจากวิธี C#: Connection string ก็สามารถนำมาใช้ในโปรแกรมที่เขียนให้ติดต่อกับ database โดยใช้ .NET Core, MVC และ Entity Framework Core ( .NET Core EF ) Data Source Name ( DSN )

  1. เก็บข้อมูล Connection Strings สามารถเก็บได้ที่ ไฟล์ appsettings.json โดยเพิ่ม “ConnectionStrings” ใน
    appsettings.json
    เช่น
    ?
    1
    2
    3
    4
    5
    ...
      "ConnectionStrings": {
        "{ DSN name }": "{ Connection Strings }"
      },
    ...
    ?
    1
    2
    3
    4
    5
    ...
      "ConnectionStrings": {
        "DSNDevContext": "Encrypt=False;Initial Catalog=Pine;Password=%mpLST38c2q8K2;Persist Security Info=True;Trust Server Certificate=True;User ID=T8NSFTE8FyRV;"
      },
    ...
  2. จากนั้นจะสามารถดึงช้อมูลมาใช้ได้โดยเพิ่ม
    /Program.cs
    ?
    1
    2
    3
    4
    5
    ...
    //This section below is for connection string
    var connectionString = builder.Configuration.GetConnectionString("DSNDevContext");
    builder.Services.AddDbContext<DSNDevDBContext>(options => options.UseSqlServer(connectionString));
    ...
  3. จากนั้นสร้างส่วนเชื่อมโยง model ด้วยกัน เช่น
    Models/DSNDevDBContext.cs
    ?
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    namespace Pine.Models;
     
    using Microsoft.EntityFrameworkCore;
     
    public class DSNDevDBContext(DbContextOptions<DSNDevDBContext> options) : DbContext(options)
    {
        protected readonly IConfiguration Configuration;
     
        //model table
        public virtual DbSet<line_logins> line_Logins { get; set; }
     
        //end model table
    }
  4. สร้าง model แทนตัว database table เช่น
    /Model/line_logins.cs
    ?
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    using Microsoft.EntityFrameworkCore;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Diagnostics.CodeAnalysis;
     
    namespace Pine.Models
    {
        public class line_logins
        {
            [Key]
            [Column("client_id", Order = 0, TypeName = "VARCHAR(50)")]
            [Comment("The URL of the blog")]
            [MaxLength(50)]
            public string client_id { get; set; }
     
            [Required]
            [Column("client_secret", Order = 1, TypeName = "VARCHAR(50)")]
            [Comment("The URL of the blog")]
            [MaxLength(50)]
            public string client_secret { get; set; }
     
            [Required]
            [Column("code", Order = 2, TypeName = "VARCHAR(50)")]
            [Comment("The URL of the blog")]
            [MaxLength(50)]
            public string code { get; set; }
     
            [AllowNull]
            [Column("code_verifier", Order = 3, TypeName = "VARCHAR(50)")]
            [Comment("The URL of the blog")]
            [MaxLength(50)]
            public string? code_verifier { get; set; }
     
            [Required]
            [Column("grant_type", Order = 4, TypeName = "VARCHAR(50)")]
            [Comment("The URL of the blog")]
            [MaxLength(50)]
            public string grant_type { get; set; }
     
            [Required]
            [Column("redirect_uri", Order = 5, TypeName = "VARCHAR(2048)")]
            [Comment("The URL of the blog")]
            [MaxLength(2048)]
            public string redirect_uri { get; set; }
        }
    }
  5. ตัวอย่างการเรียกใช้
    \Controllers\LineLoginsController.cs
    ?
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    using Microsoft.AspNetCore.Mvc;
    using Microsoft.EntityFrameworkCore;
    using Pine.Models;
     
    namespace Pine.Controllers
    {
        public class LineLoginsController : Controller
        {
            private readonly DSNDevDBContext _context;
     
            public LineLoginsController(DSNDevDBContext context)
            {
                _context = context;
            }
     
            // GET: LineLogins/Create
            public IActionResult Create()
            {
                return View();
            }
     
            // POST: LineLogins/Create To protect from overposting attacks, enable the specific
            // properties you want to bind to. For more details, see http://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public async Task<IActionResult> Create([Bind("client_id,client_secret,code,code_verifier,grant_type,redirect_uri")] line_logins line_logins)
            {
                if (ModelState.IsValid)
                {
                    _context.Add(line_logins);
                    await _context.SaveChangesAsync();
                    return RedirectToAction(nameof(Index));
                }
                return View(line_logins);
            }
     
            // GET: LineLogins/Delete/5
            public async Task<IActionResult> Delete(string id)
            {
                if (id == null)
                {
                    return NotFound();
                }
     
                var line_logins = await _context.line_Logins
                    .FirstOrDefaultAsync(m => m.client_id == id);
                if (line_logins == null)
                {
                    return NotFound();
                }
     
                return View(line_logins);
            }
     
            // POST: LineLogins/Delete/5
            [HttpPost, ActionName("Delete")]
            [ValidateAntiForgeryToken]
            public async Task<IActionResult> DeleteConfirmed(string id)
            {
                var line_logins = await _context.line_Logins.FindAsync(id);
                if (line_logins != null)
                {
                    _context.line_Logins.Remove(line_logins);
                }
     
                await _context.SaveChangesAsync();
                return RedirectToAction(nameof(Index));
            }
     
            // GET: LineLogins/Details/5
            public async Task<IActionResult> Details(string id)
            {
                if (id == null)
                {
                    return NotFound();
                }
     
                var line_logins = await _context.line_Logins
                    .FirstOrDefaultAsync(m => m.client_id == id);
                if (line_logins == null)
                {
                    return NotFound();
                }
     
                return View(line_logins);
            }
     
            // GET: LineLogins/Edit/5
            public async Task<IActionResult> Edit(string id)
            {
                if (id == null)
                {
                    return NotFound();
                }
     
                var line_logins = await _context.line_Logins.FindAsync(id);
                if (line_logins == null)
                {
                    return NotFound();
                }
                return View(line_logins);
            }
     
            // POST: LineLogins/Edit/5 To protect from overposting attacks, enable the specific
            // properties you want to bind to. For more details, see http://go.microsoft.com/fwlink/?LinkId=317598.
            [HttpPost]
            [ValidateAntiForgeryToken]
            public async Task<IActionResult> Edit(string id, [Bind("client_id,client_secret,code,code_verifier,grant_type,redirect_uri")] line_logins line_logins)
            {
                if (id != line_logins.client_id)
                {
                    return NotFound();
                }
     
                if (ModelState.IsValid)
                {
                    try
                    {
                        _context.Update(line_logins);
                        await _context.SaveChangesAsync();
                    }
                    catch (DbUpdateConcurrencyException)
                    {
                        if (!line_loginsExists(line_logins.client_id))
                        {
                            return NotFound();
                        }
                        else
                        {
                            throw;
                        }
                    }
                    return RedirectToAction(nameof(Index));
                }
                return View(line_logins);
            }
     
            // GET: LineLogins
            public async Task<IActionResult> Index()
            {
                return View(await _context.line_Logins.ToListAsync());
            }
     
            private bool line_loginsExists(string id)
            {
                return _context.line_Logins.Any(e => e.client_id == id);
            }
        }
    }

อ่านเพิ่มเติม

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Posts

Proudly powered by WordPress | Theme: Appointment by Webriti