Navigation properties are lazy loaded by default (every time that I've ever used them)
an easy thing to do would be to move your DbContext down to a new library that both other projects depend on, but you may already see why that would be impractical, especially since you're likely to have tweaked the DbContext to specifically suit the app
in your lib, you accept an instance of the repository as a dependency in places where you need it
and in your app, you create a class that implements that repository interface that accepts the DbContext as a dependency
and in your app, you create a class that implements that repository interface that accepts the DbContext as a dependency
So, my question is, can I inject the db context the same way into a class library?
that's the reason you create a repository interface at that project level, with its implementation higher up so the DbContext can get injected there and the interface providing the ability to be passed to services lower down
Using this connection string:
Server={host}.postgres.database.azure.com;Database={your_database};Port=5432;User Id={user_id};Password={your_password};Ssl Mode=Require;, i tried to publish the web api to azure services, but got a deploy error
@blizzardsolution this should help: https://www.dotnetcurry.com/aspnet/1410/aspnet-core-app-postgresql-azure
Once you have the connection string, install the npgsql plugin for EF Core, set the connection string and use something like this in your Startup.cs in place of the instructions for SQLServer:
Once you have the connection string, install the npgsql plugin for EF Core, set the connection string and use something like this in your Startup.cs in place of the instructions for SQLServer:
services.AddDbContext<ApplicationDbContext>(options =>
options.UseNpgsql(
Configuration.GetConnectionString(
"DefaultConnection"));
@AlbertoPa , thanks for replying!! i installed npgsql package and used the same code in Startup.cs
trying to deploy the api to azure, i got the dploy error:
trying to deploy the api to azure, i got the dploy error:
C:\Program Files\dotnet\sdk\3.1.202\Sdks\Microsoft.NET.Sdk.Publish\targets\PublishTargets\Microsoft.NET.Sdk.Publish.MSDeploy.targets(140,5): Error : Web deployment task failed. (The value 'Server={host}.postgres.database.azure.com;Database={your_database};Port=5432;User Id={user_id};Password={your_password};Ssl Mode=Require;' is not a valid connection string or an absolute path. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_INVALID_CONNECTION_STRING.)
The value 'Server={host}.postgres.database.azure.com;Database={your_database};Port=5432;User Id={user_id};Password={your_password};Ssl Mode=Require;' is not a valid connection string or an absolute path. Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_INVALID_CONNECTION_STRING.
Keyword not supported: 'port'.
at System.Data.SqlClient.SqlConnectionStringBuilder.GetIndex(String keyword)
at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value)
at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
at System.Data.SqlClient.SqlConnectionStringBuilder..ctor(String connectionString)
at Microsoft.Web.Deployment.ConnectionStringMatcher.RemoveExtraSlashFromDataSourceName(String connectionString)
at Microsoft.Web.Deployment.ConnectionStringMatcher.GetStandardConnectionString(String userConnectionString, Boolean isSqlCE)
at Microsoft.Web.Deployment.SqlInfo.GetBuilder(String connectionString, String errorMessageFormat)
Publish failed to deploy.
2>Build failed. Check the Output window for more details.
have you tried asking in https://gitter.im/npgsql/npgsql ?
this is my web deploy setting
nope, not tried asking there
they seem responsive on Twitter in my limited experience
Is there anyone who are using ASP.NET Core Identity with Oracle? It has been 8 months since .NET Core 3.0 released, but ODP.NET for EF Core 3.0 or later has not been released yet. (There isn't even a beta version...)
oracle/dotnet-db-samples#49
oracle/dotnet-db-samples#49
oh, or -v, yes
I'm trying to host and SPA along side some razor pages... I want my SPA to be at '/app'. but I can't for the life of me figure out how to do that... this does not work, but its the thing that makes the most sense to me...
app.UseSpa(spa =>
{
spa.Options.SourcePath = "ClientApp";
spa.Options.DefaultPage = "/app/";
if (env.IsDevelopment())
{
spa.UseReactDevelopmentServer(npmScript: "start");
}
});
When i call add on my entity i get the message "Argument types do not match" but i know my types is the same with the DbSet and its the same one in my database. This is my code for this class, it has a custom ValueComparer i suspect something must be wrong there is this correct ? and if no how do i do it the correct way ? This happens when i call the add method to add a new object to the database.
private readonly ValueComparer<ICollection<string>> valueComparer = new ValueComparer<ICollection<string>>(
equalsExpression: (c1, c2) => c1 != null && c2 != null && c1.SequenceEqual(c2),
hashCodeExpression: c => c.Aggregate(0, (a, v) => HashCode.Combine(a, v.GetHashCode())),
snapshotExpression: c => c.ToHashSet());
public void Configure(EntityTypeBuilder<User> builder)
{
builder.Property(x => x.FavoriteStores)
.HasConversion(
to => string.Join(',', to),
from => from.Split(',', StringSplitOptions.None))
.Metadata
.SetValueComparer(valueComparer);
}
}
Ofc you spend hours searching and then you find the answer right after you ask.... remove the ToHashSet in the snapshotExpression fixed it: https://github.com/dotnet/efcore/issues/17471#issuecomment-579125422
Why my JWT token is invalid?
I can't request method which required authorization.
I check on jwt.io and there my token is "Invalid signature"
https://pastebin.com/SUUK7Wgn
I can't request method which required authorization.
I check on jwt.io and there my token is "Invalid signature"
https://pastebin.com/SUUK7Wgn