@manhnguyenv

Welcome to my blog!

SQL Helper

February 25, 2019 16:44

SQL Helper (edit)

Không thể thêm Description cho Column trong khi tạo Table sử dụng Entity Framework Core

https://github.com/aspnet/EntityFrameworkCore/issues/7029

How to set Column Description - How to set the description on a SQL column using EF Core Code First

https://github.com/aspnet/EntityFrameworkCore/issues/7029

Thêm Description cho Column trong khi tạo Table sử dụng Entity Framework

Lớp: DbDescriptionUpdater.cs

https://stackoverflow.com/questions/10080601/how-to-add-description-to-columns-in-entity-framework-4-3-code-first-using-migra

How can I get and set the description property of a SQL Server 2008 table using SMO?

https://stackoverflow.com/questions/14448622/how-can-i-get-and-set-the-description-property-of-a-sql-server-2008-table-using

$s = new-object microsoft.sqlserver.management.smo.server '.';
$db = $s.Databases['AdventureWorks2012'];
$t = $db.Tables | where {$_.Name -eq 'Address'};
$t.ExtendedProperties['MS_Description']; # will print current value
$t.ExtendedProperties['MS_Description'].Value = 'new value';
$t.ExtendedProperties['MS_Description'].Alter(); #persist the new value to the database

Classes for reading data from Sql Server into objects

https://codereview.stackexchange.com/questions/86975/classes-for-reading-data-from-sql-server-into-objects

SQL cổ điển: SqlServerTransaction, SqlServerConnection, SqlCommand, SqlDataAdapter, SqlDataReader, DataTable, DataSet

SqlCommand site:www.dotnetperls.com

https://www.progress.com/tutorials/ado-net/code-examples-sql-server

Categories

Recent posts