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.
create db driven meta keywords/description. I would store these records in a database, xml format i presume; since it would be per culture.How would i go about doing this?
View 4 RepliesI 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 a simple site [URL]that I setup for my parents and other family member to share recipes on. The issue I have is that when I try to incorporate a google search the header is always RECIPE form from the dynamically driven site.
If page requested is [URL] in a SEO return I want it to have the title of the recipe to be Apple Sour Cream Crumble Pie not RECIPE FORM or RECIPE PRINT FULL FORM
How can I get this changed and also have metadata dynamically created to improve SEO returns?
I have a Gridview connected to an Access database using a Datasource and a query SELECT * FROM [Staff]. In order to update the grid view I have to do it in the IDE and click Refresh Schema. I have tried:
StaffList.SelectCommand = "SELECT * FROM [Staff]"
StaffList.UpdateCommand = "SELECT * FROM [Staff]"
StaffList.DataBind()
Staff.DataBind()
At runtime I want it to update the Gridview.
StaffList.SelectCommand = "SELECT * FROM [Staff]"
I'm having a problem with a FormView control that I have bound to an ObjectDataSource. The problem is that the FormView control is not automatically filled in with the public properties of the object linked by an ObjectDataSource control when I select refresh schema. Everything compiles and I can add fields manually, but there are a lot of properties in the class and I do not want to deal with adding all the fields by hand. It's not the end of the world of course if I have to add them manually, but I'm bothered more by the fact that it doesn't act the other formviews.
Has anyone ever experienced a problem like this? I have other objectdatasource controls with other formviews that properly refresh their schemas. I noticed that in the objectdatasource control that is giving me problems, the DataObjectTypeName field is not automatically set as it is in the others. However, after adding it manually it still doesn't refresh the schema. I'm using Visual Studio 2010. Defined in .aspx page:
[Code]....
The SPFModuleBLL class contains the GetModule2() method which is shown here:
[Code]....
I am not sure why this is happening, but when I drop a GridView on the page and set up the SqlDataSource to point to a stored procedure - when I go to refresh the schema and add my session variable, I get an "Invalid object name #temp_table_Name" I have the appropriate read permissions on the tempdb. The user and password info are correct. The temp table is created in the stored procedure before executing the query.
View 7 RepliesI have defined two endpoints in my App.Config file as
[code]....
I received the following error when i try to launch the host
The HttpGetEnabled property of ServiceMetadataBehavior is set to true and the HttpGetUrl property is a relative address, but there is no http base address. Either supply an http base address or set HttpGetUrl to an absolute address.
How to fix it?
I want to see the meta data files of edmx. mean to say that i want to see the .csdl and ssdl file while using vs2008.
View 1 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 am using the Html.DisplayFor() and Html.EditorFor() helper methods to auto-scaffold a Display view and Edit view for a Municipality entity.
My Application layer is used to retrieve a Municipality class:
[Code]....
For the Display view this entity is mapped to a DisplayMunicipality class containing Display meta data:
[Code]....
For the Edit view this entity is mapped to an EditMunicipality class containing Edit meta data:
[Code]....
This works fine but it requires a lot of extra code, not only the code mentioned above but also all kinds of conversions inside my controller.
Is it possible to put the meta data in the Municipality class that is returned from the Application layer? In that case I need some mechanism to specify that a property should be shown in the Display view or Edit view.
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 have a site where users can save images together with a couple of info fields about the image. The images are stored as binary data in the same table as the rest of the image info. So far pretty standard.
Now, the users should be able to upload a document, describing the image in more detail, along with the rest of the image and its' info.
Size ~2MB per document.
My question is: Should I store this document (binary data) in the same table as the rest of the images or should I create a new table holding only the documents. There would of course be an id reference in the image table to the document in the document table.
I have a search function joining a couple of tables, including the image table, when searching for images. I need to know if there's a difference in efficiency between these two solutions.
I always fetch the document data separately but if I don't win anything in having the documents in a separate table I'll just put it with the rest of the image info.
I'm asking this since I don't really know how SQL Server handle tables when joing and searching in them.
I have about 10´000 users with a maximum of 10 images per user. (ASP.NET - SQL Server)
(I'm not asking if I should store documents in the database, but how ;)
Example:
columns in imageTable - id, title, dateAdded, image (binary data), document (binary data)
Searching for items from a specific user I would join the userTable and the imageTable and select title where image id equals user id.
So, will there be any difference in the performance if the document is in the imageTable or in an own table?
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.
Have a custom FieldTemplate (RadioButtonChooser_Edit.ascx) that shows a radiobuttonlist based on a single character. Using LinqtoSQL/DynamicData enabled.
Example G, F, P (Good, Fair, Poor).
If the custom metadata for a field in the table is set [Editable(false)] I get a G, F, or P. I would like to show the full word when editable is set to false. Not sure how to approach this.
Does anyone have any experience with importing meta data files from Ping Identity into an ACS provider?
I'm logged into my Ping Identity admin system, all fine, no problem. Then, when I export the idP file... no digital signature is included within it and thus I cannot import this file into ACS as it complains that there's no signature included.
I have created database in sql server 2005 using Snowflake model.
Problem :
There is 1 fact table and 3 dimension tables.
Suppose Fact Table has cols : sales_person_id, cust_id, product_id and dimension tables as per id s defined in fact table.
Suppose i want to update products in product table, i am able to do so.
but i can not update product_id in Fact Table because remaining two field will be NULL.
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
using Microsoft.Data.Schema.ScriptDom.Sql;
using Microsoft.Data.Schema.ScriptDom;
By using these namespaces or assembiles , i need to get
1. Params (Name, Length, and Type)
2. Clause Name (SELECT, FROM, WHERE, GROUPBY, HAVING,X-JOIN, etc)
3. Column Name
4. Table Name
5. Column Schema
using Microsoft.Data.Schema.ScriptDom.Sql;
here's the situation:
You're using NHibernate with Fluent NHibernate for mappings.
You have an application in production with a database with live data You're adding a new feature in development and it requires a new database column.
The new column cannot be blank. For example, I recently had to a DateCreated column to a table and the app now uses that date. As the only time the data will be missing is now, it seems unnecessary to add code to check for errors.
In my application I have an updater which can execute a SchemaUpdate to add the new database column - however, the application will starting crashing as it is expecting a value in the new column.
I need to get some sensible default data into that column. In this case I manually ran an Update to set the date to the current date (good enough for the situation). In this particular case I believe that you cannot set the column default to getdate() using fluent mappings.
Keep a schema version number in a config file In the updater that runs SchemaUpdate start adding upgrade methods for each version. These methods would run updates to add default data (or other required actions).
After the schema update has been run, call all methods required for a version greater than the current version (i.e. those that haven't previously been run). So if the app is now version 4 and version 2 is installed, methods 3 and 4 would be run.
I'm working on a new project where I have the luxury of working from a Model to Database approach using Entity Framework 4.
The project I'm working on is taking an agile approach where different phases will be rolled out over time.
Will the Model First approach work in my case? I noticed when you "Generate Database from Model" it recreates the entire schema from scratch which will obviously wipe all the data that is in the db. I was hoping for a more "Update Database from Model" approach where the db would just be altered to reflect the changes rather than recreated
How to add meta tag content dynamically. i have metat tag descriptions in my sql Database. so i need to load it dynamically.
View 3 Repliesi want to change the meta tag or insert some text to it when page is up
View 1 RepliesIn application i want to get other site meta details like title keyword and description
there is text box in which user entred any url and on button click and want to get the meta detials of entered url
i am hari,i am working on asp.net 1.1,i want to update meta tag content in page load, htmlmeta isnot working in asp.net 1.1
View 4 Replies