Hi everyone. I'm very new with this technology and still have to learn lot's of stuff...
I managed to start with basic MVC design but i'm now stuck on adding functions to model..
I created view in mssql
CREATE VIEW MyFirstView
SELECT table1.Field1, table2.Field2
FROM table1 INNER JOIN table2 ON table1.Field1 = table2.Field1
CREATE FUNCTION fnGetMyViewResult(@paramField nvarchar)
RETURN SELECT * FROM MyFirstView WHERE MyFirsView.Field1 = @paramField
but when i run entity data model wizzard from VS 2010 i can chose only from tables, views and stored procedures. There is no way (atleast no way i know about) to add my sql function to MVC model...
I can see function in ServerExplorer but not in wizzard....
Can someone help me with this?
Thanks in advance..
View Complete Post