Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Fix | Addressing documentation issues along with spelling errors#2889

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
David-Engel merged 5 commits intodotnet:mainfromJRahnama:spelling-errors
Sep 27, 2024
Merged
Show file tree
Hide file tree
Changes from3 commits
Commits
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
2 changes: 1 addition & 1 deletionCHANGELOG.md
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -1254,7 +1254,7 @@ This update brings the below changes over the previous release:
- Improved performance of Managed SNI by enhancing utilization of resources [#173](https://github.com/dotnet/SqlClient/pull/173) - Ported [dotnet/corefx#35363](https://github.com/dotnet/corefx/pull/35363) and [dotnet/corefx#40732](https://github.com/dotnet/corefx/pull/40732)
- Improved performance of Managed SNI RPC Parameter Usage [#209](https://github.com/dotnet/SqlClient/pull/209) - Ported [dotnet/corefx#34049](https://github.com/dotnet/corefx/pull/34049)
- Changed enclave key map to be lazy initialized [#372](https://github.com/dotnet/SqlClient/pull/372)
- Changed `Recieve()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `receive()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `EnclaveProviderBase` caching implementation to support Async Scenarios _(Introduces breaking changes)_ [#346](https://github.com/dotnet/SqlClient/pull/346)

## [Stable Release 1.1.0] - 2019-11-20
Expand Down
4 changes: 2 additions & 2 deletionsdoc/samples/SqlBulkCopy_ColumnMapping.cs
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -47,9 +47,9 @@ static void Main()
new SqlBulkCopyColumnMapping("Name", "ProdName");
bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMappingmapMumber =
SqlBulkCopyColumnMappingmapNumber =
new SqlBulkCopyColumnMapping("ProductNumber", "ProdNum");
bulkCopy.ColumnMappings.Add(mapMumber);
bulkCopy.ColumnMappings.Add(mapNumber);

// Write from the source to the destination.
try
Expand Down
2 changes: 1 addition & 1 deletiondoc/samples/SqlBulkCopy_ColumnMappingRemoveAt.cs
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -116,7 +116,7 @@ static void Main()
bulkCopy.DestinationTableName = "dbo.BulkCopyDemoOrderDetail";

// Rather than clearing mappings that are not necessary
// for the next bulkcopyo peration, the unneeded mappings
// for the next bulkcopy operation, the unneeded mappings
// are removed with the RemoveAt method.
bulkCopy.ColumnMappings.RemoveAt(2);
bulkCopy.ColumnMappings.RemoveAt(1);
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -828,7 +828,7 @@
The SQL Server type values of the column are copied into the <paramref name="values" /> array that is passed as a parameter. For null values, a Sql type instance is returned where the <see cref="P:System.Data.SqlTypes.INullable.IsNull" /> property is true.
</para>
<para>
The length of the <paramref name="value" /> array does not need to match the number of columns in the record. If the array length is greater than the number of columns, all the column values are copied into the array; if it is less, only the array length number of column values are copied into the array, starting at the column value with ordinal 0.
The length of the <paramref name="values" /> array does not need to match the number of columns in the record. If the array length is greater than the number of columns, all the column values are copied into the array; if it is less, only the array length number of column values are copied into the array, starting at the column value with ordinal 0.
</para>
</remarks>
<exception cref="T:System.ArgumentNullException">
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -63,7 +63,7 @@
Only the following are allowed to be passed to this constructor as <paramref name="dbType" />: <see cref="F:System.Data.SqlDbType.Bit" />, <see cref="F:System.Data.SqlDbType.BigInt" />, <see cref="F:System.Data.SqlDbType.DateTime" />, <see cref="F:System.Data.SqlDbType.Decimal" />, <see cref="F:System.Data.SqlDbType.Float" />, <see cref="F:System.Data.SqlDbType.Int" />, <see cref="F:System.Data.SqlDbType.Money" />, <c>Numeric</c>, <see cref="F:System.Data.SqlDbType.SmallDateTime" />, <see cref="F:System.Data.SqlDbType.SmallInt" />, <see cref="F:System.Data.SqlDbType.SmallMoney" />, <see cref="F:System.Data.SqlDbType.Timestamp" />, <see cref="F:System.Data.SqlDbType.TinyInt" />, <see cref="F:System.Data.SqlDbType.UniqueIdentifier" />, <see cref="F:System.Data.SqlDbType.Xml" />.
</para>
<para>
The following are the default values assigned to <paramref name="dtType" />, depending on the <see cref="T:System.Data.SqlDbType" /> (the <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionDatabase" />, <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionName" />, <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionOwningSchema" />, and <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.Type" /> properties are set to <see langword="null" />):
The following are the default values assigned to <paramref name="dbType" />, depending on the <see cref="T:System.Data.SqlDbType" /> (the <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionDatabase" />, <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionName" />, <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.XmlSchemaCollectionOwningSchema" />, and <see cref="P:Microsoft.Data.SqlClient.Server.SqlMetaData.Type" /> properties are set to <see langword="null" />):
</para>
<para>
<list type="table">
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -52,10 +52,10 @@
</CopyTo2>
<IndexOf1>
<summary>
Searches for the specified <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommand" /> within the <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" /> and returns the zero-based index of the firstoccurence within the entire <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" />.
Searches for the specified <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommand" /> within the <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" /> and returns the zero-based index of the firstoccurrence within the entire <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" />.
</summary>
<returns>
Returns the zero-based index of the firstoccurence within the entire <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" />.
Returns the zero-based index of the firstoccurrence within the entire <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommandCollection" />.
</returns>
</IndexOf1>
<IndexOf2>
Expand DownExpand Up@@ -87,7 +87,7 @@
</Insert2>
<Remove1>
<summary>
Removes the firstoccurence of a specific <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommand" /> object from the collection.
Removes the firstoccurrence of a specific <see cref="T:Microsoft.Data.SqlClient.SqlBatchCommand" /> object from the collection.
</summary>
<returns>
Returns <see langword="true" /> if an item is successfully removed. Returns false if an item could not be removed or no item was not found.
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -74,9 +74,9 @@
new SqlBulkCopyColumnMapping("Name", "ProdName");
bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMappingmapMumber =
SqlBulkCopyColumnMappingmapNumber =
new SqlBulkCopyColumnMapping("ProductNumber", "ProdNum");
bulkCopy.ColumnMappings.Add(mapMumber);
bulkCopy.ColumnMappings.Add(mapNumber);

// Write from the source to the destination.
try
Expand DownExpand Up@@ -180,9 +180,9 @@
new SqlBulkCopyColumnMapping("Name", "ProdName");
bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMappingmapMumber =
SqlBulkCopyColumnMappingmapNumber =
new SqlBulkCopyColumnMapping("ProductNumber", "ProdNum");
bulkCopy.ColumnMappings.Add(mapMumber);
bulkCopy.ColumnMappings.Add(mapNumber);

// Write from the source to the destination.
try
Expand DownExpand Up@@ -630,9 +630,9 @@
new SqlBulkCopyColumnMapping("Name", "ProdName");
bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMappingmapMumber =
SqlBulkCopyColumnMappingmapNumber =
new SqlBulkCopyColumnMapping("ProductNumber", "ProdNum");
bulkCopy.ColumnMappings.Add(mapMumber);
bulkCopy.ColumnMappings.Add(mapNumber);

// Write from the source to the destination.
try
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -182,9 +182,9 @@
new SqlBulkCopyColumnMapping("Name", "ProdName");
bulkCopy.ColumnMappings.Add(mapName);

SqlBulkCopyColumnMappingmapMumber =
SqlBulkCopyColumnMappingmapNumber =
new SqlBulkCopyColumnMapping("ProductNumber", "ProdNum");
bulkCopy.ColumnMappings.Add(mapMumber);
bulkCopy.ColumnMappings.Add(mapNumber);

// Write from the source to the destination.
try
Expand DownExpand Up@@ -1252,7 +1252,7 @@
bulkCopy.DestinationTableName = "dbo.BulkCopyDemoOrderDetail";

// Rather than clearing mappings that are not necessary
// for the next bulkcopyo peration, the unneeded mappings
// for the next bulkcopy operation, the unneeded mappings
// are removed with the RemoveAt method.
bulkCopy.ColumnMappings.RemoveAt(2);
bulkCopy.ColumnMappings.RemoveAt(1);
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -488,7 +488,7 @@
<members name="SqlClientTransactionRollbackError">
<SqlClientTransactionRollbackError>
<summary>
Contains diagnostic information emitted after a transaction roll backfailes with an exception.
Contains diagnostic information emitted after a transaction roll backfails with an exception.
</summary>
</SqlClientTransactionRollbackError>
<Name>
Expand Down
6 changes: 3 additions & 3 deletionsdoc/snippets/Microsoft.Data.SqlClient/SqlCommand.xml
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -866,7 +866,7 @@
The <see cref="T:Microsoft.Data.SqlClient.SqlConnection" /> closed or dropped during a streaming operation. For more information about streaming, see <see href='/sql/connect/ado-net/sqlclient-streaming-support'>SqlClient Streaming Support</see>.
</item>
<item>
<see cref="P:Microssoft.Data.SqlClient.SqlCommand.EnableOptimizedParameterBinding" /> is set to true and a parameter with direction Output or InputOutput has been added to the <see cref="P:Microsoft.Data.SqlClient.SqlCommand.Parameters" /> collection.
<see cref="P:Microsoft.Data.SqlClient.SqlCommand.EnableOptimizedParameterBinding" /> is set to true and a parameter with direction Output or InputOutput has been added to the <see cref="P:Microsoft.Data.SqlClient.SqlCommand.Parameters" /> collection.
</item>
</list>
</exception>
Expand DownExpand Up@@ -1380,7 +1380,7 @@
The <see cref="T:Microsoft.Data.SqlClient.SqlConnection" /> closed or dropped during a streaming operation. For more information about streaming, see <see href='/sql/connect/ado-net/sqlclient-streaming-support'>SqlClient Streaming Support</see>.
</item>
<item>
<see cref="P:Microssoft.Data.SqlClient.SqlCommand.EnableOptimizedParameterBinding" /> is set to true and a parameter with direction Output or InputOutput has been added to the <see cref="P:Microsoft.Data.SqlClient.SqlCommand.Parameters" /> collection.
<see cref="P:Microsoft.Data.SqlClient.SqlCommand.EnableOptimizedParameterBinding" /> is set to true and a parameter with direction Output or InputOutput has been added to the <see cref="P:Microsoft.Data.SqlClient.SqlCommand.Parameters" /> collection.
</item>
</list>
</exception>
Expand DownExpand Up@@ -2723,7 +2723,7 @@
Gets or sets a value indicating whether the command object should optimize parameter performance by disabling Output and InputOutput directions when submitting the command to the SQL Server. <br /> This option is only used when the <see cref="P:Microsoft.Data.SqlClient.SqlCommand.CommandType" /> is <see cref="F:System.Data.CommandType.Text"/> otherwise it is ignored.
</summary>
<value>
A value indicating whether the command object should optimize parameter performance by disabling Output andInputOuput parameter directions when submitting the command to the SQL Server. The default is <see langword="false" />.
A value indicating whether the command object should optimize parameter performance by disabling Output andInputOutput parameter directions when submitting the command to the SQL Server. The default is <see langword="false" />.
</value>
<remarks>
<para>
Expand Down
2 changes: 1 addition & 1 deletionrelease-notes/2.0/2.0.0-preview1.md
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -22,7 +22,7 @@ This update brings the below changes over the previous release:
- Improved performance of Managed SNI by enhancing utilization of resources [#173](https://github.com/dotnet/SqlClient/pull/173) - Ported [dotnet/corefx#35363](https://github.com/dotnet/corefx/pull/35363) and [dotnet/corefx#40732](https://github.com/dotnet/corefx/pull/40732)
- Improved performance of Managed SNI RPC Parameter Usage [#209](https://github.com/dotnet/SqlClient/pull/209) - Ported [dotnet/corefx#34049](https://github.com/dotnet/corefx/pull/34049)
- Changed enclave key map to be lazy initialized [#372](https://github.com/dotnet/SqlClient/pull/372)
- Changed `Recieve()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `Receive()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `EnclaveProviderBase` caching implementation to support Async Scenarios _(Introduces breaking changes)_ [#346](https://github.com/dotnet/SqlClient/pull/346)

### Breaking Changes
Expand Down
2 changes: 1 addition & 1 deletionrelease-notes/2.0/2.0.0.md
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -81,7 +81,7 @@ All changes in Microsoft.Data.SqlClient v2.0 over v1.1:
- Improved performance of Managed SNI by enhancing utilization of resources [#173](https://github.com/dotnet/SqlClient/pull/173) - Ported [dotnet/corefx#35363](https://github.com/dotnet/corefx/pull/35363) and [dotnet/corefx#40732](https://github.com/dotnet/corefx/pull/40732)
- Improved performance of Managed SNI RPC Parameter Usage [#209](https://github.com/dotnet/SqlClient/pull/209) - Ported [dotnet/corefx#34049](https://github.com/dotnet/corefx/pull/34049)
- Changed enclave key map to be lazy initialized [#372](https://github.com/dotnet/SqlClient/pull/372)
- Changed `Recieve()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `Receive()` and `ReceiveAsync()` implementation to receive null packets on failure [#350](https://github.com/dotnet/SqlClient/pull/350)
- Changed `EnclaveProviderBase` caching implementation to support Async Scenarios _(Introduces breaking changes)_ [#346](https://github.com/dotnet/SqlClient/pull/346)
- Updated all driver assemblies to be CLS Compliant [#396](https://github.com/dotnet/SqlClient/pull/396)
- Updated Bulk Copy error messages to also include Column, Row and non-encrypted Data information [#437](https://github.com/dotnet/SqlClient/pull/437)
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -92,7 +92,7 @@ public SNIPacket()
public int DataLeft => (_dataLength - _dataOffset);

/// <summary>
/// Indicates that the packet should be sent out of band bypassing the normal send-recieve lock
/// Indicates that the packet should be sent out of band bypassing the normal send-receive lock
/// </summary>
public bool IsOutOfBand { get; set; }

Expand DownExpand Up@@ -181,7 +181,7 @@ public void AppendData(byte[] data, int size)
}

/// <summary>
/// Read data from the packet into the buffer at dataOffset forzize and then remove that data from the packet
/// Read data from the packet into the buffer at dataOffset forsize and then remove that data from the packet
/// </summary>
/// <param name="buffer">Buffer</param>
/// <param name="dataOffset">Data offset to write data at</param>
Expand Down
Original file line numberDiff line numberDiff line change
Expand Up@@ -704,7 +704,7 @@ public override uint Send(SNIPacket packet)
try
{
// is the packet is marked out out-of-band (attention packets only) it must be
// sent immediately even if a sendof recieve operation is already in progress
// sent immediately even if a sendor receive operation is already in progress
// because out of band packets are used to cancel ongoing operations
// so try to take the lock if possible but continue even if it can't be taken
if (packet.IsOutOfBand)
Expand Down
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -18,8 +18,8 @@ internal sealed class SSRP
{
private const char SemicolonSeparator = ';';
private const int SqlServerBrowserPort = 1434; //port SQL Server Browser
private const intRecieveMAXTimeoutsForCLNT_BCAST_EX = 15000; //Default max time for response wait
private const intRecieveTimeoutsForCLNT_BCAST_EX = 1000; //subsequent wait time for response after intial wait
private const intReceiveMAXTimeoutsForCLNT_BCAST_EX = 15000; //Default max time for response wait
private const intReceiveTimeoutsForCLNT_BCAST_EX = 1000; //subsequent wait time for response after intial wait
private const int ServerResponseHeaderSizeForCLNT_BCAST_EX = 3;//(SVR_RESP + RESP_SIZE) https://docs.microsoft.com/en-us/openspecs/windows_protocols/mc-sqlr/2e1560c9-5097-4023-9f5e-72b9ff1ec3b1
private const int ValidResponseSizeForCLNT_BCAST_EX = 4096; //valid reponse size should be less than 4096
private const int FirstTimeoutForCLNT_BCAST_EX = 5000;//wait for first response for 5 seconds
Expand DownExpand Up@@ -383,11 +383,11 @@ private static SsrpResult SendUDPRequest(IPEndPoint endPoint, byte[] requestPack
}

/// <summary>
/// Sends request to server, andrecieves response from server (SQLBrowser) on port 1434 by UDP
/// Sends request to server, andreceives response from server (SQLBrowser) on port 1434 by UDP
/// Request (https://docs.microsoft.com/en-us/openspecs/windows_protocols/mc-sqlr/a3035afa-c268-4699-b8fd-4f351e5c8e9e)
/// Response (https://docs.microsoft.com/en-us/openspecs/windows_protocols/mc-sqlr/2e1560c9-5097-4023-9f5e-72b9ff1ec3b1)
/// </summary>
/// <returns>stringconstaning list of SVR_RESP(just RESP_DATA)</returns>
/// <returns>stringcontaining list of SVR_RESP(just RESP_DATA)</returns>
internal static string SendBroadcastUDPRequest()
{
StringBuilder response = new StringBuilder();
Expand All@@ -407,9 +407,9 @@ internal static string SendBroadcastUDPRequest()
sw.Start();
try
{
while ((receiveTask = clientListener.ReceiveAsync()).Wait(currentTimeOut) && sw.ElapsedMilliseconds <=RecieveMAXTimeoutsForCLNT_BCAST_EX && receiveTask != null)
while ((receiveTask = clientListener.ReceiveAsync()).Wait(currentTimeOut) && sw.ElapsedMilliseconds <=ReceiveMAXTimeoutsForCLNT_BCAST_EX && receiveTask != null)
{
currentTimeOut =RecieveTimeoutsForCLNT_BCAST_EX;
currentTimeOut =ReceiveTimeoutsForCLNT_BCAST_EX;
SqlClientEventSource.Log.TrySNITraceEvent(nameof(SSRP), EventType.INFO, "Received instnace info from UDP Client.");
if (receiveTask.Result.Buffer.Length < ValidResponseSizeForCLNT_BCAST_EX) //discard invalid response
{
Expand Down
Loading
Loading
[8]ページ先頭
©2009-2025 Movatter.jp