I have posted the same question on SO, please help.
[https://stackoverflow.com/questions/48594103/how-to-call-stored-procedure-with-join-on-multiple-tables-in-entity-framework-co])
So can I implement from FullAuditedEntity instead of Entity?
@Aaron,
You are implementing from Entity not from FullAuditedEntity. So any disadvantage or side effect of not using FullAuditedEntity.
What about CreatorUserId, CreationTime, ModificationTime, DeletionTime, DeleterUserId and SoftDelete functionality? I want all these features.
Hi, I'm facing problem in getting entity data from DB using Stored Procedure.
I have posted the same question on SO also but didn't get the proper answer, please help.
[https://stackoverflow.com/questions/48565680/how-to-convert-from-dbdatareader-to-taskienumerabletentity-in-entity-framewo])
@Aaron,
Thanks a lot, I will try this and let you know if I face any challenge.
Suppose you have a table named as TestTbl, which has Id, TestId (varchar), TestId2 and some other columns. I need to have Id as autoincrement identity. TestId as PK. TestId2 unique constraint.
Requirement is very clear. What do you mean by concrete example?
This link doesn’t answer my question.
My requirement is very simple, which I have already mentioned in question.
I tried the link solution when I failed to create other columns as PK. Then I tried to create unique constraints on columns.
Hi,
I want to use Some other columns (datatype can be int, long, varchar) as PK or composite PK. But framework supports ID column as autoincrement and PK. This feature is giving me a lot of trouble.
I have posted a lot of queries on SO related to this query, but everyone suggested to use ID as PK. I also tried to make other columns as PK, but it was also giving me lot problems.
Please refer the following posts and please please please help.
[https://stackoverflow.com/questions/46153399/how-to-use-a-varchar-column-other-than-id-column-using-asp-net-boilerplate]) [https://stackoverflow.com/questions/46155968/getting-ambiguous-match-found-exception-while-calling-deleteasync]) [https://stackoverflow.com/questions/46173881/cannot-delete-record-from-table-which-has-identity-column]) [https://stackoverflow.com/questions/46192731/how-to-make-composite-unique-key-in-asp-net-boilerplate])
So my basic requirement is to Have a ID auto increment column Have a primary key column or a composite primary key Have some unique constraint columns I should not face the above mentioned issues.
@vladsd
You can refer this [https://code.visualstudio.com/docs/languages/typescript])