sql server - Storing complex objects through stored procedures -
i have complex object includes multiple objects through composition.
recommended way persist such object database?
user{ name: dob: address:{ street: zipcode: } accounts:[ {accountid:"",bank:""}, {accountid:"",bank:""} ] ... }
do note collections form part of object.
entity map multiple tables in database - user,address,account....
what recommended way interact stored procedure kind of data structure?
you have 2 options.
you can send data xml server , directly save xml column.
you can store in nvarchar
column specified limit (e.g. nvarchar(1000)
) if possible. otherwise store nvarchar(max)
directly readable. conversion varbinary
or won't useful.
Comments
Post a Comment