public SettingsController(ISettings settings)
{
// example of saving
_settings.General.SiteName = "دات نت تیپس";
_settings.Seo.HomeMetaTitle = ".Net Tips";
_settings.Seo.HomeMetaKeywords = "َAsp.net MVC,Entity Framework,Reflection";
_settings.Seo.HomeMetaDescription = "ذخیره تنظیمات برنامه";
_settings.Save();
} namespace DynamicSettingAPI.Models
{
public interface IUnitOfWork
{
DbSet<Setting> Settings { get; set; }
int SaveChanges();
}
}
public class ApplicationDbContext : IdentityDbContext<ApplicationUser>,IUnitOfWork
{
public DbSet<Setting> Settings { get; set; }
public ApplicationDbContext()
: base("DefaultConnection", throwIfV1Schema: false)
{
}
public static ApplicationDbContext Create()
{
return new ApplicationDbContext();
}
}
namespace DynamicSettingAPI.Models
{
public class Setting
{
public string Name { get; set; }
public string Type { get; set; }
public string Value { get; set; }
}
} protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Setting>()
.HasKey(x => new { x.Name, x.Type });
modelBuilder.Entity<Setting>()
.Property(x => x.Value)
.IsOptional();
base.OnModelCreating(modelBuilder);
} 
namespace DynamicSettingAPI.Service
{
public abstract class SettingsBase
{
//1
private readonly string _name;
private readonly PropertyInfo[] _properties;
protected SettingsBase()
{
//2
var type = GetType();
_name = type.Name;
_properties = type.GetProperties();
}
public virtual void Load(IUnitOfWork unitOfWork)
{
//3 get setting for this type name
var settings = unitOfWork.Settings.Where(w => w.Type == _name).ToList();
foreach (var propertyInfo in _properties)
{
//get the setting from setting list
var setting = settings.SingleOrDefault(s => s.Name == propertyInfo.Name);
if (setting != null)
{
//4 set
propertyInfo.SetValue(this, Convert.ChangeType(setting.Value, propertyInfo.PropertyType));
}
}
}
public virtual void Save(IUnitOfWork unitOfWork)
{
//5 get all setting for this type name
var settings = unitOfWork.Settings.Where(w => w.Type == _name).ToList();
foreach (var propertyInfo in _properties)
{
var propertyValue = propertyInfo.GetValue(this, null);
var value = (propertyValue == null) ? null : propertyValue.ToString();
var setting = settings.SingleOrDefault(s => s.Name == propertyInfo.Name);
if (setting != null)
{
// 6 update existing value
setting.Value = value;
}
else
{
// 7 create new setting
var newSetting = new Setting()
{
Name = propertyInfo.Name,
Type = _name,
Value = value,
};
unitOfWork.Settings.Add(newSetting);
}
}
}
}
} propertyInfo.SetValue(this, Convert.ChangeType(setting.Value, propertyInfo.PropertyType));
public class GeneralSettings : SettingsBase
{
public string SiteName { get; set; }
public string AdminEmail { get; set; }
public bool RegisterUsersEnabled { get; set; }
}
public class GeneralSettings : SettingsBase
{
public string SiteName { get; set; }
public string AdminEmail { get; set; }
} public interface ISettings
{
GeneralSettings General { get; }
SeoSettings Seo { get; }
void Save();
}
public class Settings : ISettings
{
// 1
private readonly Lazy<GeneralSettings> _generalSettings;
// 2
public GeneralSettings General { get { return _generalSettings.Value; } }
private readonly Lazy<SeoSettings> _seoSettings;
public SeoSettings Seo { get { return _seoSettings.Value; } }
private readonly IUnitOfWork _unitOfWork;
public Settings(IUnitOfWork unitOfWork)
{
_unitOfWork = unitOfWork;
// 3
_generalSettings = new Lazy<GeneralSettings>(CreateSettings<GeneralSettings>);
_seoSettings = new Lazy<SeoSettings>(CreateSettings<SeoSettings>);
}
public void Save()
{
// only save changes to settings that have been loaded
if (_generalSettings.IsValueCreated)
_generalSettings.Value.Save(_unitOfWork);
if (_seoSettings.IsValueCreated)
_seoSettings.Value.Save(_unitOfWork);
_unitOfWork.SaveChanges();
}
// 4
private T CreateSettings<T>() where T : SettingsBase, new()
{
var settings = new T();
settings.Load(_unitOfWork);
return settings;
}
} private readonly ICache _cache;
public Settings(IUnitOfWork unitOfWork, ICache cache)
{
// ARGUMENT CHECKING SKIPPED FOR BREVITY
_unitOfWork = unitOfWork;
_cache = cache;
_generalSettings = new Lazy<GeneralSettings>(CreateSettingsWithCache<GeneralSettings>);
_seoSettings = new Lazy<SeoSettings>(CreateSettingsWithCache<SeoSettings>);
}
private T CreateSettingsWithCache<T>() where T : SettingsBase, new()
{
// this is where you would implement loading from ICache
throw new NotImplementedException();
} public ActionResult Index()
{
using (var uow = new ApplicationDbContext())
{
var _settings = new Settings(uow);
_settings.General.SiteName = "دات نت تیپس";
_settings.General.AdminEmail = "admin@gmail.com";
_settings.General.RegisterUsersEnabled = true;
_settings.Seo.HomeMetaTitle = ".Net Tips";
_settings.Seo.MetaKeywords = "Asp.net MVC,Entity Framework,Reflection";
_settings.Seo.HomeMetaDescription = "ذخیره تنظیمات برنامه";
var settings2 = new Settings(uow);
var output = string.Format("SiteName: {0} HomeMetaDescription: {1} MetaKeywords: {2} MetaTitle: {3} RegisterEnable: {4}",
settings2.General.SiteName,
settings2.Seo.HomeMetaDescription,
settings2.Seo.MetaKeywords,
settings2.Seo.HomeMetaTitle,
settings2.General.RegisterUsersEnabled.ToString()
);
return Content(output);
}
} 
public void Configure(ILoggerFactory loggerFactory, IApplicationBuilder app, IHostingEnvironment env)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug(); {
"Logging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Debug",
"System": "Information",
"Microsoft": "Information"
}
}
} {
"dependencies": {
//same as before
"Microsoft.Extensions.Logging": "1.0.0",
"Microsoft.Extensions.Logging.Console": "1.0.0",
"Microsoft.Extensions.Logging.Debug": "1.0.0"
}
} 
[Route("[controller]")]
public class AboutController : Controller
{
private readonly ILogger<AboutController> _logger;
public AboutController(ILogger<AboutController> logger)
{
_logger = logger;
}
[Route("")]
public ActionResult Hello()
{
_logger.LogInformation("Running Hello");
return Content("Hello from DNT!");
} 
loggerFactory.AddDebug(minLevel: LogLevel.Information);
public enum LogLevel
{
Trace,
Debug,
Information,
Warning,
Error,
Critical,
None,
} We’ll integrate Fixie with AutoMapper, Respawn, StructureMap, FluentValidation, Mediatr, AutoFixture, and Entity Framework to see how it all fits together for a realistic testing experience.
This is a practical guide for implementing the Domain Driven Design (DDD). While the implementation details rely on the ABP Framework infrastructure, core concepts, principles and patterns are applicable in any kind of solution, even if it is not a .NET solution.
CREATE TABLE xmlInvoice ( invoiceId INT IDENTITY PRIMARY KEY, invoice XML )
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1000" dept="hardware">
<CustomerName>Vahid</CustomerName>
<LineItems>
<LineItem><Description>Gear</Description><Price>9.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1002" dept="garden">
<CustomerName>Mehdi</CustomerName>
<LineItems>
<LineItem><Description>Shovel</Description><Price>19.2</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1003" dept="garden">
<CustomerName>Mohsen</CustomerName>
<LineItems>
<LineItem><Description>Trellis</Description><Price>8.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1004" dept="hardware">
<CustomerName>Hamid</CustomerName>
<LineItems>
<LineItem><Description>Pen</Description><Price>1.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1005" dept="IT">
<CustomerName>Ali</CustomerName>
<LineItems>
<LineItem><Description>Book</Description><Price>3.2</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1006" dept="hardware">
<CustomerName>Reza</CustomerName>
<LineItems>
<LineItem><Description>M.Board</Description><Price>19.5</Price></LineItem>
</LineItems>
</Invoice>
') CREATE XML SCHEMA COLLECTION invoice_xsd AS
' <xs:schema attributeFormDefault="unqualified"
elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Invoice">
<xs:complexType>
<xs:sequence>
<xs:element name="CustomerName" type="xs:string" />
<xs:element name="LineItems">
<xs:complexType>
<xs:sequence>
<xs:element name="LineItem">
<xs:complexType>
<xs:sequence>
<xs:element name="Description" type="xs:string" />
<xs:element name="Price" type="xs:decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="InvoiceId" type="xs:unsignedShort" use="required" />
<xs:attribute name="dept" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
</xs:schema>'
Go
CREATE TABLE xmlInvoice2
(
invoiceId INT IDENTITY PRIMARY KEY,
invoice XML(document invoice_xsd)
)
Go UPDATE STATISTICS xmlInvoice DBCC FREEPROCCACHE
-- query 1
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[@InvoiceId = "1003"]') = 1
-- query 2
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/@InvoiceId[. = "1003"]') = 1
-- query 3
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[1]/@InvoiceId[. = "1003"]') = 1
-- query 4
SELECT * FROM xmlInvoice
WHERE invoice.exist('(/Invoice/@InvoiceId)[1][. = "1003"]') = 1
-- query 5
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[CustomerName = "Vahid"]') = 1
-- query 6
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/CustomerName [.= "Vahid"]') = 1
-- query 7
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/LineItems/LineItem[Description = "Trellis"]') = 1
-- query 8
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/LineItems/LineItem/Description [.= "Trellis"]') = 1
-- query 9
SELECT * FROM xmlInvoice
WHERE invoice.exist('
for $x in /Invoice/@InvoiceId
where $x = 1003
return $x
') = 1
-- query 10
SELECT * FROM xmlInvoice
WHERE invoice.value('(/Invoice/@InvoiceId)[1]', 'VARCHAR(10)') = '1003'
-- یکبار هم با جدول شماره 2 که اسکیما دارد تمام این موارد تکرار شود
UPDATE STATISTICS xmlInvoice
DBCC FREEPROCCACHE
GO 
For many years now I’ve advocated not using the repository pattern on top of an ORM such as Entity Framework. There are many reasons why that I’ll try and cover throughout this post based on ways that I’ve seen it implemented. Meaning, this post is talking about poorly implemented approaches or pitfalls that I’ve seen.
