Hi,
I can add new record in a table but when I edit it Radzen show dialogue that "Unable to update table", what is the reason?
Dz
Hi,
I can add new record in a table but when I edit it Radzen show dialogue that "Unable to update table", what is the reason?
Dz
You can check the exception in Radzen output pane
I just got:
Have you checked the exception in Radzen output pane?
Hi Enchev,
It is no error. FYI, this this is Primary Key in table, I do not know the reason. I can edit it in database (SQL Server).
Dz
Is this a deployed application? In this case the exception will not be available in Radzen output pane. More info on how to check the log of deployed applications can be found here:
No, it is till in Radzen.
Dzung
Can you check the result from this request in your browser console network tab?
Yes, dialogue appears and dis-appears so fast, no thing wrong. Could yo check the case, when create Primary Key as auto increase, Add New and Edit is fine. But Primary Key as char, it cause error in saving if the field edited and save.
You've not checked the network tab? Can you check it and post a screenshot here?
Is your app Angular or Blazor? If the key is not auto-increment most probably the database is refusing the value - it might be duplicate or some other restriction might be applied. Until we see the original exception we will not know.
Mine is Blazor. I just test 5 records can not be duplicated. I tested in database no problem.
Dz
radzen: Generating code ...
radzen: Code generation done in 1219ms.
dotnet: watch : Started
dotnet: info: Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0]
User profile is available. Using 'C:\Users\HP\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
dotnet: info: Microsoft.Hosting.Lifetime[0]
Now listening on: http://localhost:5000
dotnet: info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Development
info: Microsoft.Hosting.Lifetime[0]
Content root path: C:\ZDung HDD\GitHub\RadZen-Projects\ERP_CAN_Project\eprcan\server
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/
dotnet: warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
Failed to determine the https port for redirect.
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_Host'
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[3]
Route matched with {page = "/_Host", action = "", controller = ""}. Executing page /_Host
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[103]
Executing an implicit handler method - ModelState is Valid
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[104]
Executed an implicit handler method, returned result Microsoft.AspNetCore.Mvc.RazorPages.PageResult.
dotnet: info: Microsoft.AspNetCore.Mvc.RazorPages.Infrastructure.PageActionInvoker[4]
Executed page /_Host in 36.5203ms
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/_Host'
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 84.6919ms 200 text/html; charset=utf-8
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/Radzen.Blazor.js
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_framework/blazor.server.js
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/assets/css/styles.css
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/Radzen.Blazor.js was not modified
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /assets/css/styles.css was not modified
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_framework/blazor.server.js was not modified
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 2.3954ms 304 text/css
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 4.6504ms 304 application/javascript
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 4.7557ms 304 application/javascript
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/assets/css/styles-generated.css
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /assets/css/styles-generated.css was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 0.2942ms 304 text/css
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/css/default.css
info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/css/default.css was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 0.3276ms 304 text/css
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/_blazor/negotiate text/plain;charset=UTF-8 0
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_blazor/negotiate'
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/_blazor/negotiate'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 7.689900000000001ms 200 application/json
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_blazor?id=yJHRrOD9xjaZA2eck5687A
dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint '/_blazor'
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[20601]
The 'bool' property 'Inactive' on entity type 'TblIcInventory' is configured with a database-generated default. This default will always be used for inserts when the property has the value 'false', since this is the CLR default for the 'bool' type. Consider using the nullable 'bool?' type instead so that the default will only be used for inserts when the property value is 'null'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'EverageCost' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LTD_COGS' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LTD_Gross_Sales' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LastCost' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn
dotnet: : Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'MTD_COGS' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'MTD_Gross_Sales' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'UnitPrice' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_COGS' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_Gross_Sales' on entity type 'TblIcInventory'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Trans_Amount' on entity type 'TblIcTransaction'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Amount' on entity type 'TblPoAccountPayable'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Amount' on entity type 'TblPoAccountsPayableAdjustment'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Discount_Amount' on entity type 'TblPoApInvoice'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Invoice_Amount' on entity type 'TblPoApInvoice'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Unit_Price' on entity type 'TblPoApInvoicesDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Check_Amount' on entity type 'TblPoCashDisbursement'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Discount_Invt_Amt' on entity type 'TblPoCashDisbursement'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Gross_Invt_Amt' on entity type 'TblPoCashDisbursement'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'PO_Amount' on entity type 'TblPoPurchaseOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Unit_Price' on entity type 'TblPoPurchaseOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'PO_Amount' on entity type 'TblPoRecReport'. This will cause values to be silently truncated if they do not fit in the default precision and scale.
dotnet: Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Unit_Price' on entity type 'TblPoRrOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'AP_Balance' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LYR_Purchase' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'MTD_Purchase' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Outstand_Credit' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn
dotnet: : Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Outstand_Inv_Amt' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_Purchase' on entity type 'TblPoVendor'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Aging30DayAmout' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Aging60DayAmout' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Aging90DayAmout' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'CommissionPercent' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'CreditLimit' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Current_MTD_Returns' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Current_MTD_Sales' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LYR_COGS' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LYR_GrossSales' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'LastAmountSales' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'SalesPerson_MTD_Goal' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'SalesPerson_YTD_Goal' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_COGS' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_GrossSales' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'YTD_Returns' on entity type 'TblSoCustomer'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Discount' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'DiscountPercent' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'SubTotal' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Tax' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'TaxRate' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'UnitPrice' on entity type 'TblSoOrderDetail'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Commission' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn
dotnet: : Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Discount_Amt' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Freight' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Subtotal' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'TaxtRate' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Taxt_Amount' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: warn: Microsoft.EntityFrameworkCore.Model.Validation[30000]
No type was specified for the decimal column 'Total_Order' on entity type 'TblSoSalesOrder'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
dotnet: info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
Entity Framework Core 3.0.0 initialized 'CanErpDbAt132Context' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [dbo].[tblGN_AddressBook] AS [t]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t0].[AddressBook_SEQ], [t0].[Address], [t0].[AddressBookType_FK], [t0].[AddressBook_ID], [t0].[City_FK], [t0].[DOB], [t0].[FirstName], [t0].[Gender_FK], [t0].[IDNumber], [t0].[JobPosition], [t0].[LastName], [t0].[OrganizationName], [t0].[Origin], [t0].[TaxIDNumber], [t1].[AddressBookType_SEQ], [t1].[AddressBookTypeText], [t1].[AddressBookType_ID], [t2].[Gender_SEQ], [t2].[Gender], [t2].[Gender_ID], [t3].[City_SEQ], [t3].[CityAbbreviation], [t3].[CityName], [t3].[City_ID]
FROM (
SELECT [t].[AddressBook_SEQ], [t].[Address], [t].[AddressBookType_FK], [t].[AddressBook_ID], [t].[City_FK], [t].[DOB], [t].[FirstName], [t].[Gender_FK], [t].[IDNumber], [t].[JobPosition], [t].[LastName], [t].[OrganizationName], [t].[Origin], [t].[TaxIDNumber]
FROM [dbo].[tblGN_AddressBook] AS [t]
ORDER BY (SELECT 1)
OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
) AS [t0]
LEFT JOIN [dbo].[tblGN_AddressBookType] AS [t1] ON [t0].[AddressBookType_FK] = [t1].[AddressBookType_SEQ]
LEFT JOIN [dbo].[tblGN_Gender] AS [t2] ON [t0].[Gender_FK] = [t2].[Gender_SEQ]
LEFT JOIN [dbo].[tblGN_City] AS [t3] ON [t0].[City_FK] = [t3].[City_SEQ]
dotnet: info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/_content/Radzen.Blazor/fonts/MaterialIcons-Regular.woff
dotnet: info: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[6]
The file /_content/Radzen.Blazor/fonts/MaterialIcons-Regular.woff was not modified
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 0.2934ms 304 application/font-woff
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [dbo].[tblIC_Category] AS [t]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[Category_ID], [t].[CategoryText], [t].[Inactive]
FROM [dbo].[tblIC_Category] AS [t]
ORDER BY (SELECT 1)
OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[@__categoryId_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [t].[Category_ID], [t].[CategoryText], [t].[Inactive]
FROM [dbo].[tblIC_Category] AS [t]
WHERE ([t].[Category_ID] = @__categoryId_0) AND @__categoryId_0 IS NOT NULL
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT COUNT(*)
FROM [dbo].[tblIC_Category] AS [t]
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [t].[Category_ID], [t].[CategoryText], [t].[Inactive]
FROM [dbo].[tblIC_Category] AS [t]
ORDER BY (SELECT 1)
OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
dotnet: info: Microsoft.EntityFrameworkCore.Database.Command[20100]
Executing DbCommand [Parameters=[@__categoryId_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [t].[Category_ID], [t].[CategoryText], [t].[Inactive]
FROM [dbo].[tblIC_Category] AS [t]
WHERE ([t].[Category_ID] = @__categoryId_0) AND @__categoryId_0 IS NOT NULL
I'm afraid that I'm out of ideas. If you own Radzen license you can send us your application together with SQL script at info@radzen.com to test your scenario locally.
I just sent. Thanks.
Dz
I'm posting the exception here for reference:
"The property 'Category_ID' on entity type 'TblIcCategory' is part of a key and so cannot be modified or marked as modified. To change the principal of an existing entity with an identifying foreign key first delete the dependent and invoke 'SaveChanges' then associate the dependent with the new principal."
There are no problems when adding records in this table however you cannot edit/update the primary key value. More info can be found also here: https://stackoverflow.com/questions/29675081/how-to-update-primary-key-from-entity-framework