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'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
I have a designer working on several pages in Dreamweaver. The designer is creating .aspx files with the Page directive at the top. These are getting shipped to me and I'm adding them to the Visual Studio ASP.NET WebForms Web Application Project. The problem is that there's no code-behind file by default, and I'm trying to find a shortcut to have them autogenerated as if I've added a fresh page from Visual Studio.
I am in need of generating a PDF document (or some other type of formatted document such as an rtf) on the fly from a weg page. I am aware of components such as PDFLIb, which I currently use on a few applications, however, quite expensive. Would anyone be able to suggest another method or component to do so? I need to have good formatting capability and additionally, not have the URL's display on the page generated, whne printed.
the Sql scripts for ASP.NET Membership Schema's and Table, So that i can just run the SQL script it will create all ASP.NET Membership realted tables,View, Stored Procedure and schema's
i have an already existing schema (in a xsd file). now i need to prepare a report, so in the rdlc page i take a table. now how can i set the schema as a dataset to the table?(i'm getting an error -- "the table 'table1' is in the report body but the report has no data set. Data regions are not allowed in reports without datasets.").
I work with a ASP.NET UI framework that pulls fields for a particular screen off a database. These fields can be associated with particular data fields in another database for binding. The idea with this setup is that if a client needs a new column on a table, they can easily add it, and create a UI field that binds to it without any sort of application restart or recompile.
The problem I've always had with this is that it has meant I'm always having to work with untyped datasets in my code. Are there any ORM libraries for .NET out there that could easily accommodate the requirement of being able to access arbitrary columns in the table schema over and above ones mapped to strongly typed fields?
I need to get data from a database and I need to spit out this data in html formatk using my command line app. For this I am planning to use some sort of template-engine. I was wondering if there is anything in .NET that can do this for me?
The best option would be if I could reuse the asp.net mvc template engine (razor) in my app, this way I should not need to reinvent the wheel.
When trying to generate rdp files on a web server with C#, when I try to save the rdp file it always fails with access denied. ASPNET and Network Services has full access, and even added EVERYONE as full permissions and it still won't save?
if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema. I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain
The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again.
Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.
Class file Conflicts in C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files is preventing me from building the solution. Even though I try emptying out the folder, each time Visual Studio starts the build process, it brings in the class file in to the temp folder with the same folder name. If I restart the machine or leave it overnight, project build without error. Is there anyway to tell Visual studio to delete/ignore/clean any lingering class files that could be in the temp folder?
Clean solution option in VS doesn't work either. Class file in conflict are from the App_Code folder.
I've a WebForm with a HTML table and I need to add hyperlinks in a column. The amount of hyperlinks depend on the rows in a table.Can someone tell me how can I do that?
I am using Linq to create a schedule, which includes columns for creation date, modified date, isSubmited, UserId. Anytime that the schedule is created, I would like to automatically add rows to the ScheduleDays table, which has columns for scheduleId, date, etc.
Currently, I am trying to extend the OnValidate method as follows:
Partial Public Class Schedule Private Sub OnValidate(ByVal action As System.Data.Linq.ChangeAction) Dim day As New ScheduleDay[code]....
This code does not work. Rather, I do not even think that it is getting executed. And if it is, it is not adding the scheduleDays to the database, with their specified values. I get no error message, or anything.Is there a better method to extend, instead of OnValidate? Since, there could still be errors with the Schedule being created. Also, is there anything else in my code that is preventing it from running?
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?.
I have some questions in my mind after went through the video tutorials.
Is Model a entity class type? encapulated attribute and methods (business logic). because i see in videos , people use LINQ to generate models which can only use LINQ to modify/insert/delete data.
Is it a good practice to generate Model using LINQ?
I have a simple entity framework class called "NewsItem" which has 3 properties: Id, PostDate and DescriptionText. To format the postdate property I created a partial class as the following:
[Code]....
This seems to be the way Microsoft has outlined doing it in this link: [URL] It seems as thought he partial class isn't being "picked up" in relation to my entity object as none of the formatting I've tried has done anything. Any ideas on what I've done wrong or might have missed?
got a question regarding form validation via entity partial class. I created my edmx-file with the Entity Data Model. Now I am trying to validate my form inputs via this partial class:
[Code]....
Edmx file and partial class are in the same namespace. But the partial class does not get fired. My controller file looks like that:
Well it's finally time to stop ignoring my unit's need for reports. I keep coming to dead ends. I gave up the crystal reports idea, and ssrs seems a little easier. Now the problem is that I'm creating a report locally on my laptop, then will change the connection string, upload it to my server and have it run against an identical database on the server.
I'm using SQL Server Express locally, and when I try to create a dataset (using the wizard), I can see the tables, but when I try to add one, I get an error message "Could not retrieve schema information for table or view". I looked up this error and there isn't much useful info on it. I guess it some bug when trying to use SS Express? Is there a work around for this? Can I create the report programmatically? Should I use a different kind of reporting service?
