Programming Keys is blog for all Programming and technology related articles

Thursday, September 14, 2017

ORA-00001: unique constraint entity framework 6 code first approach

ORA-00001: unique constraint entity framework 6 Solution : -  The solution is to grant user both:  'CREATE SEQUENCE' and  'CREATE TRIGGER'  permissions and re-create the schema. ...
Share:

Wednesday, September 13, 2017

ORA-30673: column to be modified is not an identity column oracle 12c

ORA-30673: column to be modified is not an identity column Answer : -  Currently orcle 12c does not support modifying an existing column as IDENTITY column  Solution : - Solution is to add a new column and then drop the existing one ALTER TABLE Tablename ADD (ColumnName_NEW NUMBER(3) GENERATED ALWAYS AS IDENTITY);...
Share:

Custom ASP.NET Session State Management with Redis

Custom ASP.NET Session State Management with Redis  What is Redis?  Redis is an open source key value data structure store. keys can be strings, hashes, lists, sets, sorted sets etc. This in memory data store is broadly used in session state storing and caching. Steps...
Share:

Friday, September 8, 2017

ORA-00904 invalid identifier entity framework 6 migration oracle 12c

ORA-00904 invalid identifier this issue is caused because of we have used oracle keyword in column name. check below image Action is keyword in oracle. this is the reason oracle appends "" double quotes in column name.  Solution : -  Just remove the double...
Share:

ORA-01407: cannot update to NULL EF 6 Oracle 12c Migration

ORA-01407: cannot up date to NULL 1 - Solution :-  If we pass "" (blank) value in model. ef will throw error. pass "." or blank space ( ) to avoid this error. 2- Solution :- Set Default value to colu...
Share:

How to Encrypt Web config in asp.net mvc

1.      Create RSA key container (Development machine). a.       Run CMD as Administrator b.       Go To C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319 c.       aspnet_regiis -pc "InternetBanking" –exp 2.      Export the...
Share: