i trying connect database. have following loaded @ top of page:
using system.data.sqlclient; using system.data; here dataset code:
dataset data = new dataset(); using (sqldataadapter dataadapter = new sqldataadapter(command)) { dataadapter.fill(data); } and project.json:
{ "webroot": "wwwroot", "version": "1.0.0-*", "compilationoptions": { "emitentrypoint": true }, "dependencies": { "microsoft.aspnet.iisplatformhandler": "1.0.0-rc1-final", "microsoft.aspnet.server.kestrel": "1.0.0-rc1-final", "microsoft.aspnet.mvc": "6.0.0-rc1-final", "microsoft.aspnet.staticfiles": "1.0.0-rc1-final", "entityframework.microsoftsqlserver": "7.0.0-rc1-final", "entityframework.relational": "7.0.0-rc1-final" }, "commands": { "web": "microsoft.aspnet.server.kestrel" }, "frameworks": { "dnx451": { "frameworkassemblies": { } }, "dnxcore50": { } }, "exclude": [ "wwwroot", "node_modules" ], "publishexclude": [ "**.user", "**.vspscc" ] } it doesn't underline dataset when try build returns error:
the type or namespace name 'dataset' not found (are missing using directive or assembly reference?)
i assume assembly reference talking dependencies. dependency need have access dataset? looked online , found people listing things .dll files without version numbers. can see dependencies don't see place can list file , version required.
dataset under namespace system.data system.data use must add reference system.data assembly.
usually packaged installed .net framework. if using vs follow steps add :
- in project root, right click
references - click
add reference - in popup, under assemblies section, choose framework
- lastly, find , check system.data assembly
