This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DOD (Definition of Done) | |
- code is ready | |
- code has unit tests | |
- code has integration tests | |
- applied SOLID | |
Documnetation | |
- documentation is procudes |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select * from sys.tables as t | |
inner join sys.columns as c | |
on t.object_id = c.object_id | |
inner join sys.index_columns as ic | |
on c.column_id = ic.column_id and c.object_id = ic.object_id | |
inner join sys.indexes as i | |
on ic.index_id = i.index_id and ic.object_id = i.object_id | |
WHERE t.name = 'table_name' AND i.name = 'index_name' | |
-- where t.name = 'table_name' and c.name = 'column_name' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public partial class ApiClient | |
{ | |
private readonly HttpClient _httpClient; | |
private Uri BaseEndpoint { get; set; } | |
public ApiClient(Uri baseEndpoint) | |
{ | |
if (baseEndpoint == null) | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<package xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd"> | |
<metadata> | |
<id>project</id> | |
<version>0.0.1</version> | |
<authors>authors</authors> | |
<owners>Owners</owners> | |
<requireLicenseAcceptance>false</requireLicenseAcceptance> | |
<description>package desciptions</description> | |
</metadata> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/// <summary> | |
/// used to provide definition for gateway service about active keys for clients, to about active client configuration | |
/// </summary> | |
/// <param name="token"></param> | |
/// <returns></returns> | |
[HttpGet] | |
public IActionResult GetClientList(string token) | |
{ | |
if (ValidateToken(token)) | |
{ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
string sendingIp = "192.168.0.1"; | |
int sendingPort = 5000; | |
Uri uri = new Uri("http://google.com"); | |
HttpWebRequest wr = (HttpWebRequest)WebRequest.Create(uri); | |
ServicePoint sp = ServicePointManager.FindServicePoint(uri); | |
sp.BindIPEndPointDelegate = | |
(servicePoint,remoteEp,retryCount) => | |
{ | |
return new IPEndPoint(IPAddress.Parse(sendingIp),sendingPort); | |
}; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
steps: | |
- task: PublishBuildArtifacts@1 | |
displayName: Publish Artifact: DynamicPowerShellArguments | |
inputs: | |
PathtoPublish: test.ps1 | |
ArtifactName: DynamicPowerShellArguments | |
publishLocation: Container |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8" ?> | |
<configuration> | |
<startup> | |
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" /> | |
</startup> | |
<connectionStrings> | |
<add name="ConnectionStringUnderTest" connectionString="Data Source=localhost;Initial Catalog=MyDatabaseCatalogToReplace;Integrated Security=True" /> | |
</connectionStrings> | |
<appSettings> | |
<add key="CommandTimeOut" value="90"/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Username user | |
Domain domain | |
# provide actual value if autodetection fails | |
# Workstation pc-name | |
Proxy my_proxy_server.com:80 | |
NoProxy 127.0.0.*, 192.168.* | |
Listen 127.0.0.1:54321 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DROP TABLE IF EXISTS dbo.Product | |
DROP TRIGGER IF EXISTS trProductInsert | |
DROP PROCEDURE IF EXISTS [dbo].[InsertData] |
NewerOlder