Is App_WebReferences For WCF Schema Files
Jan 19, 2010Is App_WebReferences for WCF schema files? Should this not be App_ServiceReferences?
Also, what is dynamic compilation in ASP.NET?
Is App_WebReferences for WCF schema files? Should this not be App_ServiceReferences?
Also, what is dynamic compilation in ASP.NET?
I am using LINQ to SQL with C#. Is there a method through which we can generate entity class files from the table schema? By dragging tables onto the graphical designer classes are generated but they are not the real class files(i mean actual files with the extension cs).
I am aware of that we can code the class files first and then create the schema manually or programmatically, but i wanted to know if the reverse is possible, may be using some third-party tools. I feel it will be very convenient to use LINQ that way.
I have a SQL Server 2008 DB with many tables filled with data and I used SQL Server Management Studio to generate a SQL dump by using the Script Wizard : Tasks -> Generate Scripts -> Script All objects in the selected database and also selecting the option to Script Data. I made sure to change the value of "Script for Server Version" to "SQL Server 2008". Then I created a new DB and ran the SQL dump on the new DB to generate an identical copy of the old DB. Then I assigned permissions to my default user to the new DB. Then I changed the connection string on my ASP.NET application to use the new DB. But when I run it, it throws the following exception -
Server Error in '/myapp' Application. The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:.........................
I have upload my files in domain.after uploading,i run the site.i get the following error The EXECUTE permission was denied on the object 'xxxxxxx', database 'zzzzzzz', schema 'dbo'. what reason for this error raised and how to solve it?.
View 2 RepliesI'm used to MySQL and PHPMyAdmin - I had to switch over to MSSQL for an ASP.net project, and I'm having tons of trouble. I'm using the express version of SQL 2008, with SQL Server Management Studio. The following are 2 questions I've been struggling with for a while:
1) How do I export the DB schema for the database? The table structure, etc.?
2) How do I export all the data in the database?
Ideally I'd like to have a .sql file that can be run wherever I need the schema or data duplicated, for example a co-worker's computer for a shared project, or online when the project is being hosted.
I copied the CSS 2.1 xml file and updated it with CSS 3.0 from this cheat sheet [URL] so I could have intellisense for CSS 3.0 Problem: I saved the file as css30 in the
C:Program FilesMicrosoft Visual Studio 10.0Common7Packagesvwd
C:Program FilesMicrosoft Visual Studio 10.0Common7Packages1033schemasCSS
directories however in the build section it has no option for the file, and I cannot find out where to add it. Where can I add this option in the CSS schema dropdown? I will post the file as soon as I get it working. I am also working on HTML 5.0
[code]....
How to write xml schema for xml file
In my asp.net 2008 project, I am using the login controls... In the local sql server, there are all the necessary tables and stored procedures which the system creates for the relevant login controls. All working fine. I notice in the webconfig file there is an entry under connections, i.e.:
<add name="LocalSqlServer" connectionString="Data Source= ...
Now I would like to put the project into the Dev server. What do I do in terms
1- putting my web project into the Dev machine so that we can test it on the Dev server?
2- how do I put the login database schema into Dev? Is it just a matter of restoring my local DB into Dev?...
I want to create a bunch of data entry screens in an ASP.NET application based on a bunch of XSD schemas.
Are there any tools that can be used to do any of the following
1) Read in an XSD schema and generate C# busines objects
2) Read in an xsd schema and generate form controls.
I am writing an iPhone web app for tracking business mileage. The app uses AJAX and HTML 5 manifest caching to enable offline use. The data is stored on the server in a SQL Server database with the following schema:
When there is no network available, the app stores new data in a local database with the same schema using SQLite on the iPhone. Once a connection is aquired, the app automatically uploads the new data to the main database for permanent storage.
Now, here's the question: I have data from two databases with the same schema. How do I merge the new data into the main database using LINQ? The primary key IDs in the new data must be discarded and regenerated by the main database so that there are no ID conflicts, but the two relationships must be maintained properly.
I am making a db schema for facebook like wall structure. I need to save wall posts, share a link, share a video
stuff into my database. Till now I am able to make this schema :
GO
CREATE TABLE [Wall]
(
[ID] [int] NOT NULL IDENTITY(1, 1) ,
[PostText] [nvarchar](MAX)
[PostedByUserID] [int] NULL ,
[PostedOnUserID] [int] NULL ,
[DateCreated] [datetime] NULL
)
GO
Next I have to add the schema for adding the "share a link" and "share a video" feature.
GO
CREATE TABLE [Wall]
(
[ID] [int] NOT NULL IDENTITY(1, 1) ,
[WallText] [nvarchar](MAX)
[PostedByUserID] [int] NULL ,
[PostedOnUserID] [int] NULL ,
[DateCreated] [datetime] NULL,
[SharedLink] [nvarchar](1024) NULL ,
[SharedLinkTitle] [nvarchar](512) NULL ,
[SharedLinkDesc] [nvarchar](512) NULL ,
[SharedLinkImageSrc] [nvarchar](512) NULL
)
GO
Now with this schema:
1st case: When the wall post is inserted the [SharedLink], [SharedLinkTitle],[SharedLinkDesc], [SharedLinkImageSrc] columns will be inserted as null and rest of the columns will have the values.
2nd case: When the "link shared" is inserted the "[WallText]" column will be inserted as null and rest of the columns will have the values.
For my case 70% of the time the wall post will be made and 30 % "links" will be shared which means 70 % of the cases [SharedLink], [SharedLinkTitle],[SharedLinkDesc], [SharedLinkImageSrc] will be inserted as null. Now my concern is that is it okay to keep the null columns inserted or I should go for a separate table for "shared a link" purpose and have the separated table like this:
GO
CREATE TABLE [LinkShared]
(
[ID] [int] NOT NULL IDENTITY(1, 1) ,
[PostedByUserID] [int] NULL ,
[PostedOnUserID] [int] NULL ,
[SharedLink] [nvarchar](1024) NULL ,
[SharedLinkTitle] [nvarchar](512) NULL ,
[SharedLinkDesc] [nvarchar](512) NULL ,
[SharedLinkImageSrc] [nvarchar](512) NULL
)
GO
I have to go in similar manner to add the schema for sharing the videos further. Please guide me in which direction should I move?
i am having a database in mysql and i want to use that database schema in my project using sql server. i have a Nhibernate c#do code generated by mysql. how can i use that code.
View 1 RepliesI'm trying to use a docx read in via the OpenXML SDK as template in a .Net web app for form letters (essentially). I have a docx with the formatting I want, marked up with XML Schema tags defined from a xsd (whatever they're called, the help is exceedingly useless on this).The only thing similar I found on Google was what seemed to be replacing the CustomXmlBlock elements with text elements with the desired data. This seems... messy and fragile.I also have the added complication that some of the data is hierarchical, with elements for sections, and then items in that section. This would seem to completely break the above method.
View 1 RepliesI want to develop a webservice which takes xml as parameter,but it takes only xml which is validated by schema.
I want to attach it with my wsdl so when client send the message data should be varified by schema .
how to create schema like below for my database... and why it usefull
dbo.Employees.EmployeeNumber,
dbo.Employees.LastName + ', N' +
dbo.Employees.FirstName AS [Full Name],
dbo.Employees.HourlySalary,
dbo.TimeSheets.TimeSheetCode, dbo.TimeSheets.Week1Monday,
dbo.TimeSheets.Week1Tuesday, dbo.TimeSheets.Week1Wednesday,
dbo.TimeSheets.Week1Thursday, dbo.TimeSheets.Week1Friday,
dbo.TimeSheets.Week1Saturday, dbo.TimeSheets.Week1Sunday,
dbo.TimeSheets.Week2Monday, dbo.TimeSheets.Week2Tuesday,
dbo.TimeSheets.Week2Wednesday, dbo.TimeSheets.Week2Thursday,
dbo.TimeSheets.Week2Friday, dbo.TimeSheets.Week2Saturday,
dbo.TimeSheets.Week2Sunday
FROM dbo.Employees INNER JOIN dbo.TimeSheets
For configuring my ASP.Net Application I'm using Custom Configuration Sections in my web.config. But I would like to get IntelliSense support for my own-build configuration sections. I figured that it is possible to create a XSD Schema Definition and include that in the web.config. But is there a less painful way of getting that schema?
With Configuration Section Designer I found a tool offering a GUI for creating my configuration section and generating the schema. But I like coding and I don't want to learn how to deal with another GUI.
So, is there a possibility of automatically generating the schema for my code?
I am wanting to duplicate a website that uses the .net membership schema. Specifically I am duplicating the ClubStart Kit V2 and would like to use it's frame work. What is the best way to duplicate this database and make sure that the application ID and .net schema does not clash with each other?
View 3 Replieslook at this code :
[code]...
There is no rows in the schema data table how I can solve this ?I want to get schema for my table and show in the gridview.
I have an xsd that describes XHTML documents. However the application I'm working with may have some selected asp.net controls within to the markup at the point is validated. Therefore the validation fails.
An example control could be:
<smart:Address runat="server" />
I wanted to add a new element to the xsd file but when I specify:
<xs:element name="smart:Address">
I get validation errors as an element name must not have a colon in it.
how I might be able to extend the schema file to allow selected server controls?
I have been thinking about the optimal way to create an XML file using data from a Dataset AND according to the rules of an XML schema. I've been searching around for a bit, and I failed to find a way in which I only take the data from the Dataset and put it inside a XML tags, with the tags being defined by an already-existing schema. So it might go like this:
1- Create Dataset and fill its rows with data.
2- Create an XML according to an XML schema rules.
3- Fill said XML file with data from Dataset such that data is taken from the Dataset while structure of the XML file is taken from the XML schema.
I already may have access to the solution i am after but cant find a way to keep the data and schema the same during deployment, ie development server SQL database to be the same thing as what i put on the sql server host during the deployment of the web application
i was using Quest Rocket compare to sync data and schema, it worked fine but they dropped that project with the intro by MS of VS08, ie the Quest plug-in works in VS05 but not in VS08 anyway, i probably have the solution I am after at my disposal due to my MSDN subscription which includes SQL server products, but my first problem there, is that i cant identify which MS tool to download and to use that will do the same thing or better than the Quest Rocket compare product,
i believe the solution i need is the full version of SQL Management Studio (which i think i have due to my MSDN subsctiption but my second problem 2) is i cant find in that full studio download in my MSDN subscriber area) also is it only the full verison of SQL Mgt studio and not the Express version that might have the "sync" capabiltiy, is that correct? or is there a way (I am a intemediate on SQL techonologies), within the Express Management Studio to painlessly sync both the schema and the data? I am using VS08 Pro, so mayber there is a way in the VSIDE to do the syncing, I think i tried the Publisher but ran into difficulties, am going to try that again and repost here what those difficulties were,
SO really just after a nice tool or utility that will keep SQL database schema and data the same during the deployment process for the web application i build, kinda urgent to as am buried and dont have time to breath.
I have two datasets, one is populated from a SQL Database on my server, the other is populated from an XML file passed from the client server.Both datasets are identical in structure (and potentially the same in data as well)hat I need to be able to do is as follows:-Compare Dataset1 against Dataset2 and record which rows are missing from Dataset2 (based on 2 primary fields)Compare Dataset2 against Dataset1 and record which rows are missing from Dataset1 (based on 2 primary fields)Compare Dataset1 against Dataset2 and record any rows which are different ((based on 2 primary fields always being the same and 3 fields being potentially different)
View 2 RepliesI have 3 different databases where some tables are common.
View 16 RepliesI'm using ASP.Net and NHibernate to build a website. Now, I need to add some sort of administration functionality, and came to think of an old django tutorial I once ran through. Here the admin page was build for me, and I could customize it as I liked. I see no reason that I couldn't accomplish the same, somehow, in ASP.Net, when I got my NHibernate schemas, thus reducing all the boilerplate admin-code I need to do. Are there any libs out there, that you think will fill my needs somehow?
View 1 RepliesI am trying to figure out if it's possible to resolve schemas for tables within a Stored Procedure. If not, I was wondering if maybe I can find a better solution here. Here is my scenario.
I have an application that will access a SQL database that will be used by different organizations within my company. The database will only a have a few tables but it has many stored procedures that will call them. The different organizations will each have their own SQL User and schema with the tables duplicated for each schema. While each schema will have its own set of tables to separate data between the organizations, I do not want to make a copy of each stored procedure since the logic will be the same. I would like the schema to be resolved by the user that is accessing the database. If I do inline SQL within the application it resolves with no problem but using a Stored Procedure will always run it under the owner of the sp, causing it to throw an invalid table name error.
Is there anyway to resolve this or is this just the functionality of MS SQL? Are there any workarounds out there (other than Dynamic SQL) that I can use?