[OutputCache(Location = OutputCacheLocation.None, NoStore = true)]
declare const name: never;
string, int?, byte[]
int, decimal, bool, DateTime
[Required]
public string Url { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Blog>()
.Property(b => b.Url)
.IsRequired();
} public string FirstName { get; set; } [StringLength(450)]
public string FirstName { get; set; }
[MaxLength(450)]
public string LastName { get; set; }
[MaxLength]
public string Address { get; set; } modelBuilder.Entity<Person>() .Property(x => x.Address) .HasMaxLength(450);
modelBuilder.Entity<Person>()
.Property(x => x.Address)
.HasColumnType("nvarchar(max)"); [Column(TypeName = "varchar")]
[MaxLength]
public string Address { get; set; }
Data type 'varchar' is not supported in this form. Either specify the length explicitly in the type name, for example as 'varchar(16)', or remove the data type and use APIs such as HasMaxLength to allow EF choose the data type.
[Column(TypeName = "varchar(max)")]
public class Person
{
public int Id { set; get; }
public DateTime? DateAdded { set; get; }
public DateTime? DateUpdated { set; get; }
[StringLength(450)]
public string FirstName { get; set; }
[MaxLength(450)]
public string LastName { get; set; }
//[Column(TypeName = "varchar")]
[MaxLength]
public string Address { get; set; }
//bit
public bool IsActive { get; set; }
//tiny Int
public byte Age { get; set; }
//small Int
public short Short { get; set; }
//int
public int Int32 { get; set; }
//Big int
public long Long { get; set; }
} 
CREATE TABLE [dbo].[Persons]( [DateAdded] [datetime2](7) NULL, [DateUpdated] [datetime2](7) NULL,
[ConcurrencyCheck]
public string Name { set; get; } modelBuilder.Entity<Person>()
.Property(p => p.Name)
.IsConcurrencyToken(); [Timestamp]
public byte[] Timestamp { get; set; } modelBuilder.Entity<Blog>() .Property(p => p.Timestamp) .ValueGeneratedOnAddOrUpdate() .IsConcurrencyToken();
<system.webServer>
<security>
<authentication>
<anonymousAuthentication enabled="true" />
<windowsAuthentication enabled="true" />
</authentication>
</security>
</system.webServer> {
"iisSettings": {
"windowsAuthentication": true,
"anonymousAuthentication": true,
"iisExpress": {
"applicationUrl": "http://localhost:3381/",
"sslPort": 0
}
}
} <?xml version="1.0" encoding="utf-8"?>
<configuration>
<system.webServer>
<handlers>
<add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModule" resourceType="Unspecified"/>
</handlers>
<aspNetCore processPath="%LAUNCHER_PATH%" arguments="%LAUNCHER_ARGS%"
stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout"
forwardWindowsAuthToken="true"/>
</system.webServer>
</configuration> namespace ASPNETCore2WindowsAuthentication
{
public class Program
{
public static void Main(string[] args)
{
var host = new WebHostBuilder()
.UseKestrel()
.UseContentRoot(Directory.GetCurrentDirectory())
.UseStartup<Startup>()
.UseHttpSys(options => // Just for local tests without IIS, Or self-hosted scenarios on Windows ...
{
options.Authentication.Schemes =
AuthenticationSchemes.Negotiate | AuthenticationSchemes.NTLM;
options.Authentication.AllowAnonymous = true;
//options.UrlPrefixes.Add("http://+:80/");
})
.Build();
host.Run();
}
}
} namespace ASPNETCore2WindowsAuthentication
{
public class Program
{
public static void Main(string[] args)
{
var host = new WebHostBuilder()
.UseKestrel()
.UseContentRoot(Directory.GetCurrentDirectory())
.UseIISIntegration()
.UseDefaultServiceProvider((context, options) =>
{
options.ValidateScopes = context.HostingEnvironment.IsDevelopment();
})
.UseStartup<Startup>()
.Build();
host.Run();
}
}
} public void ConfigureServices(IServiceCollection services)
{
services.AddMvc();
services.Configure<IISOptions>(options =>
{
// Sets the HttpContext.User
// Note: Windows Authentication must also be enabled in IIS for this to work.
options.AutomaticAuthentication = true;
options.ForwardClientCertificate = true;
});
services.AddAuthentication(options =>
{
// for both windows and anonymous authentication
options.DefaultChallengeScheme = IISDefaults.AuthenticationScheme;
});
} private string authInfo()
{
var claims = new StringBuilder();
if (User.Identity is ClaimsIdentity claimsIdentity)
{
claims.Append("Your claims: \n");
foreach (var claim in claimsIdentity.Claims)
{
claims.Append(claim.Type + ", ");
claims.Append(claim.Value + "\n");
}
}
return $"IsAuthenticated: {User.Identity.IsAuthenticated}; Identity.Name: {User.Identity.Name}; WindowsPrincipal: {(User is WindowsPrincipal)}\n{claims}";
} namespace ASPNETCore2WindowsAuthentication.Controllers
{
public class HomeController : Controller
{
public IActionResult Index()
{
return View();
}
[Authorize]
public IActionResult Windows()
{
return Content(authInfo());
}
private string authInfo()
{
var claims = new StringBuilder();
if (User.Identity is ClaimsIdentity claimsIdentity)
{
claims.Append("Your claims: \n");
foreach (var claim in claimsIdentity.Claims)
{
claims.Append(claim.Type + ", ");
claims.Append(claim.Value + "\n");
}
}
return $"IsAuthenticated: {User.Identity.IsAuthenticated}; Identity.Name: {User.Identity.Name}; WindowsPrincipal: {(User is WindowsPrincipal)}\n{claims}";
}
[AllowAnonymous]
public IActionResult Anonymous()
{
return Content(authInfo());
}
[Authorize(Roles = "Domain Admins")]
public IActionResult ForAdmins()
{
return Content(authInfo());
}
[Authorize(Roles = "Domain Users")]
public IActionResult ForUsers()
{
return Content(authInfo());
}
}
} dotnet publish
[Authorize(Roles = @"<domain>\<group>")] //or [Authorize(Roles = @"<domain>\<group1>,<domain>\<group2>")]
services.AddAuthorization(options =>
{
options.AddPolicy("RequireWindowsGroupMembership", policy =>
{
policy.RequireAuthenticatedUser();
policy.RequireRole(@"<domain>\<group>"));
}
}); [Authorize(Policy = "RequireWindowsGroupMembership")]
[HttpGet("[action]")]
public IActionResult SomeValue()
{
if (!User.IsInRole(@"Domain\Group")) return StatusCode(403);
return Ok("Some Value");
} public class ApplicationClaimsTransformation : IClaimsTransformation
{
private readonly ILogger<ApplicationClaimsTransformation> _logger;
public ApplicationClaimsTransformation(ILogger<ApplicationClaimsTransformation> logger)
{
_logger = logger;
}
public Task<ClaimsPrincipal> TransformAsync(ClaimsPrincipal principal)
{
if (!(principal.Identity is ClaimsIdentity identity))
{
return Task.FromResult(principal);
}
var claims = addExistingUserClaims(identity);
identity.AddClaims(claims);
return Task.FromResult(principal);
}
private IEnumerable<Claim> addExistingUserClaims(IIdentity identity)
{
var claims = new List<Claim>();
var user = @"VahidPC\Vahid";
if (identity.Name != user)
{
_logger.LogError($"Couldn't find {identity.Name}.");
return claims;
}
claims.Add(new Claim(ClaimTypes.GivenName, user));
return claims;
}
} services.AddScoped<IClaimsTransformation, ApplicationClaimsTransformation>();
services.AddAuthentication(options =>
{
// for both windows and anonymous authentication
options.DefaultChallengeScheme = IISDefaults.AuthenticationScheme;
}); 
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier); var userName = User.FindFirstValue(ClaimTypes.Name); var userName = User.FindFirstValue(ClaimTypes.GivenName);
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace MvcApplication1.Controllers
{
public class HomeController : Controller
{
//
// GET: /Home/
public ActionResult Index()
{
return View();
}
}
}
public abstract class ControllerBase : IController
public abstract class Controller : ControllerBase
The view 'Index' or its master was not found or no view engine supports the searched locations. The following locations were searched:
~/Views/Home/Index.aspx
~/Views/Home/Index.ascx
~/Views/Shared/Index.aspx
~/Views/Shared/Index.ascx
~/Views/Home/Index.cshtml
~/Views/Home/Index.vbhtml
~/Views/Shared/Index.cshtml
~/Views/Shared/Index.vbhtml
@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Home", action = "Index", id = UrlParameter.Optional } // Parameter defaults
);
}
http://hostname/home/about
http://localhost/
http://localhost/home
http://localhost/home/about
http://localhost/process/list
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
"Process", // Route name
"Process/{action}/{id}", // URL with parameters
new { controller = "Process", action = "List", id = UrlParameter.Optional } // Parameter defaults
);
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Home", action = "Index", id = UrlParameter.Optional } // Parameter defaults
);
}
namespace EntitySample1.DomainClasses
{
public class Person
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public DateTime BirthDate { get; set; }
public virtual PersonInfo PersonInfo { get; set; }
public virtual ICollection<PhoneNumber> PhoneNumbers { get; set; }
public virtual ICollection<Address> Addresses { get; set; }
}
}namespace EntitySample1.DomainClasses
{
public class PersonInfo
{
public int Id { get; set; }
public string Note { get; set; }
public string Major { get; set; }
}
}namespace EntitySample1.DomainClasses
{
public enum PhoneType
{
Home,
Mobile,
Work
}
public class PhoneNumber
{
public int Id { get; set; }
public string Number { get; set; }
public PhoneType PhoneType { get; set; }
public virtual Person Person { get; set; }
}
}namespace EntitySample1.DomainClasses
{
public class Address
{
public int Id { get; set; }
public string City { get; set; }
public string Street { get; set; }
public virtual ICollection<Person> Persons { get; set; }
}
}namespace EntitySample1.DataLayer
{
public class PhoneBookDbContext : DbContext
{
public DbSet<Person> Persons { get; set; }
public DbSet<PhoneNumber> PhoneNumbers { get; set; }
public DbSet<Address> Addresses { get; set; }
}
} private static void ManualDetectChanges()
{
using (var context = new PhoneBookDbContext())
{
context.Configuration.AutoDetectChangesEnabled = false; // turn off Auto Detect Changes
var p1 = context.Persons.Single(p => p.FirstName == "joe");
p1.LastName = "Brown";
Console.WriteLine("Before DetectChanges: {0}", context.Entry(p1).State);
context.ChangeTracker.DetectChanges(); // call detect changes manually
Console.WriteLine("After DetectChanges: {0}", context.Entry(p1).State);
}
}Before DetectChanges: Unchanged After DetectChanges: Modified
private static void AddMultiplePerson()
{
using (var context = new PhoneBookDbContext())
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Persons.Add(new Person
{
FirstName = "brad",
LastName = "watson",
BirthDate = new DateTime(1990, 6, 8)
});
context.Persons.Add(new Person
{
FirstName = "david",
LastName = "brown",
BirthDate = new DateTime(1990, 6, 8)
});
context.Persons.Add(new Person
{
FirstName = "will",
LastName = "smith",
BirthDate = new DateTime(1990, 6, 8)
});
context.SaveChanges();
}
} private static void DetectRelationshipChanges()
{
using (var context = new PhoneBookDbContext())
{
var phone1 = context.PhoneNumbers.Single(x => x.Number == "09351234567");
var person1 = context.Persons.Single(x => x.FirstName == "will");
person1.PhoneNumbers.Add(phone1);
Console.WriteLine("Before DetectChanges: {0}", phone1.Person.FirstName);
context.ChangeTracker.DetectChanges(); // ralationships fix-up
Console.WriteLine("After DetectChanges: {0}", phone1.Person.FirstName);
}
}Before DetectChanges: david After DetectChanges: will
تا قبل از فراخوانی تشخیص تغییرات(DetectChanegs)، هنوز phone1 منتسب به شخص قدیمی(david) بوده، ولی پس از فراخوانی DetectChanges ، اصلاح رابطه رخ داده و همه چیز با یکدیگر منطبق می‌شوند.
فعال سازی و کار با پروکسی‌های ردیابی تغییر
اگر پروفایلر کارایی شما، فراخوانی‌های بیش از اندازه DetectChnages را به عنوان یک مشکل شناسایی کند، و یا شما ترجیح می‌دهید که اصلاح رابطه به صورت بلادرنگ صورت گیرد ، ردیابی تغییر پروکسی‌های پویا، به عنوان گزینه ای دیگر مطرح می‌شود.فقط با چند تغییر کوچک در کلاس‌های POCO، EF قادر به ساخت پروکسی‌های پویا خواهد بود.پروکسی‌های ردیابی تغییر به EF اجازه ردیابی تغییرات در همان لحظه ای که ما تغییری در اشیای خود می‌دهیم را می‌دهند و همچنین امکان انجام اصلاح رابطه را در هر زمانی که تغییرات روابط را تشخیص دهد، دارد.
برای اینکه پروکسی ردیابی تغییر بتواند ساخته شود، باید قوانین زیر رعایت شود:
• کلاس باید public باشد و seald نباشد.
• همه‌ی خواص(properties) باید virtual تعریف شوند.
• همه‌ی خواص باید getter و setter با سطح دسترسی public داشته باشند.
• همه‌ی خواص راهبری مجموعه ای باید نوعشان، از نوع ICollection<T> تعریف شوند.
کلاس Person مثال خود را به گونه ای بازنویسی کرده ایم که تمام قوانین فوق را پیاده سازی کرده باشد.
نکته: توجه داشته باشید که ما دیگر در داخل سازنده کلاس ،کدی نمی‌نویسیم و منطقی که باعث نمونه سازی اولیه خواص راهبری می‌شدند، را پیاده سازی نمی‌کنیم. این پروکسی ردیاب تغییر، همه‌ی خواص راهبری مجموعه ای را تحریف کرده و ار نوع مجموعه ای مخصوص خود(EntityCollection<T>) استفاده می‌کند. این نوع مجموعه ای، هر تغییری که در این مجموعه صورت می‌گیرد را زیر نظر گرفته و به ردیاب تغییر گزارش می‌دهد. اگر تلاش کنید تا نوع دیگری مانند List<T> که معمولا در سازنده کلاس از آن استفاده می‌کردیم را به آن انتساب دهیم، پروکسی، استثنایی را پرتاب می‌کند.
namespace EntitySample1.DomainClasses
{
public class Person
{
public virtual int Id { get; set; }
public virtual string FirstName { get; set; }
public virtual string LastName { get; set; }
public virtual DateTime BirthDate { get; set; }
public virtual PersonInfo PersonInfo { get; set; }
public virtual ICollection<PhoneNumber> PhoneNumbers { get; set; }
public virtual ICollection<Address> Addresses { get; set; }
}
} private static void TestForChangeTrackingProxy()
{
using (var context = new PhoneBookDbContext())
{
var person = context.Persons.First();
var isProxy = person is IEntityWithChangeTracker;
Console.WriteLine("person is a proxy: {0}", isProxy);
}
}Before DetectChanges: Modified After DetectChanges: Modified
Before DetectChanges: will After DetectChanges: will
private static void CreateNewProxies()
{
using (var context = new PhoneBookDbContext())
{
var phoneNumber = new PhoneNumber { Number = "987" };
var davidPersonProxy = context.Persons.Create();
davidPersonProxy.FirstName = "david";
davidPersonProxy.PhoneNumbers.Add(phoneNumber);
Console.WriteLine(phoneNumber.Person.FirstName);
}
}var newStudent = context.Persons.Create<Student>();
private static void PrintPersonsWithoutChangeTracking()
{
using (var context = new PhoneBookDbContext())
{
var persons = context.Persons.AsNoTracking().ToList();
foreach (var person in persons)
{
Console.WriteLine(person.FirstName);
}
}
}var query = from p in context.Persons.AsNoTracking()
where p.FirstName == "joe"
select p;شما همچنین از AsNoTracking می‌توانید برای تبدیل یک کوئری LINQ موجود، به یک کوئری فاقد ردیابی استفاده کنید. این نکته را به یاد داشته باشید که فقط AsNoTracking بر روی کوئری، فرانخوانده شده است، بلکه متغیر query را با نتیجه‌ی حاصل از فراخوانی AsNoTracking بازنویسی(override) کرده است و این، از این جهت لازم است که AsNoTracking ،تغییری در کوئری ای که بر روی آن فراخوانده شده نمی‌دهد، بلکه یک کوئری جدید بر می‌گرداند.
var query = from p in context.Persons
where p.FirstName == "joe"
select p;
query = query.AsNoTracking(); 
dotnet new console
dotnet add package Inferno
log : Installing Inferno 1.4.0. warn : Package 'Inferno 1.4.0' was restored using '.NETFramework,Version=v4.6.1' instead of the project target framework '.NETCoreApp,Version=v2.0'. This package may not be fully compatible with your project. info : Package 'Inferno' is compatible with all the specified frameworks in project 'D:\UseNET452InNetCore2\UseNET452InNetCore2.csproj'. info : PackageReference for package 'Inferno' version '1.4.0' added to file 'D:\UseNET452InNetCore2\UseNET452InNetCore2.csproj'.
using System;
using SecurityDriven.Inferno;
namespace UseNET452InNetCore2
{
class Program
{
static CryptoRandom random = new CryptoRandom();
static void Main(string[] args)
{
Console.WriteLine($"rnd: {random.NextLong()}");
}
}
} >dotnet run warning NU1701: This package may not be fully compatible with your project. rnd: 8167886599578111106
/// <summary>
/// Represents the lable
/// </summary>
public class Tag
{
#region Ctor
/// <summary>
/// Create one instance of <see cref="Tag"/>
/// </summary>
public Tag()
{
Id = SequentialGuidGenerator.NewSequentialGuid();
}
#endregion
#region Properties
/// <summary>
/// sets or gets Tag's identifier
/// </summary>
public virtual Guid Id { get; set; }
/// <summary>
/// sets or gets Tag's name
/// </summary>
public virtual string Name { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// sets or gets Tag's posts
/// </summary>
public virtual ICollection<BlogPost> BlogPosts { get; set; }
#endregion
} /// <summary>
/// Represents the Post's Draft
/// </summary>
public class BlogDraft
{
#region Ctor
/// <summary>
/// create one instance of <see cref="BlogDraft"/>
/// </summary>
public BlogDraft()
{
Id = SequentialGuidGenerator.NewSequentialGuid();
}
#endregion
#region Properties
/// <summary>
/// gets or sets Id of post's draft
/// </summary>
public virtual Guid Id { get; set; }
/// <summary>
/// gets or sets body of post's draft
/// </summary>
public virtual string Body { get; set; }
/// <summary>
/// gets or set title of post's draft
/// </summary>
public virtual string Title { get; set; }
/// <summary>
/// gets or sets tags of post's draft that seperated using ','
/// </summary>
public virtual string TagNames { get; set; }
/// <summary>
/// gets or sets value indicating whether this draft is ready to publish
/// </summary>
public virtual bool IsReadyForPublish { get; set; }
/// <summary>
/// ges ro sets DateTime that this draft added
/// </summary>
public virtual DateTime CreatedOn { get; set; }
/// <summary>
/// gets or sets information of User-Agent
/// </summary>
public virtual string Agent { get; set; }
/// <summary>
/// gets or sets date that this draft publish as ready
/// </summary>
public virtual DateTime? ReadyForPublishOn { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// gets or sets Id of user that he is owner of this draft
/// </summary>
public virtual long OwnerId { get; set; }
/// <summary>
/// gets or sets user that he is owner of this draft
/// </summary>
public virtual User Owner { get; set; }
#endregion
} /// <summary>
/// Section of Rating
/// </summary>
public enum RatingSection
{
News,
Announcement,
ForumTopic,
BlogComment,
NewsComment,
PollComment,
AnnouncementComment,
ForumPost,
...
}
/// <summary>
/// Represents Rating Record regard by section type for Rating System
/// </summary>
public class UserRating
{
#region Ctor
/// <summary>
/// Create one instance of <see cref="UserRating"/>
/// </summary>
public UserRating()
{
Id = SequentialGuidGenerator.NewSequentialGuid();
}
#endregion
#region Properties
/// <summary>
/// gets or sets Id of Rating Record
/// </summary>
public virtual Guid Id { get; set; }
/// <summary>
/// gets or sets value of rate
/// </summary>
public virtual double RatingValue { get; set; }
/// <summary>
/// gets or sets Section's Id
/// </summary>
public virtual long SectionId { get; set; }
/// <summary>
/// gets or sets Section
/// </summary>
public virtual RatingSection Section { get; set; }
#endregion
#region Navigation Properties
/// <summary>
/// gets or sets user that rate one section
/// </summary>
public virtual User Rater { get; set; }
/// <summary>
/// gets or sets Rater Id that rate one section
/// </summary>
public virtual long RaterId { get; set; }
#endregion
} /// <summary>
/// Represent the rating as ComplexType
/// </summary>
[ComplexType]
public class Rating
{
/// <summary>
/// sets or gets total of rating
/// </summary>
public virtual double? TotalRating { get; set; }
/// <summary>
/// sets or gets rater's count
/// </summary>
public virtual long? RatersCount { get; set; }
/// <summary>
/// sets or gets average of rating
/// </summary>
public virtual double? AverageRating { get; set; }
} /// <summary>
/// Represents a base class for every content in system
/// </summary>
public abstract class BaseContent
{
#region Properties
/// <summary>
/// get or set identifier of record
/// </summary>
public virtual long Id { get; set; }
/// <summary>
/// gets or sets date of publishing content
/// </summary>
public virtual DateTime PublishedOn { get; set; }
/// <summary>
/// gets or sets Last Update's Date
/// </summary>
public virtual DateTime ModifiedOn { get; set; }
/// <summary>
/// gets or sets the blog pot body
/// </summary>
public virtual string Body { get; set; }
/// <summary>
/// gets or sets the content title
/// </summary>
public virtual string Title { get; set; }
/// <summary>
/// gets or sets value indicating Custom Slug
/// </summary>
public virtual string SlugUrl { get; set; }
/// <summary>
/// gets or sets meta title for seo
/// </summary>
public virtual string MetaTitle { get; set; }
/// <summary>
/// gets or sets meta keywords for seo
/// </summary>
public virtual string MetaKeywords { get; set; }
/// <summary>
/// gets or sets meta description of the content
/// </summary>
public virtual string MetaDescription { get; set; }
/// <summary>
/// gets or sets
/// </summary>
public virtual string FocusKeyword { get; set; }
/// <summary>
/// gets or sets value indicating whether the content use CanonicalUrl
/// </summary>
public virtual bool UseCanonicalUrl { get; set; }
/// <summary>
/// gets or sets CanonicalUrl That the Post Point to it
/// </summary>
public virtual string CanonicalUrl { get; set; }
/// <summary>
/// gets or sets value indicating whether the content user no Follow for Seo
/// </summary>
public virtual bool UseNoFollow { get; set; }
/// <summary>
/// gets or sets value indicating whether the content user no Index for Seo
/// </summary>
public virtual bool UseNoIndex { get; set; }
/// <summary>
/// gets or sets value indicating whether the content in sitemap
/// </summary>
public virtual bool IsInSitemap { get; set; }
/// <summary>
/// gets or sets a value indicating whether the content comments are allowed
/// </summary>
public virtual bool AllowComments { get; set; }
/// <summary>
/// gets or sets a value indicating whether the content comments are allowed for anonymouses
/// </summary>
public virtual bool AllowCommentForAnonymous { get; set; }
/// <summary>
/// gets or sets viewed count by rss
/// </summary>
public virtual long ViewCountByRss { get; set; }
/// <summary>
/// gets or sets viewed count
/// </summary>
public virtual long ViewCount { get; set; }
/// <summary>
/// Gets or sets the total number of comments
/// <remarks>The same as if we run Item.Comments.where(a=>a.Status==Status.Approved).Count()
/// We use this property for performance optimization (no SQL command executed)
/// </remarks>
/// </summary>
public virtual int ApprovedCommentsCount { get; set; }
/// <summary>
/// Gets or sets the total number of comments
/// <remarks>The same as if we run Item.Comments.where(a=>a.Status==Status.UnApproved).Count()
/// We use this property for performance optimization (no SQL command executed)</remarks></summary>
public virtual int UnApprovedCommentsCount { get; set; }
/// <summary>
/// gets or sets value indicating whether the content is logical deleted or hidden
/// </summary>
public virtual bool IsDeleted { get; set; }
/// <summary>
/// gets or sets rating complex instance
/// </summary>
public virtual Rating Rating { get; set; }
/// <summary>
/// gets or sets value indicating whether the content show with rssFeed
/// </summary>
public virtual bool ShowWithRss { get; set; }
/// <summary>
/// gets or sets value indicating maximum days count that users can send comment
/// </summary>
public virtual int DaysCountForSupportComment { get; set; }
/// <summary>
/// gets or sets information of User-Agent
/// </summary>
public virtual string Agent { get; set; }
/// <summary>
/// gets or sets icon name with size 200*200 px for snippet
/// </summary>
public virtual string SocialSnippetIconName { get; set; }
/// <summary>
/// gets or sets title for snippet
/// </summary>
public virtual string SocialSnippetTitle { get; set; }
/// <summary>
/// gets or sets description for snippet
/// </summary>
public virtual string SocialSnippetDescription { get; set; }
/// <summary>
/// gets or sets body of content's comment
/// </summary>
public virtual byte[] RowVersion { get; set; }
/// <summary>
/// gets or sets name of tags seperated by comma that assosiated with this content fo increase performance
/// </summary>
public virtual string TagNames { get; set; }
/// <summary>
/// gets or sets counter for Content's report
/// </summary>
public virtual int ReportsCount { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// get or set user that create this record
/// </summary>
public virtual User Author { get; set; }
/// <summary>
/// gets or sets Id of user that create this record
/// </summary>
public virtual long AuthorId { get; set; }
/// <summary>
/// get or set the tags integrated with content
/// </summary>
public virtual ICollection<Tag> Tags { get; set; }
#endregion
} بخش‌های مختلفی که در ابتدای مقاله مطرح شدند، دارای یکسری خصوصیات مشترک می‌باشند و برای این منظور این خصوصیات را در یک کلاس پایه کپسوله کرده‌ایم. شاید تفکر شما این باشد که میخواهیم ارث بری TPH یا TPT را اعمال کنیم. ولی با توجه به سلیقه‌ی شخصی، در این بخش قصد استفاده از ارث بری را ندارم.
نکته‌ای که وجود دارد فیلدهای ApprovedCommentsCount UnApprovedCommentsCount و TagNames می‌باشند که هنگام درج نظر جدید باید تعداد نظرات ذخیره شده را ویرایش کنیم و هنگام ویرایش خود پست یا خبر با ... و یا حتی ویرایش خود تگ یا حذف آن تگ باید TagNames که لیست برچسب‌های محتوا را به صورت جدا شده با (,) از هم دیگر میباشد، ویرایش کنیم (جای بحث دارد).
مشخص است که هر یک از مطالب منتشر شده در بخش‌های وبلاگ، اخبار، نظرسنجی و آگهی‌ها، یک کابر ایجاد کننده (Author نامیده‌ایم) خواهد داشت و هر کاربر هم میتواند چندین مطلب را ایجاد کند. لذا رابطه‌ی یک به چند بین تمام این بخش‌ها مذکور و کاربر ایجاد خواهد شد.
مدل LinkBack
/// <summary>
/// Represents link for implemention linkback
/// </summary>
public class LinkBack
{
#region Ctor
/// <summary>
/// create one instance of <see cref="LinkBack"/>
/// </summary>
public LinkBack()
{
CreatedOn = DateTime.Now;
Id = SequentialGuidGenerator.NewSequentialGuid();
}
#endregion
#region Properties
/// <summary>
/// gets or sets link's Id
/// </summary>
public virtual Guid Id { get; set; }
/// <summary>
/// gets or sets text for show Link
/// </summary>
public virtual string Title { get; set; }
/// <summary>
/// gets or sets link's address
/// </summary>
public virtual string Url { get; set; }
/// <summary>
/// gets or set value indicating whether this link is internal o external
/// </summary>
public virtual LinkBackType Type { get; set; }
/// <summary>
/// gets or sets date that this record is added
/// </summary>
public virtual DateTime CreatedOn { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// gets or sets Post that associated
/// </summary>
public virtual BlogPost Post { get; set; }
/// <summary>
/// gets or sets id of Post that associated
/// </summary>
public virtual long PostId { get; set; }
#endregion
}
/// <summary>
/// represents Type of ReferrerLinks
/// </summary>
public enum LinkBackType
{
/// <summary>
/// Internal link
/// </summary>
Internal,
/// <summary>
/// External Link
/// </summary>
External
} مطمئنا در خیلی از وبلاگ‌ها مثل سایت جاری متوجه نمایش لینک‌ها ارجاع دهنده‌های خارجی و داخلی در زیر مطلب شده‌اید. کلاس LinkBack هم دقیقا برای این منظور در نظرگرفته شده است که عنوان صفحه‌ای که این پست در آنجا لینک داده شده است، به همراه آدرس آن صفحه، در جدول حاصل از این کلاس ذخیره خواهند شد. نوع داده LinkBackType هم برای متمایز کردن رکورد‌های درج شده به عنوان LinkBack در نظر گرفته شده است که بتوان آنها را متمایز کرد، به ارجاعات داخلی و خارجی.
مدل پست ها
/// <summary>
/// Represents a blog post
/// </summary>
public class BlogPost : BaseContent
{
#region Ctor
/// <summary>
/// Create one Instance of <see cref="BlogPost"/>
/// </summary>
public BlogPost()
{
Rating = new Rating();
PublishedOn = DateTime.Now;
}
#endregion
#region Properties
/// <summary>
/// gets or sets Status of LinkBack Notifications
/// </summary>
public virtual LinkBackStatus LinkBackStatus { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// get or set blog post's Reviews
/// </summary>
public virtual ICollection<BlogComment> Comments { get; set; }
/// <summary>
/// get or set collection of links that reference to this blog post
/// </summary>
public virtual ICollection<LinkBack> LinkBacks { get; set; }
/// <summary>
/// get or set Collection of Users that Contribute on this post
/// </summary>
public virtual ICollection<User> Contributors { get; set; }
#endregion
}
/// <summary>
/// Represents Status for ReferrerLinks
/// </summary>
public enum LinkBackStatus
{
[Display(Name ="غیرفعال")]
Disable,
[Display(Name = "فعال")]
Enable,
[Display(Name = "لینک‌ها داخلی")]
JustInternal,
[Display(Name = "لینک‌ها خارجی")]
JustExternal
} /// <summary>
/// Represents a base class for every comment in system
/// </summary>
public abstract class BaseComment
{
#region Properties
/// <summary>
/// get or set identifier of record
/// </summary>
public virtual long Id { get; set; }
/// <summary>
/// gets or sets date of creation
/// </summary>
public virtual DateTime CreatedOn { get; set; }
/// <summary>
/// gets or sets displayName of this comment's Creator if he/she is Anonymous
/// </summary>
public virtual string CreatorDisplayName { get; set; }
/// <summary>
/// gets or sets body of blog post's comment
/// </summary>
public virtual string Body { get; set; }
/// <summary>
/// gets or sets body of blog post's comment
/// </summary>
public virtual Rating Rating { get; set; }
/// <summary>
/// gets or sets informations of agent
/// </summary>
public virtual string UserAgent { get; set; }
/// <summary>
/// gets or sets siteUrl of Creator if he/she is Anonymous
/// </summary>
public virtual string SiteUrl { get; set; }
/// <summary>
/// gets or sets Email of Creator if he/she is anonymous
/// </summary>
public virtual string Email { get; set; }
/// <summary>
/// gets or sets status of comment
/// </summary>
public virtual CommentStatus Status { get; set; }
/// <summary>
/// gets or sets Ip Address of Creator
/// </summary>
public virtual string CreatorIp { get; set; }
/// <summary>
/// gets or sets datetime that is modified
/// </summary>
public virtual DateTime? ModifiedOn { get; set; }
/// <summary>
/// gets or sets counter for report this comment
/// </summary>
public virtual int ReportsCount { get; set; }
#endregion
#region NavigationProperties
/// <summary>
/// get or set user that create this record
/// </summary>
public virtual User Creator { get; set; }
/// <summary>
/// get or set Id of user that create this record
/// </summary>
public virtual long? CreatorId { get; set; }
#endregion
}
public enum CommentStatus
{
/* 0 - approved, 1 - pending, 2 - spam, -1 - trash */
[Display(Name = "تأیید شده")]
Approved = 0,
[Display(Name = "در انتظار بررسی")]
Pending = 1,
[Display(Name = "جفنگ")]
Spam = 2,
[Display(Name = "زباله دان")]
Trash = -1
} /// <summary>
/// Represents a blog post's comment
/// </summary>
public class BlogComment : BaseComment
{
#region Ctor
/// <summary>
/// Create One Instance for <see cref="BlogComment"/>
/// </summary>
public BlogComment()
{
Rating = new Rating();
CreatedOn = DateTime.Now;
}
#endregion
#region NavigationProperties
/// <summary>
/// gets or sets BlogComment's identifier for Replying and impelemention self referencing
/// </summary>
public virtual long? ReplyId { get; set; }
/// <summary>
/// gets or sets blog's comment for Replying and impelemention self referencing
/// </summary>
public virtual BlogComment Reply { get; set; }
/// <summary>
/// get or set collection of blog's comment for Replying and impelemention self referencing
/// </summary>
public virtual ICollection<BlogComment> Children { get; set; }
/// <summary>
/// gets or sets post that this comment sent to it
/// </summary>
public virtual BlogPost Post { get; set; }
/// <summary>
/// gets or sets post'Id that this comment sent to it
/// </summary>
public virtual long PostId { get; set; }
#endregion
} 