tag:blogger.com,1999:blog-7611915.post2521880847445438962..comments2023-09-25T02:45:01.051-07:00Comments on WriteBetterBits.com - Jim Fiorato's Blog: A Much Simpler Way of Building REST Services With ADO.NET Data Services ("Project Astoria")Jim Fioratohttp://www.blogger.com/profile/04111942317657114808noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7611915.post-20155503975677458512008-02-11T19:55:00.000-08:002008-02-11T19:55:00.000-08:00Hey RazaI figured this out finally. It has to do ...Hey Raza<BR/><BR/>I figured this out finally. It has to do with the primary key name of your entity. See my latest blog post here to see what the issue is:<BR/>http://www.writebetterbits.com/2008/02/common-reason-adonet-data-services-don_11.htmlJim Fioratohttps://www.blogger.com/profile/04111942317657114808noreply@blogger.comtag:blogger.com,1999:blog-7611915.post-18045384853395411432008-02-11T04:32:00.000-08:002008-02-11T04:32:00.000-08:00Hey RazaI've been looking at this a little more, a...Hey Raza<BR/><BR/>I've been looking at this a little more, and it appears to have something to do with your database tables. For instance, if you add a new table, and put that in your dbml, it works fine. I'm going to look some more and see if I can't figure out what it is about the tables that is causing the issue. I've tried switching the database version (it's currently 80), and also altering things like ANSI NULLS, QUOTED IDENTIFIERS at the database level, but no luck. I'll post back when I find anything new.<BR/><BR/>JimJim Fioratohttps://www.blogger.com/profile/04111942317657114808noreply@blogger.comtag:blogger.com,1999:blog-7611915.post-85828288034641457592008-02-04T12:27:00.000-08:002008-02-04T12:27:00.000-08:00RazaWould you be willing to send me the project an...Raza<BR/><BR/>Would you be willing to send me the project and database so I could have a look? jfiorato at gmail dott com<BR/><BR/>JimJim Fioratohttps://www.blogger.com/profile/04111942317657114808noreply@blogger.comtag:blogger.com,1999:blog-7611915.post-70933763851298891532008-02-04T00:52:00.000-08:002008-02-04T00:52:00.000-08:00Hi,Yes there is a parameter less constructor: publ...Hi,<BR/><BR/>Yes there is a parameter less constructor:<BR/> <BR/>public AttendanceDataContext() : <BR/>base( global :: System.Configuration.ConfigurationManager.ConnectionStrings["AttendanceConnectionString"].ConnectionString, mappingSource)<BR/> {<BR/> OnCreated();<BR/> }<BR/><BR/>The "AttendanceConnectionString is also declared in web.config.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7611915.post-20167488625455013362008-02-02T05:09:00.000-08:002008-02-02T05:09:00.000-08:00Raza,If you open up the dbml designer file, do you...Raza,<BR/><BR/>If you open up the dbml designer file, do you see a parameterless constructor that passes the connection string to the base class?<BR/><BR/>JimJim Fioratohttps://www.blogger.com/profile/04111942317657114808noreply@blogger.comtag:blogger.com,1999:blog-7611915.post-76905756515334738282008-02-01T02:28:00.000-08:002008-02-01T02:28:00.000-08:00I'm trying to get this working but keep getting HT...I'm trying to get this working but keep getting HTTP 404 (Not Found) error. My dbml contains one table only, called USERINFO.<BR/><BR/>When I browse to the service page (http://localhost:3356/AttendanceService.svc/), I only get "Default" in the atom:title tags.<BR/><BR/>I get http404 when I try to do ...svc/USERINFO or /USERINFOs<BR/><BR/>This same service works perfectly when I use an edmx model instead of a dbml datacontext.<BR/><BR/>I also created a test function to make sure the linq is working, and it is. But just cannot figure out why the service won't get the right collections.<BR/><BR/>In other words, the following works:<BR/><BR/>public class AttendanceService : WebDataService<AttendanceModel.AttendanceEntities><BR/><BR/>and brings back the USERINFO collection and USERINFO atom:title tags.<BR/><BR/>But the following doesn't:<BR/><BR/>public class AttendanceService : WebDataService<AttendanceDataContext><BR/><BR/>Any ideas?Anonymousnoreply@blogger.com