I'm halfway through coding a basic multi-tenant SaaS ECM solution.Each client has it's own instance of the database / datastore, but the .Net app is single instance.The documents are pretty much read only (i.e. an image archive of tiffs or PDFs)I've used MSSQL so far,but then started thinking this might be viable in a NoSQL DB (e.g. MongoDB, CouchDB).The basic premise is that it stores documents, each with their own particular indexes. Each tenant can have multiple document types.
e.g. One tenant might have an invoice type,which has Customer ID, Invoice Number and Invoice Date.Another tenant might have an application form, which has Member Number, Application Number, Member Name, and Application Date.So far I've used the old method which Sharepoint (used?) to use, and created a document table which has int_field_1, int_field_2, date_field_1, date_field_2, etc.Then, I've got a "mapping" table which stores the customer specific index name,and the database field that will map to.I've avoided the key-value pair model in the DB due to volume of documents.
This way, we can support multiple document types in the one table,and get reasonably high performance out of it,and allow for custom document type searches (i.e. user selects a document type, then they're presented with a list of search fields).
However,a NoSQL DB might make this a lot simpler,as I don't need to worry about denormalizing the document.However,I've just got concerns about the rest of the data around a document.We store an "action history" against the document.This tracks views,whether someone emails the document from within the system,and other "future" functionality (e.g. faxing).
We have control over the document load process,so we can manipulate the data however it needs to be to get it in the document store (e.g. assign unique IDs). Users will not be adding in their own documents,so we shouldn't need to worry about ACID compliance,as the documents are relatively static.
So,my questions I guess :Is a NoSQL DB a good fit Is MongoDB the best for Asp.Net (I saw Raven and Velocity,but they're still kinda beta)Can I store a key for each document,and then store the action history in a MSSQL DB with this key?I don't need to do joins,it would be if a person clicks "View History" against a document. How would performance compare between the two (NoSQL DB vs denormalized "document" table)Volumes would be up to 200,000 new documents per month for a single tenant. My current scaling plan with the SQL DB involves moving the SQL DB into a cluster when certain thresholds are reached,and then reviewing partitioning and indexing structures.
i am developing a FORUM i am using asp.net, c# language for code. I have read a article about NoSql i inspired a lot from there advantage over RDBMS (sql) so i was thinking that should i use NoSql concept for Forum DataBase or not. I am not a expert in database. So can u suggest me should i use NoSql? Currently I am using sql(rdbms).
i have .doc,.xls,.PPt,.rtf files in the server. How do i implement the print functionality for the user. I have the list of file names and file type. some code samples to print the documents based on the file type. I am using c# 4.0 ASP.NET
Basically I have a asp.net that I need to display an XML document (straight xml, with the tree nodes) I have the sql statement which returns the row names and each one of their values. Just wondering how I should go about doing this?
SQL Server 2008, my query is just a select * from offices, my results is "1","New York","New York City","555-5555" I would like the output to be
<item id="1"> <state>New York</state> <city>New York City</city> <phone>555-5555</phone> </item>
where state/city/phone is the column name, and the value is the value of that column
I have a MVC 2 web application. The website captures grant applications for loans. With each application I can upload documents. The way that we upload documents to the database is as follows:
private IEnumerable<byte> GetStreamByteArrayData(Stream stream) { byte[] buffer = new byte[8192]; int bytesRead = 0; while ((bytesRead = stream.Read(buffer, 0, buffer.Length)) > 0) { for (int byteIndex = 0; byteIndex < bytesRead; byteIndex++) { yield return buffer[byteIndex]; } } }
In my grid that displays the uploaded documents I have the document name, mime type and so forth. What I am trying to do is to have the name of the document in a link. When the link is clicked then the document is opened. I have no idea how to do this in an MVC app. Can someone provide some sample source code?
In my application,i want to check a condition whether the 'ENTER' key is pressed or not.i want to read data from a text file and insert this data to my database.I have written my code in a button-click event.In the text file, every field is separated by a comma so that each field can be identified.After one record,'ENTER' key is pressed and next record is written in next line.so i want to insert each row in the database until the next line.i suppose i can check this with the ASCII code of "Enter" key.
Are there any document-databases, similar to MongoDB, that run within an ASP.NET web application, and could be hosted on a server without any unique machine configuration?
I'm asking this because the hosting provider I'm currently with only support SQL Server 2008 as a database, but I'd like to run my website off a document database.
(Or am I better off going with a specialized database host, such as MongoHQ)?
For the login control that I am using, there is a connectionstring which is automatically created in the web.config file.I ran an .exe file which populated the specified database with all the asp login related tables and stored procedures...
<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localmachineName;Initial Catalog=DBName;Persist Security Info=True;User ID=DBUserName;Password=password" providerName="System.Data.SqlClient"/> How can I point the login control to a different Database based on the database selection by a user i.e. the user can change the name of the database and so the login should point to that database.
I have a Document name column with varbinary(max) type column in my table
first time when i upload document i am storing doc as a byte array
Dim fs As Stream = Me.fileupload1.PostedFile.InputStream Dim br As New BinaryReader(fs) Dim bytes As Byte() = br.ReadBytes(fs.Length)
in my application i have remove atttachmentDoc button, i want to remove uploaded doc from db
so when i pass like this to my storedprocedue
Dim obj As New cls1 Dim bData() As Byte = New Byte(0) {} bData=nothing With obj Dim dt As DataTable = Read_Doc() If dt.Rows.Count > 0 Then If Not IsDBNull(dt.Rows(0)("Document")) Then .Document = bData .Document_extension = "" .Remove_Attachment(Me.Selected_ID) End If End If End With
i got error
dbAccess.executeQuery: Procedure or function 'SP_DML1' expects parameter '@Document', which was not supplied.
I am trying to populate database fields by reading text from a Word or PDF document. Like if a user uploads a file then certain text from that file can be usd to populate a database table.
I want store MS word content in sql server not complete document only content should be save. Is it possible using C# .NET (Windows Application) or ASP .NET.
But, it is showing the following error:SubStatusCode 'Response.SubStatusCode' threw an exception of type 'System.PlatformNotSupportedException' base {"This operation requires IIS integrated pipeline mode."} System.NotSupportedException {System.PlatformNotSupportedException} Headers 'Response.Headers' threw an exception of type 'System.PlatformNotSupportedException'
My IIS version is 6.0 where I published. Donwloading word document can be done only in IIS 7. So, this is the cause of the error. Is there any other way to overcome this problem? Any other code will support lower version??
Is it a good idea to create a document managament system that stores all kinds of documents inside sql server database. This will have infrastructure to accomodate all kinds of applicartions..
I have xml document and wanting to pass it through wcf restfull service, i am able to do that by using string format i mean i can pass the xml as string param in the restful service and it worked but now my xml document becomes huge so if i pass it as string then it gives URI long error. any way i can pass the huge xml document through the WCF RESTFul service.
Both methods successfuly launch the PDF document displaying the document path and title in the title bar. For security reasons I'd like to HIDE the document title. Can someone advice how this can be done? (How can a PDF document be launched without showing the actual document's name)
I want to convert to Word Document in a PDF document. I do not want to use any third party control. I want to do it on my own. Can somebody tell me how to start with it?
