👁 Image
OLT.Core.EntityFrameworkCore.SqlServer.Abstractions 10.0.0

👁 CI
👁 Quality Gate Status

Entity Framework Core for SQL Server

• Sets the UseIdentityColumn for Entities that implememnt IOltEntityId
• Full Text Search (FTS) Utility Helper class

OltSqlDbContext

By inheriting the OltSqlDbContext, it will automatically call the OltSqlModelBuilderExtensions.SetIdentityColumns

public class DatabaseContext : OltSqlDbContext<DatabaseContext>
{
	public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
	{
	}
	
	public override string DefaultSchema => "dbo";
 public override bool DisableCascadeDeleteConvention => true;
 public override OltContextStringTypes DefaultStringType => OltContextStringTypes.Varchar;
 public override bool ApplyGlobalDeleteFilter => true;
 protected override int IdentitySeed => 1000;
 protected override int IdentityIncrement => 2;

	...
	
	public virtual DbSet<MyEntity> MyEntities => Set<MyEntity>();

	...
}

OltSqlModelBuilderExtensions

OltSqlModelBuilderExtensions.SetIdentityColumns(modelBuilder, identitySeed, identityIncrement)

OltFullTextSearchUtil

Full Text Search Helper

public IQueryable<TEntity> BuildQueryable(IQueryable<TEntity> queryable)
{
 if (Name.First.IsNotEmpty())
 {
	 var firstName = OltFullTextSearchUtil.Contains(Name.First, OltFtsWildCardType.BeginsWith, true);
	 queryable = queryable.Where(p => EF.Functions.Contains(p.FirstName, firstName));
 }

 if (Name.Middle.IsNotEmpty())
 {
	 var middleName = OltFullTextSearchUtil.Contains(Name.Middle, OltFtsWildCardType.BeginsWith, true);
	 queryable = queryable.Where(p => EF.Functions.Contains(p.MiddleName, middleName));
 }

 if (Name.Last.IsNotEmpty())
 {
	 var lastName = OltFullTextSearchUtil.Contains(Name.Last, OltFtsWildCardType.BeginsWith, true);
	 queryable = queryable.Where(p => EF.Functions.Contains(p.LastName, lastName));
 }

 return base.BuildQueryable(queryable);
}