you did answer: Exception message and full stack trace! i think it is a BUG
for the 2nd part, what you mean add new endpoint to return dto with deletion info?
sorry I don't have the privilege to send the project code,simpl just add a new table as below:
public class Person: FullAuditedAggregateRoot<Guid>, IMultiTenant
{
public virtual Guid? TenantId { get; set; }
public virtual long PersonNo { get; set; }
public virtual string Name { get; set; }
public virtual bool IsCitizen { get; set; }
[CanBeNull]
public virtual string? NationalNo { get; set; }
protected Person()
{
}
}
the configuration in the dbcontext as below:
builder.Entity<Person>(b =>
{
b.ToTable(BstCoreDbProperties.DbTablePrefix + "Persons", BstCoreDbProperties.DbSchema);
b.ConfigureByConvention();
b.Property(x => x.TenantId).HasColumnName(nameof(Person.TenantId));
b.Property(x => x.Name).HasColumnName(nameof(Person.Name1)).IsRequired();
b.HasIndex(x => new { x.TenantId, x.PersonNo }).IsUnique();
b.HasIndex(x => new { x.TenantId, x.Name }).IsUnique();
b.HasIndex(x => new { x.TenantId, x.NationalNo });//.IsUnique();
b.Property(o => o.PersonNo)
.HasDefaultValueSql("NEXT VALUE FOR PersonNo").ValueGeneratedOnAdd();
});
builder.HasSequence<long>("PersonNo").StartsAt(100000001).IncrementsBy(1);`
once you created this table, make a test to add two records with different tenant names, and check the generated sequence no (PersonNo) , it should be 100000001 for tenant#1, and 100000001 for tenant#2 but the output is 100000001 for tenant#1 and 100000002 for tenant#2
first thx for your replay,
but it seems you didn't get my point, the application is multi-tenancy according to Abp.io's practice
so we have a tenant for each client (shared db),
now we have the table name "Account", and we should create Sequences for this table in the field "AccountNo".
the above code will generate the same sequence for all clients, but it should be for each client(tenant) sequence
Hi,
What database are you using? ** SQL Server**
Note that the specific SQL used to generate a value from a sequence is database-specific; the above example works on SQL Server but will fail on other databases. Consult your specific database's documentation for more information.
See: https://learn.microsoft.com/en-us/ef/core/modeling/sequences#basic-usage
noting i use SQL server , my question here is there any way to achieve the required sequence per tenant?
i already have my current apps running since version 6 and last time i updated it from 7.3.0 to 7.4.0-rc.3 using using the command abp update cmd
<PackageReference Include="Volo.Abp.Autofac" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.AspNetCore.Serilog" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.AspNetCore.Authentication.JwtBearer" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.Swashbuckle" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.FeatureManagement.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.Account.Pro.Public.Web.OpenIddict" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.Account.Pro.Admin.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.AuditLogging.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.Identity.Pro.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.OpenIddict.Pro.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.LanguageManagement.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Saas.Host.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.TextTemplateManagement.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.Gdpr.Web" Version="7.4.0-rc.3" /> <PackageReference Include="Volo.Abp.LeptonTheme.Management.Web" Version="7.4.0-rc.3" />
for the details tab in edit user as i said, we already override the razor page, so this new tab didn't appear, i just want the razor page for the details to add it in our existing override page
Forms Module:
Add more options when you want to create a form survey such as:
plz try it in blazor-server abp new bookstoreblazor -u blazor-server --preview
for me it exists, I've created a new sln through Abp suite, and the same results!! could you inform me of your steps?
regarding the Edgae, I can't ask the user to adjust his browser settings, so can you inform me how to move it to the top of the screen instead? its about look and feel not an issue thanks for your understanding
custom middleware adding System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.InvariantCulture; after app.UseAbpRequestLocalization(); didn't solve it what do you mean by add custom middleware?
e an article about them
I see we are talking about how to implement things with the ABP framework, if we chose .net framework instead of ABP framework it will be easier for us as developers to make a workaround or you can find many articles to guide us, but when it comes to the ABP.IO always spent extra time to find a workaround for some things! for sure I don't mean underestimating ABP.IO, but the team who build it understands it better than us I'll remind you with the statement "We chose ABP.IO to focus on business " which means not to spend extra time to find a workaround especially when it comes to the Commerical version.