Skip to content

Instantly share code, notes, and snippets.

View erdemser's full-sized avatar

Erdem Serdaroğlu erdemser

View GitHub Profile
@erdemser
erdemser / PagedResult_Ex.cs
Created January 7, 2021 06:21
Paging in Entity Framework Core
public abstract class PagedResultBase
{
public int CurrentPage { get; set; }
public int PageCount { get; set; }
public int PageSize { get; set; }
public int RowCount { get; set; }
public int FirstRowOnPage
{
@erdemser
erdemser / ADHelper.cs
Created January 30, 2020 12:49
Active Directory Helper
static class ADHelper
{
public static bool ValidateUser(string domainName, string username, string password)
{
Domain domain = GetDomain(domainName);
try
{
//Log.Information("AD: Validating {UserName} in domain {DomainName}", username, domain.Name);
using (PrincipalContext pc = new PrincipalContext(ContextType.Domain, domain.Name))
@erdemser
erdemser / Singleton.cs
Created January 30, 2020 12:40 — forked from sebastienlachance/Singleton.cs
C# - Thread Safe Singleton Pattern - John Skeet
// Source: https://codereview.stackexchange.com/questions/79/implementing-a-singleton-pattern-in-c
public sealed class Singleton
{
// Thread safe Singleton with fully lazy instantiation á la Jon Skeet:
// http://csharpindepth.com/Articles/General/Singleton.aspx
Singleton()
{
}
public static Singleton Instance
@erdemser
erdemser / T-SQL Fetch Döngüsü.sql
Created January 3, 2020 06:35
T-SQL Fetch Döngüsü
--Değişken tanımı
DECLARE @PeopleId uniqueidentifier
--Döngü yapılacak tablo
DECLARE DONGU CURSOR FOR
SELECT Id FROM People
OPEN DONGU
FETCH NEXT FROM DONGU INTO @PeopleId
@erdemser
erdemser / T-SQL Mükerrer Kayıtları Listeleme.sql
Created January 3, 2020 06:34
T-SQL Mükerrer Kayıtları Listeleme
Select KOLONADI, Count(KOLONADI) From TABLOADI Group By KOLONADI Having Count (KOLONADI) > 1
@erdemser
erdemser / Db_Boyutu.sql
Last active January 3, 2020 06:34
Database boyutunu öğrenme
SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name,
(size * 8) / 1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'DbAdı'
@erdemser
erdemser / css-media-queries-cheat-sheet.css
Created January 3, 2020 06:16 — forked from bartholomej/css-media-queries-cheat-sheet.css
CSS Media Query Cheat Sheet (with Foundation)
/*------------------------------------------
Responsive Grid Media Queries - 1280, 1024, 768, 480
1280-1024 - desktop (default grid)
1024-768 - tablet landscape
768-480 - tablet
480-less - phone landscape & smaller
--------------------------------------------*/
@media all and (min-width: 1024px) and (max-width: 1280px) { }
@media all and (min-width: 768px) and (max-width: 1024px) { }
@erdemser
erdemser / Entity Framework Migration.md
Last active January 3, 2020 06:29
Entity Framework Migration

Entity Framework

Update-Database -Script -SourceMigration: MigrationAdı

Entity Framework Core

Script-Migration -From -To -Context ContextAdı