To delete duplicate records using MSSQL you can use the following snippet.
The table must have identity column, which will be used to identify the duplicate records.
DELETE FROM TableName WHERE ID NOT IN ( SELECT MAX(ID) FROM TableName GROUP BY ColumnWithDuplicatesName)
To copy one stream to another in C# and VB.NET you can use the following snippet.
//.NET 3.5
public static void CopyStream(Stream inputStream, Stream outputStream)
{
var bytes = new byte[4096];
int count;
while ((count = inputStream.Read(bytes, 0, bytes.Length)) > 0)
{
outputStream.Write(bytes, 0, count);
}
}
//.NET 4.0 +
public static void CopyStream(Stream inputStream, Stream outputStream)
{
inputStream.CopyTo(outputStream, 4096);
}
//.NET 4.5+
inputStream.CopyToAsync(outputStream, 4096);
'.NET 3.5
Public Shared Sub CopyStream(inputStream As Stream, outputStream As Stream)
Dim bytes = New Byte(4095) {}
Dim count As Integer
While (InlineAssignHelper(count, inputStream.Read(bytes, 0, bytes.Length))) > 0
outputStream.Write(bytes, 0, count)
End While
End Sub
'.NET 4.0 +
Public Shared Sub CopyStream(inputStream As Stream, outputStream As Stream)
inputStream.CopyTo(outputStream, 4096)
End Sub
'.NET 4.5 +
inputStream.CopyToAsync(outputStream, 4096)