Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.

Hi
 
i have problem in this senario :

I have Sql server database 2008 R2 ,
Entity FrameWork 4 with ModelFirst approach
project : PM software with GIS
 
beacuse security we decided that security of system implemented with RLS(Row level Security ) on server side (DBMS) , i mean with Schema and View on Sql only Record's of views showed up for valid user ,
and for Views in SQL don't have relation to other views
" for example tables that we connect their relation wity PK and FK "
 
when i generate EF model from database only i add views in the Model
so , i corrected Name Of Views with polorilize , change Updatableview Confige for any view that supported as well as Table ,
and by hand i connect all relation between entities that made up of views
by Navigation panel and association Tool
 
what's the problem :
beacuse i created all relation in EDM between entitys and thease not exsit in between of views
,
any time i change fileds,views , name of views , schema of view and important of them New Views with New Schema and ,...
when I update model by EF EDm (ModelFirst)
all of older entities crashed ,
all of realation between entities damaged
, and all change not returned
 
note :
for speed , security and distributed business of system
we tryed all proccess and all calculation on server sidee
 
plaese Help me....
 
King Regard
 
DOT NET Developer
Ali Sarshogh . Iran country.Isfahan City
Chief programmer.
Posted 31-Dec-12 3:27am
Edited 31-Dec-12 3:48am
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 424
1 ridoy 400
2 DamithSL 230
3 OriginalGriff 179
4 Suvendu Shekhar Giri 150
0 OriginalGriff 8,033
1 DamithSL 6,179
2 Sergey Alexandrovich Kryukov 5,538
3 Maciej Los 5,508
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 31 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100