This is an example to demo how you generate the RSA key pair from server side(.NetCore 3.1) and pass the public key to the client(Browser) for encrypting the data that <= 245 bytes.
RSA-2048 can only support to encrypt up to 245 bytes data.
using var rsaProvider = new RSACng();
// spki is used for browser side encryption
var spki = Convert.ToBase64String(rsaProvider.ExportSubjectPublicKeyInfo());
var encodedPrivateKey = Convert.ToBase64String(rsaProvider.ExportPkcs8PrivateKey());
| SQL Server 2017 | |
| ---------------- | |
| Enterprise Core - 6GPYM-VHN83-PHDM2-Q9T2R-KBV83 | |
| Developer - 22222-00000-00000-00000-00000 | |
| Enterprise - TDKQD-PKV44-PJT4N-TCJG2-3YJ6B | |
| Standard - PHDV4-3VJWD-N7JVP-FGPKY-XBV89 | |
| Web - WV79P-7K6YG-T7QFN-M3WHF-37BXC | |
| https://www.teamos-hkrg.com/index.php?threads/microsoft-sql-server-english-2017-rtm-teamos.42103/ |
| EXEC sp_attach_db @dbname = N'AdventureWorks2012', | |
| @filename1 = | |
| N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_Data.mdf', | |
| @filename2 = | |
| N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_log.ldf'; |
| -- Colocar esta seccion en Program.cs | |
| public static IWebHostBuilder CreateWebHostBuilder(string[] args) | |
| { | |
| return WebHost.CreateDefaultBuilder(args) | |
| .UseStartup<Startup>() | |
| .ConfigureAppConfiguration((hostingContext, config) => | |
| { | |
| config.AddJsonFile($"appsettings.release.json", true, true) | |
| .AddJsonFile($"appsettings.test.json", true, true) | |
| .AddJsonFile($"appsettings.json", true, true); |
| # Copyright (c) 1993-2009 Microsoft Corp. | |
| # | |
| # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. | |
| # | |
| # This file contains the mappings of IP addresses to host names. Each | |
| # entry should be kept on an individual line. The IP address should | |
| # be placed in the first column followed by the corresponding host name. | |
| # The IP address and the host name should be separated by at least one | |
| # space. | |
| # |
| -- ELMAH - Error Logging Modules and Handlers for ASP.NET | |
| -- Copyright (c) 2004-9 Atif Aziz. All rights reserved. | |
| -- | |
| -- Author(s): | |
| -- | |
| -- Nick Berardi, http://www.coderjournal.com | |
| -- | |
| -- Licensed under the Apache License, Version 2.0 (the "License"); | |
| -- you may not use this file except in compliance with the License. | |
| -- You may obtain a copy of the License at |
| /* | |
| ELMAH - Error Logging Modules and Handlers for ASP.NET | |
| Copyright (c) 2004-9 Atif Aziz. All rights reserved. | |
| Author(s): | |
| Atif Aziz, http://www.raboof.com | |
| Phil Haacked, http://haacked.com | |
| WITH UnUsedTables ( | |
| TableName | |
| ,TotalRowCount | |
| ,CreatedDate | |
| ,LastModifiedDate | |
| ) | |
| AS ( | |
| SELECT DBTable.NAME AS TableName | |
| ,PS.row_count AS TotalRowCount | |
| ,DBTable.create_date AS CreatedDate |
| /* | |
| ELMAH - Error Logging Modules and Handlers for ASP.NET | |
| Copyright (c) 2004-9 Atif Aziz. All rights reserved. | |
| Author(s): | |
| Atif Aziz, http://www.raboof.com | |
| Phil Haacked, http://haacked.com | |
| [user] | |
| name = Pavan Kumar Sunkara | |
| email = pavan.sss1991@gmail.com | |
| [core] | |
| editor = vim | |
| whitespace = fix,-indent-with-non-tab,trailing-space,cr-at-eol | |
| excludesfile = ~/.gitignore | |
| [sendemail] | |
| smtpencryption = tls | |
| smtpserver = smtp.gmail.com |