c# - SQL Server Compact Edition with Entity Framework -

-

I try to use SQL Server Compact Edition with Unit Framework in Visual Studio 2008 SP1 What I Do Here :

1) I create a new project, console application.

2) I right-click on the project, choose Add-> New Item. / P>

3) I choose to add a local database named "Something.sdf"

4) In the next page of the "Add new item" wizard, I get the default Dataset name (SomethingDataSet )

Now, in the server explorer, the new database is shown under Something.sdf data connection. 5) I click on the project again, and choose Add-> New item. 6) I want to create a model from the database, in the next page of the wizard, the default name, model 1. amx

7), an ADO unit data model.

Now it asks me "Which of your data connections will you use to connect to the database?". In this dialogue, I can choose between using a pre-built data connection, or creating a new connection.

The drop down is empty with pre-built data connections (I have some of my SDF here?) When I press a new connection, I can only select Microsoft SQL Server, Microsoft SQL Server database file , And - I can not select Microsoft SQL Server CE. If I choose another, the data source is shown as ".NET Framework Data Provider for SQL Server", which I do not want.

What am I missing here? Why can not I select my SQL Server CE database in the Entity Data Model Wizard?

Not sure if this is the same problem, but I think that SEL Server Management Studio Express 2008 CE had to download to get it as an option in the dropdown. However, I give more information to this and give you a better response.

Edit:

If you browse: C: \ WINDOWS \ Microsoft.NET \ Framework \ v2.0.50727 \ CONFIG \ machine.config

You should find the following nodes: 

  & lt; Configuration & gt; & Lt; System.data & gt; & Lt; DbProviderFactories & gt; & Lt; Add name = "Microsoft SQL Server Compact Data Provider" irrevocable = "System.Data.SqlServerCe.3.5" Description = "Net Framework Data Provider for Microsoft SQL Server Compact" type = "System.Data.SqlServerCe.SqlCeProviderFactory, System .Data .SqlServerCe, version = 3.5.0.0, culture = neutral, public keynote = 89845dcd8080cc91 "/>

Let me know that you do not know this.

Edit 2:

I am running VS 2010 Beta 1, and the process you have listed allows me to select SQL CE. However, I removed 2008 And as you get the same result, SQL CE is no longer an option for a data source.

I started my project for the first time in 2008, and for "Microsoft" SQL Server Compact 3.5 ST 1 Beta for Entity Framework Beta 3 ", as explained in the following link:

However, downloads are no longer available. I could not find it anywhere and the link provided by them in this article was broken.

On 2010 After upgrading I found a problem with CE in the same problem I did not have any idea, so I tried to install VS 2008 SP1, and finally I came to know that all that I had to do was add the node I mentioned above to the machine. Configure C: \ WINDOWS \ Microsoft.NET \ Framework \ v4.0.20506 \ Config.

Sorry, I could not help much, but I think my 2008 SP1 is also suffering from the same problem.

Edit 3: It appears that the 2008 SP1 should be 'just work' There is no need to install it. "Compact 3.5 SP1 Beta for the unit framework" But when I tried to install Service Pack 1 for 2008, I still get the same symptom. Just trying to re-install some SQL CE 3.5 components left out of the thought.


Comments

Post a Comment

Popular posts from this blog

MySql variables and php -

-
I am getting an error with php in order to format mysql_query () in php to format this string What is the right way? SELECT SELECT SELECT (*) Agents @AgentCount; User_Agent_English, User_Angent_Oursal, US.___Gent_Aginal, COUNT (User_Agent_Percade) ACC, COUNT (*) / (AgentCount) Percentage by agents user_agent_preser order DEC limit limit 50; In PHP, how am i setting $ query $ query = "SELECT count (*) agents @ agentcount; SELECT user_agent_parsed, User_agent_original , COUNT (user_agent_parsed) ascount, COUNT (*) / (@AgentCount) as a percentage by user_agent_parced by URI date DESC limit 50 "; This exact query will work properly if I put it in MySQL directly through a command line session. Do I need to release two separate php calls from mysql_query () and store the results first? I get the following error: There is an error in your SQL syntax; Instead of using a sub-selection and instead of using the 'SELECT user_agent_parsed, user_agent_original, ne...
Read more

url rewriting - How to implement the returnurl like SO in PHP? -

-
This URL should work even after the rewrite. Is this possible? Otherwise, I can only hardcoded everything If you are trying to create a login system with redirection You need to use the HTTP_REFERER header to find out where the user came from so that you can send it back there. The best way to do this is to use something like this in your login form: // - Login php & Lt; Input type = "password" name = "password" /> & Lt; Input type = "hidden" name = "returnrelale" value = "& lt ;? php echo $ redirectURL ;? & gt;" / & Gt; & Lt; / Form & gt; Please note that some ISP, browser or proxy will delete the referrer header, so you can not rely on each user to work fully. If you use a statement, to check whether the header exists or not, you can send those users back to the homepage or whatever. Edit If you are looking to use $ _SERVER ['REQUEST_URI'], if you are running Apache It sho...
Read more

Which Python client library should I use for CouchdB? -

-
I am starting to experiment with CouchDB because it looks like we have the right solution to certain problems That all the work will be on a new project, which does not have any legacy dependency, which the client library will suggest you use, and why? If we overlap any of the OS. Freeband is available only in the collection of its ports, but asks to use the library's project website. None of those people are Ubuntu, which is only with ships, since those two OSAs are not common in libraries, I am probably installing something from source (and hopefully if I have time, then Ubuntu and FreeBSD People pack the package). For those interests, I want to use CouchDB as a convenient intermediate storage space for data passed between different services - think of a message bus system, but less formalities with. For example, we have daemons that download and pars the web page, then send an interesting bit to other daemons for further processing. Many of them are ill-defined until the...
Read more