C# Regex class provides pattern matching funcions in form of regular expressions. The source code examples in this article show how to use Regular Expressions to validate different inputs. The code provides methods to validate Alphabet, AlphaNumeric, Integer, Postive Integers, Floating point numbers and so on
Create VIEW EmployeesView
AS
SELECT id,
FirstName
FROM Employees
using System.ComponentModel.DataAnnotations;
namespace EF_Sample04.Models
{
[Table("EmployeesView")]
public class EmployeesView
{
public int Id { set; get; }
public string FirstName { set; get; }
}
}
There is already an object named 'EmployeesView' in the database.
Database.SetInitializer<Sample04Context>(null);
Add-Migration Init -IgnoreChanges
Update-Database
using System.ComponentModel.DataAnnotations;
using System.Xml.Linq;
namespace EF_Sample04.Models
{
public class MyXMLTable
{
public int Id { get; set; }
[Column(TypeName = "xml")]
public string XmlValue { get; set; }
[NotMapped]
public XElement XmlValueWrapper
{
get { return XElement.Parse(XmlValue); }
set { XmlValue = value.ToString(); }
}
}
}
namespace EF_Sample04.Models
{
public class ActivityType
{
public int UserId { set; get; }
public int ActivityID { get; set; }
}
}
using System.Data.Entity.ModelConfiguration;
using EF_Sample04.Models;
namespace EF_Sample04.Mappings
{
public class ActivityTypeConfig : EntityTypeConfiguration<ActivityType>
{
public ActivityTypeConfig()
{
this.HasKey(x => new { x.ActivityID, x.UserId });
}
}
}
var activity1 = db.ActivityTypes.Find(4, 1);
using System.Collections.Generic;
namespace EF_Sample04.Models
{
public class Employee
{
public int Id { set; get; }
public string FirstName { get; set; }
public string LastName { get; set; }
//public int? ManagerID { get; set; }
public virtual Employee Manager { get; set; }
}
}
using System.Data.Entity.ModelConfiguration;
using EF_Sample04.Models;
namespace EF_Sample04.Mappings
{
public class EmployeeConfig : EntityTypeConfiguration<Employee>
{
public EmployeeConfig()
{
this.HasOptional(x => x.Manager)
.WithMany()
//.HasForeignKey(x => x.ManagerID)
.WillCascadeOnDelete(false);
}
}
}
DECLARE @CPU_BUSY int, @IDLE int
SELECT @CPU_BUSY = @@CPU_BUSY, @IDLE = @@IDLE WAITFOR DELAY '000:00:01'
SELECT (@@CPU_BUSY - @CPU_BUSY)/((@@IDLE - @IDLE + @@CPU_BUSY - @CPU_BUSY) *1.00) *100 AS 'CPU Utilization by sqlsrvr.exe'
USE [master]
GO
sp_configure 'show advanced options',1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'Database Mail XPs',1
GO
--RECONFIGURE
GO
-- Create a New Mail Profile for Notifications
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'DBA_Notifications',
@description = 'Profile for sending Automated DBA Notifications'
GO
-- Set the New Profile as the Default
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'DBA_Notifications',
@principal_name = 'public',
@is_default = 1 ;
GO
-- Create an Account for the Notifications
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'SQLMonitor',
@description = 'Account for Automated DBA Notifications',
@email_address = 'nasiri@site.net', -- Change This
@display_name = 'SQL Monitor',
@mailserver_name = 'mail.site.net' -- Change This
GO
-- Add the Account to the Profile
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'DBA_Notifications',
@account_name = 'SQLMonitor',
@sequence_number = 1
GO
--test
EXECUTE msdb.dbo.sp_send_dbmail
@recipients = 'nasiri@site.net', -- Change This
@Subject = 'Test Message generated from SQL Server DatabaseMail',
@Body = 'This is a test message from SQL Server DatabaseMail'
DECLARE @CPUUsage INT
DECLARE @CPU_BUSY INT,
@IDLE INT
SELECT @CPU_BUSY = @@CPU_BUSY,
@IDLE = @@IDLE
WAITFOR DELAY '000:00:01'
SELECT @CPUUsage = (@@CPU_BUSY - @CPU_BUSY) / ((@@IDLE - @IDLE + @@CPU_BUSY - @CPU_BUSY) * 1.00)
* 100 -- CPU Utilization by sqlsrvr.exe
IF @CPUUsage > 50
BEGIN
DECLARE @msg NVARCHAR(1000)
SET @msg = 'Please check SQL server, CPU usage is ' + CAST(@CPUUsage AS NVARCHAR(50))
+ '%.'
EXECUTE msdb.dbo.sp_send_dbmail
@recipients = 'nasiri@site.net', -- Change This
@copy_recipients = 'nasiri@site.net', -- Change This
@Subject = 'CPU overload',
@Body = @msg
,@importance = 'High'
END
There’s a lot you can do on GitHub that doesn’t require a complex development environment, like sharing feedback on a design discussion or reviewing a few lines of code. We’re making these tasks easier to complete while you’re on the go, with a fully-native experience. With GitHub for mobile, you have the flexibility to move work forward and stay in touch with your team, wherever you are
Data drive D:
Transaction Log drive E:
TempDB drive F:
Backup drive G:
windows settings -> security settings -> local policies -> user rights assignment -> lock pages in memory
ALTER DATABASE dbName SET AUTO_UPDATE_STATISTICS ON
ALTER DATABASE dbName SET AUTO_UPDATE_STATISTICS_ASYNC ON
What they neglect to say is all that testability and persistence ignorance flies right out the window when you create a new ASP.NET Web Application using the MVC template and "Individual User Accounts" authentication. What you get is a single-layered application, tightly coupled to Entity Framework, that:
Ignores the patterns that facilitate testing, including: the repository pattern, unit of work pattern, and dependency injection;
Forces you to implement their IUser interface in your application’s User entity, thereby coupling it to ASP.NET Identity;
Eliminates any clear separation between your entities, persistence concerns, and business logic. Persistence ignorance? Forget about it.
Thankfully, due to the extensibility designed into ASP.NET Identity, it is possible to ditch the reference to the Microsoft.AspNet.Identity.EntityFramework assembly and write a custom implementation that can address these and other architectural issues. Just be forewarned: it is not a trivial undertaking, and you’ll have to put up with some code smell that is baked into the Microsoft.AspNet.Identity.Core assembly.
// در این قسمت discounts
// در کالاهای مشابه اضافه نشده است
var serchResult = LuceneIndex.GetMoreLikeThisProjectItems(id)
.Where(item => item.Category == "کالاها").Skip(1).Take(8).ToList();
List<ProductWidgetViewModel> productToDel = new List<ProductWidgetViewModel>();
if (serchResult.Count > 0)
{
foreach (var product in serchResult)
{
if (product.Discount > 0)
{
var resul = await _productService.GetProductDiscount(product.Id);
// محصول در دیتابیس وجود نداشته
if (resul == null)
{
productToDel.Add(product);
//error
//serchResult.Remove(product);
}
else if (resul.Discount != 0)
{
product.Discounts = new List<ProductPageDiscountWidgetViewModel>();
product.Discounts.Add(resul);
}
}
}
}
foreach (var product in productToDel)
{
serchResult.Remove(product);
}
ViewData["SimilarProducts"] = serchResult; public async Task<ProductPageDiscountWidgetViewModel> GetProductDiscount(int productId)
{
var product = await _products.FirstOrDefaultAsync(p => p.Id == productId);
//by SYA
// در ایندکس هست اما در دیتابیس نیست product == null
if (product == null)
{
return null;
}
else if (product.Discounts == null)
{
return new ProductPageDiscountWidgetViewModel { Discount = 0 };
}
//_mappingEngine.Map<ProductDiscount, ProductPageDiscountWidgetViewModel>(
// product.Discounts.OrderByDescending(p => p.EndDate).FirstOrDefault());
foreach (var dic in product.Discounts.OrderByDescending(p => p.StartDate).ToList())
{
if (dic.Discount > 0 && dic.EndDate >= DateTimeExtentionService.NowIranZone())
{
return _mappingEngine.Map<ProductDiscount, ProductPageDiscountWidgetViewModel>(dic);
}
}
return new ProductPageDiscountWidgetViewModel { Discount = 0 };
} Join us on November 8, for the launch of Visual Studio 2022. Learn about what's new, hear tips & tricks, participate in the live Q&As, and be the first to take the latest version for a spin.
