Hello guys, i am bulding asp.net core2.1 web app using Entity Framework, i want to create database automatically when i run the programm,
my appsettings.json`
{
"Logging": {
"LogLevel": {
"Default": "Warning"
}
},
"AllowedHosts": "*",
"DbConfig": {
"ConnectionString": "Server=**********;uid=*****;Password=*******;Database=TestDb;Trusted_Connection=True;Integrated Security=false;"
}
}
my model`
[Table("User", Schema = "dbo")]
public class User : Iuser
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int? Id { get; set; }
[Column(TypeName = "varchar(20)")]
public string FirstName { get; set; }
[Column(TypeName = "varchar(20)")]
public string LastName { get; set; }
[Column(TypeName = "varchar(20)")]
public string Email { get; set; }
[NotMapped]
public string Password { get; set; }
[NotMapped]
public string ConfirmPassword { get; set; }
[Column(TypeName = "varchar(20)")]
public string Hash { get; set; }
[Column(TypeName = "varchar(20)")]
public string Salt { get; set; }
[Column(TypeName = "varchar(20)")]
public DateTime? CreatedOn { get; set; }
}
my context`
public class UserContext : BaseDbContext
{
public DbSet<User> Users { get; set; }
public UserContext(){}
public UserContext(DbContextOptions<UserContext> options):base(options) { }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
optionsBuilder.UseSqlServer("Server=******;uid=*****;Password=*******;Database=TestDb;Trusted_Connection=True;Integrated Security=false;");
}
}
public void AddUser(User entity)
{
using (UserContext context = new UserContext())
{
entity.CreatedOn = DateTime.Now;
context.Users.Add(entity);
context.SaveChanges();
}
}
}
but when i run the code, it shows SQLexception: invalid object name 'dbo....' ERROR, any ideas?