how to get data in property class while using EDMX.

Question

Hello

 

i am using database first approach in my project. my question is that when we are us store procedure in edmx then edmx will generate property class according to first select command of the store procedure. if we have conditional multiple select query's in store procedure. so how would be edmx will decide to generate property class and fill the results in fields.

 

i am getting error while store procedure will execute second or third select command. 

 

i am sure that edmx will take only first select command fields and generates property fields accordingly. 

 

  

Answer 1

i also having that issue

ito solve this i have coded my Own Encryption and decryption Function

and Stored Setting like

below

             <Settings>
            <setting name="server" serializeAs="String">
                <value>75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ</value>
            </setting>
            <setting name="username" serializeAs="String">
                <value>115ƒ97ƒ</value>
            </setting>
            <setting name="password" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="databasename" serializeAs="String">
                <value>103ƒ119ƒ101ƒ100ƒ99ƒ</value>
            </setting>
            <setting name="gwedcConStr" serializeAs="String">
                <value>68ƒ97ƒ116ƒ97ƒ32ƒ83ƒ111ƒ117ƒ114ƒ99ƒ101ƒ61ƒ75ƒ105ƒ114ƒ116ƒ97ƒ110ƒ45ƒ80ƒ67ƒ92ƒ83ƒ81ƒ76ƒ69ƒ88ƒ80ƒ82ƒ69ƒ83ƒ83ƒ59ƒ85ƒ115ƒ101ƒ114ƒ32ƒ73ƒ100ƒ61ƒ115ƒ97ƒ59ƒ80ƒ97ƒ115ƒ115ƒ119ƒ111ƒ114ƒ100ƒ61ƒ49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
            <setting name="LogedUser" serializeAs="String">
                <value />
            </setting>
            <setting name="adminuser" serializeAs="String">
                <value>97ƒ100ƒ109ƒ105ƒ110ƒ</value>
            </setting>
            <setting name="adminpass" serializeAs="String">
                <value>49ƒ50ƒ51ƒ52ƒ53ƒ</value>
            </setting>
        </Settings>
    </userSettings>
        
    

if Anyone Have better Idea Tell me too .....