the nclob type is not qualified with a namespace or alias. Only primitive types can be used without qualification.
At this line :
Code: Select all
UserProfile model = uc.UserProfiles // here
.Where(o =>o.UserName == id)
.First();
Code: Select all
public class UsersContext : DbContext
{
public UsersContext()
: base("DefaultConnection")
{
}
public DbSet<UserProfile> UserProfiles { get; set; }
}
[Table("USERPROFILE")]
public class UserProfile
{
[Key]
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int UserId { get; set; }
public string UserName { get; set; }
public string Email { get; set; }
public string Name { get; set; }
public string Num { get; set; }
}
Code: Select all
<add name="DefaultConnection" connectionString="User Id=devart;Password=1234;Data Source=localhost:1521"
providerName="Devart.Data.Oracle" />