Windows EventView Logins Codes

Logins Codes in EventView Securities

4624, 4648, 4634, 4672, 4647

https://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventID=4624

https://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventID=4648

https://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventID=4634

https://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventID=4672

https://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventID=4647

Create Index in Entity Framework

http://stackoverflow.com/questions/22618237/how-to-create-index-in-entity-framework-6-2-with-code-first

Entity framework inheritance-strategy-in-code-first

http://www.entityframeworktutorial.net/code-first/inheritance-strategy-in-code-first.aspx

https://msdn.microsoft.com/en-us/library/jj618293(v=vs.113).aspx

https://msdn.microsoft.com/en-us/library/jj618293(v=vs.113).aspx

https://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/implementing-inheritance-with-the-entity-framework-in-an-asp-net-mvc-application

EF Data Annotations NEW

https://msdn.microsoft.com/en-in/data/jj591583

https://msdn.microsoft.com/ru-ru/data/gg193958.aspx

sp_executesql

exec sp_executesql N'UPDATE [dbo].[Students]
SET [StudentName] = @0
WHERE (([StudentId] = @1) AND ([StudentName] = @2))
',N'@0 nvarchar(max) ,@1 int,@2 nvarchar(max) ',@0=N'Steve',@1=1,@2=N'Bill'
go

exec sp_executesql
N'UPDATE [dbo].[Students]
SET [StudentName] = @0
WHERE (([StudentId] = @1) AND ([StudentName] = @2))',
N'@0 nvarchar(max) , @1 int, @2 nvarchar(max)  ',
 @0=N'Steve', @1=1, @2=N'Bill'
GO

EF Data Annotations NEW

https://msdn.microsoft.com/en-in/data/jj591583

https://msdn.microsoft.com/ru-ru/data/gg193958.aspx

EF Data Annotations NEW

https://msdn.microsoft.com/en-in/data/jj591583

EF DateTime to Date MS SQL Field

http://stackoverflow.com/questions/5658216/entity-framework-code-first-date-field-creation

http://stackoverflow.com/questions/31912326/how-to-use-date-only-as-data-type-in-entity-framework

XML Conversion XDocument to XmlDocument and vise versa

http://www.aspnetify.com/2014/04/convert-between-xdocument-and.html

https://blogs.msdn.microsoft.com/xmlteam/2009/03/31/converting-from-xmldocument-to-xdocument/

System SQL DateTime Function and RowVersion

https://msdn.microsoft.com/ru-ru/library/ms188751.aspx

https://msdn.microsoft.com/ru-ru/library/ms182776.aspx

https://habrahabr.ru/post/61391/

Regex and Html parse

http://stackoverflow.com/questions/1732348/regex-match-open-tags-except-xhtml-self-contained-tags

Html Parser

https://habrahabr.ru/post/112325/

http://htmlagilitypack.codeplex.com/

http://stackoverflow.com/questions/56107/what-is-the-best-way-to-parse-html-in-c

https://github.com/MindTouch/SGMLReader

http://stackoverflow.com/questions/2091645/how-to-parse-this-piece-of-html

http://niknolaty.blogspot.ru/2012/03/html-xml.html

git rebase

https://habrahabr.ru/post/161009/

git pull --rebase origin feature

Коммутаторы (Switch)

https://market.yandex.ru/articles/kak-vybrat-kommutator?track=fr_ctlg_list&show-uid=760860920022800117400004

Router to Switch Setup Linksys WRT54G

http://www.linksysinfo.org/index.php?threads/second-wrt54g-as-switch.28489/

http://nastroyvse.ru/devices/ruter/kak-sdelat-iz-routera-svitch.html

Git Branching

https://git-scm.com/book/ru/v1/%D0%92%D0%B5%D1%82%D0%B2%D0%BB%D0%B5%D0%BD%D0%B8%D0%B5-%D0%B2-Git-%D0%A7%D1%82%D0%BE-%D1%82%D0%B0%D0%BA%D0%BE%D0%B5-%D0%B2%D0%B5%D1%82%D0%BA%D0%B0%3F

Восстановление точки останова

https://www.youtube.com/watch?v=GaqZeVHxI6w

git commit with rebase schema

Commit

git fetch origin dev


git rebase origin/dev


git push origin dev

gitlab new

Git global setup

git config --global user.name ""
git config --global user.email ""

Create a new repository

git clone https://gitlab.com/groupe/gs.git
cd gs
touch README.md
git add README.md
git commit -m "add README"
git push -u origin master

Existing folder or Git repository

cd existing_folder
git init
git remote add origin https://gitlab.com/groupe/gs.gitgit add .
git commit
git push -u origin master

2222222222222222

Git global setup

git config --global user.name ""
git config --global user.email ""

Create a new repository

git clone https://gitlab.com/user/gs.trade.git
cd gs.trade
touch README.md
git add README.md
git commit -m "add README"
git push -u origin master

Existing folder or Git repository

cd existing_folder
git init
git remote add origin https://gitlab.com/user/gs.trade.git
git add .
git commit
git push -u origin master

Dapper

https://samsaffron.com/archive/2011/03/30/How+I+learned+to+stop+worrying+and+write+my+own+ORM

https://habrahabr.ru/post/116862/

https://code.google.com/archive/p/dapper-dot-net/

https://github.com/StackExchange/dapper-dot-net

http://blog.byndyu.ru/2013/03/dapper-queryobject-orm.html

http://www.infoworld.com/article/3025784/application-development/how-to-work-with-dapper-in-c.html

http://www.c-sharpcorner.com/UploadFile/e4e3f7/dapper-king-of-micro-orm-C-Sharp-net/

http://www.codeproject.com/Articles/212274/A-Look-at-Dapper-NET

https://msdn.microsoft.com/en-us/magazine/mt703432.aspx

http://venkatbaggu.com/use-dapper-net-orm-in-asp-net-mvc/

https://en.wikipedia.org/wiki/Dapper_ORM

http://stackoverflow.com/questions/5957774/performing-inserts-and-updates-with-dapper

Owin, Katana

http://owin.org/

https://habrahabr.ru/post/202018/

http://www.asp.net/aspnet/overview/owin-and-katana/getting-started-with-owin-and-katana

http://metanit.com/sharp/mvc5/11.1.php

http://odetocode.com/blogs/scott/archive/2014/02/10/building-a-simple-file-server-with-owin-and-katana.aspx

AutoMap DataReader

http://stackoverflow.com/questions/25681102/using-automapper-with-data-reader

http://stackoverflow.com/questions/2429194/automapper-mapping-ienumerable-to-datareader-issue

http://stackoverflow.com/questions/1464883/how-can-i-easily-convert-datareader-to-listt

http://blog.zwezdin.com/ru/275

http://metanit.com/sharp/mvc5/23.4.php

https://dotnetcademy.net/Learn/2/Pages/1

AutoMapper

http://cpratt.co/

AutoMapper

https://github.com/AutoMapper/AutoMapper/wiki/Getting-started

http://cpratt.co/using-automapper-getting-started/

http://cpratt.co/using-automapper-creating-mappings/

http://cpratt.co/using-automapper-mapping-instances/

http://cpratt.co/

Repository

http://cpratt.co/truly-generic-repository-2/

http://cpratt.co/truly-generic-repository/

ASP.NET not Register

http://stackoverflow.com/questions/6846544/how-to-fix-handler-pagehandlerfactory-integrated-has-a-bad-module-managedpip

RDP Clients for Android

http://tucha.ua/blog/obzor-i-testirovanie-besplatny-h-rdp-klientov-dlya-android/

IoC, DI

https://habrahabr.ru/post/62830/

https://habrahabr.ru/post/63280/

Tabs

http://www.citilink.ru/catalog/mobile/tablet_pc/323942/

http://www.citilink.ru/catalog/mobile/tablet_pc/321921/

http://www.citilink.ru/catalog/mobile/tablet_pc/308118/

http://www.citilink.ru/catalog/mobile/tablet_pc/306837/

http://xdrv.ru/articles/tablets/312/full

http://www.samsung.com/ru/consumer/mobile-devices/tablets/galaxy-tab-a/SM-T355NZKASER

http://xdrv.ru/articles/tablets/312/1

http://www.ferra.ru/ru/notebooks/review/ASUS-ZenPad-8-Z380KL-review/#.Vs28ivmLSig

http://www.ferra.ru/ru/notebooks/news/2015/03/17/Samsung-Galaxy-Tab-A/#.Vs2_TfmLSig

https://www.youtube.com/watch?v=v150LdCFBR8

https://www.youtube.com/watch?v=U4e7cqfiqb4

Courses Learning

https://www.coursera.org/

http://tomato-timer.com/

https://www.edx.org/course/introduction-computer-science-mitx-6-00-1x-6

EntityFranework Connection Management

https://msdn.microsoft.com/en-us/library/bb896325(v=vs.100).aspx

https://msdn.microsoft.com/en-us/data/dn456849.aspx

http://stackoverflow.com/questions/5285877/closing-connections-explicitly-in-entity-framework

http://stackoverflow.com/questions/19847248/entity-framework-v6-closes-connections-after-exception-without-using-statment

http://stackoverflow.com/questions/1282675/when-does-entity-framework-open-and-close-database-connections

Entityframework ConnectionString

http://www.cosairus.com/Blog/2015/3/10/programmatic-connection-strings-in-entity-framework-6

Web.config and App.config

App.config:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Users;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="FortsTicks01" connectionString="Data Source=.\MSSQL12;Initial Catalog=FortsTicks01;Integrated Security=True" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
</configuration>

Web.config:

<configuration>
  <configSections>    
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Users;Integrated Security=True" providerName="System.Data.SqlClient" />
    <add name="TimeSeries01" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=TimeSeries01;Integrated Security=True" providerName="System.Data.SqlClient" />
  </connectionStrings>

 <appSettings>

Dispose

https://msdn.microsoft.com/ru-ru/library/fs2xkftw(v=vs.110).aspx?cs-save-lang=1&cs-lang=csharp#code-snippet-2

double compare

http://stackoverflow.com/questions/356807/java-double-comparison-epsilon

http://stackoverflow.com/questions/4787125/evaluate-if-two-doubles-are-equal-based-on-a-given-precision-not-within-a-certa

https://msdn.microsoft.com/ru-ru/library/9cczk1sc(v=vs.110).aspx

https://msdn.microsoft.com/ru-ru/library/ya2zha7s(v=vs.110).aspx

Data Annotations

https://msdn.microsoft.com/en-us/data/jj591583.aspx

https://msdn.microsoft.com/ru-ru/data/gg193958.aspx

http://www.entityframeworktutorial.net/code-first/dataannotation-in-code-first.aspx

SQL, Data Types

https://msdn.microsoft.com/en-us/library/ms187752.aspx

SQL DateTime Types

https://msdn.microsoft.com/en-us/library/ff848733.aspx

https://msdn.microsoft.com/en-us/library/ms187819.aspx

https://msdn.microsoft.com/en-us/library/bb677335.aspx

https://msdn.microsoft.com/en-us/library/bb630289.aspx

https://msdn.microsoft.com/en-us/library/ms182418.aspx

https://msdn.microsoft.com/en-us/library/bb630352.aspx

FTP C#

https://msdn.microsoft.com/ru-ru/library/system.net.ftpwebrequest(v=vs.110).aspx

http://www.codeproject.com/Tips/443588/Simple-Csharp-FTP-Class

BulkInsert EnetityFrameWork

https://efbulkinsert.codeplex.com/

ArrayOfString to Byte Array

http://stackoverflow.com/questions/472906/converting-a-string-to-byte-array-without-using-an-encoding-byte-by-byte

http://stackoverflow.com/questions/14669820/how-to-convert-a-string-array-to-a-byte-array-java

Compress/Decompress

http://www.dotnetperls.com/compress

http://www.dotnetperls.com/decompress

 private byte[] Serialize(IEnumerable<Dto.Bar> bs)
        {
            BinaryFormatter bf = new BinaryFormatter();
            byte[] bytes;
            MemoryStream ms = new MemoryStream();

            var lst = bs.Select(b => b.ToStr()).ToList();

            bf.Serialize(ms, lst);
            ms.Seek(0, 0);
            
            var bts = ms.ToArray();

            return bts;
        }

 private IEnumerable<IBarSimple> DeSerialize(byte[] bytes)
        {
            BinaryFormatter bf = new BinaryFormatter();
            MemoryStream ms = new MemoryStream();
            ms.Write(bytes, 0, bytes.Length);
            ms.Seek(0, 0);

            var ss = (List<string>)bf.Deserialize(ms);
            var bs = ss.Select(s => s.ToBarDto()).ToList();
            return bs;

        }

 private byte[] Compress(byte[] bytes)
        {
            using (MemoryStream ms = new MemoryStream())
            {
                using (GZipStream gzip = new GZipStream(ms, CompressionMode.Compress, true))
                {
                    gzip.Write(bytes, 0, bytes.Length);
                }
                return ms.ToArray();
            }

        }

 private byte[] DeCompress(byte[] bytes)
        {
            using (GZipStream gzstream = new GZipStream(new MemoryStream(bytes), CompressionMode.Decompress))
            {
                const int size = 4096;
                byte[] buffer = new byte[size];
                using (MemoryStream mstr = new MemoryStream())
                {
                    int count = 0;
                    do
                    {
                        count = gzstream.Read(buffer, 0, size);
                        if (count > 0)
                        {
                            mstr.Write(buffer, 0, count);
                        }
                    } while (count > 0);
                    return mstr.ToArray();
                }
            }

        }