Part 3: Creating an Admin Controllerhttp://www.asp.netWed, 22 May 2013 16:57:02 GMTumbracoComments for Part 3: Creating an Admin ControllerenComment Posted by dohoaibienhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Sun, 08 Jul 2012 08:16:29 GMT00000000-0000-0000-0000000015939I can't create AdminController.cs. It error SQL connect. Help me

]]>Comment Posted by jasesayinghttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Thu, 12 Jul 2012 14:28:19 GMT00000000-0000-0000-0000000015963Wouldn't the ApiController uri be /api/admin not /api/products?

Great tutorial btw, most of the older web api tutorials from a couple months back are now outdated and no longer work.

Cheers!

]]>Comment Posted by MikeWassonhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Thu, 12 Jul 2012 16:22:12 GMT00000000-0000-0000-0000000015966@jasesaying: Whups -- yes, thanks. I cut and pasted from another tutorial and forgot to update :-)

]]>Comment Posted by tala najihttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Fri, 31 Aug 2012 19:42:00 GMT00000000-0000-0000-0000000016357thanx thanx thanx

]]>Comment Posted by r.h.johnsenhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Mon, 01 Oct 2012 08:29:13 GMT00000000-0000-0000-0000000016558{"$id":"1","Message":"No HTTP resource was found that matches the request URI 'http://localhost:60736/api/Admin'.","MessageDetail":"No type was found that matches the controller named 'admin'."}

No idea what I did wrong. Followed you along all the way, but still get this error message.

]]>Comment Posted by burchswmhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Tue, 06 Nov 2012 19:30:32 GMT00000000-0000-0000-0000000016754Excellent series. But, I couldn't get protected override void Seed(OrdersContext context) to fire...

]]>Comment Posted by r01cnhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Thu, 22 Nov 2012 22:21:34 GMT00000000-0000-0000-0000000016862No the code of AdminController.cs file?

]]>Comment Posted by garfieldzfhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Mon, 26 Nov 2012 21:42:32 GMT00000000-0000-0000-0000000016881@dohoaibien paste your error info.

]]>Comment Posted by ronaldwhhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Sat, 01 Dec 2012 22:35:46 GMT00000000-0000-0000-0000000016910I got a problem when creating the AdminController, I got this error message 'Unable to retrieve metadata for 'EntityFrameWork.Models.Product'. Object reference not set to an instance of an object.'

I already checked several forums and they say it is because my Product class doesn't have ID, but it does have the ID. Can you help me with this?

Thank you,

Best Regards,

Ronald Wisnu Hariyanto

]]>Comment Posted by ronaldwhhttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Sun, 02 Dec 2012 00:24:02 GMT00000000-0000-0000-0000000016912Sorry, I found the issue. I am using .NET 4.5 instead of 4.0

I changed to 4.0 and all work just fine.

Thanks,

Best Regards

RWH

]]>Comment Posted by victorwoohttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Tue, 25 Dec 2012 02:41:21 GMT00000000-0000-0000-0000000017059My return is :

[{"$id":"1","Id":1,"Name":"Tomato Soup".......

Note that it's "$Id" but not "Id". It seems this following line affect this:

json.SerializerSettings.PreserveReferencesHandling = PreserveReferencesHandling.Objects;

So is this article need to update?

According to your suggested article "Handling Circular Object References."

www.asp.net/#handling_circular_object_references

]]>Comment Posted by fenix32http://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Tue, 16 Apr 2013 07:09:59 GMT00000000-0000-0000-0000000018911When Send a Request to the Controller, in the last step, it returns:

<Error><Message>An error has occurred.</Message><ExceptionMessage>The 'ObjectContent`1' type failed to serialize the response body for content type 'application/xml; charset=utf-8'.</ExceptionMessage>

How can I fix it? Thanks ^_^ (and congratulations for this excelent article)

]]>Comment Posted by fenix32http://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Wed, 17 Apr 2013 07:03:06 GMT00000000-0000-0000-0000000018920I would mean, the error only show when I use another connectionString, not the original.

By default, the project create 2 connectionString (2 db), but I want use onle 1.

]]>Comment Posted by fenix32http://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Fri, 19 Apr 2013 05:54:43 GMT00000000-0000-0000-0000000018934My problem is that I want to use SQL-Server, not an static mdf file.

When I change the connection-string in the web.config, users can create the tables correctly. However, the rest of the application models (products, orders, OrderDetails) are not created.

For both use the same connection string:

<add name="DefaultConnection" connectionString="Data Source=SERVIDOR;Initial Catalog=pruebavisualstudio;Persist Security Info=True;User ID=usuario;Password=usuario" providerName="System.Data.SqlCli

]]>Comment Posted by vitorreishttp://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/using-web-api-with-entity-framework,-part-3Wed, 22 May 2013 16:57:02 GMT00000000-0000-0000-0000000019159Hi guys, i get this error while i try to access api/admin

Someone can help me?

{"$id":"1","Message":"An error has occurred.","ExceptionMessage":"The 'ObjectContent`1' type failed to serialize the response body for content type 'application/json; charset=utf-8'.","ExceptionType":"System.InvalidOperationException","StackTrace":null,"InnerException":{"$id":"2","Message":"An error has occurred.","ExceptionMessage":"An error occurred while getting provider information from the database. This ca

]]>