c# - error - unable to find requested .net framework data provider -

c# - error - unable to find requested .net framework data provider -

i have found plenty of info on subject on stack overflow on web none of seems help.

using system; using system.collections.generic; using system.linq; using system.web; using system.data.entity; using system.componentmodel.dataannotations; namespace geocode.models { public class address { [key] public int arena_id { get; set; } public string address1 { get; set; } public string city { get; set; } public string zip { get; set; } public decimal country { get; set; } } public class latlng { [key] public int arena_id { get; set; } public string lat { get; set; } public string lng { get; set; } } public class geocodedbcontext : dbcontext { public dbset<address> web_arena { get; set; } public dbset<latlng> web_arena_geo { get; set; } } }

and when utilize model create class read/write actions , views using entity framework error, "unable find requested .net framework info provider. may not installed."

my connection string is:

<add name="geocodedbcontext" connectionstring="server=********;database=*****;uid=*****;pwd=******" providername="system.data.sqlserver"/>

the provider providername="system.data.sqlserver" not exist. should providername="system.data.sqlclient".

see documentation on providername. might nice know system.data.sqlclient default value, don't need provide value providername.

c# asp.net-mvc entity-framework connection-string